Quote:

Just a thought on how you may be coming up empty.

Could it be that you are not being as precise as needed in filters when you use "And" and "Or"? In English, you can say "Show me the clients in CA and NV" and people would understand that you want to see the clients in CA and the clients in NV, but the computer interprets it as "Show me any client who is in both CA and NV". Since no client record can be in CA and in NV at the same time, your filter won't let any records through.

What you need to say is "Show me the clients in CA or NV" which will be interpreted as "Show me any client in CA and show me any client in NV".

Make sense?




Yes, that does make sense. However, my problem is not with logic, but rather with formating. I am not sure when to trim, or how to format a trim, or how the "trx codes" in inventory work. For example, both Assembly Masters and Shipments get a "trx code" of 1. How do I limit the view to only Assembly Masters?

I also can not figure out how to make a veiw "ask me" for a range of items numbers or dates upon refresh.

I assume that the webinars are going to be my "go to" for learning these aspects.

I appreciate everyone's input.