• ...how to prompt the user for one of more values to filter a View?
  
• ...how to filter my transactions to show only those older than 60 days?
  
• ...how to see all the items a customer bought this month?
  

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?

---

AND(
  UPPER(TRIM({Item #}))>=UPPER(TRIM(QUERYSTRING("Starting item?", ""))),
  UPPER(TRIM({Item #}))<=UPPER(TRIM(QUERYSTRING("Ending item?", "zzzzzzzzzzzzzzzz")))
  )

 Trx Trx
 Src Type Description
 1   1    Receipt
 1   2    Receipt adjustment
 1   3    Receipt return
 2   1    Shipment
 2   2    Shipment return
 3   1    Adjustment credit 
 3   2    Adjustment debit
 4   1    Stock transfer from
 4   2    Stock transfer to
 5   1    Component item assembly
 5   2    Master item assembly

Quote:

---

How about if someone wrote a "GridView for Dummies" book. I'll volunteer as a model for the front cover.

---

{Units sold Period n}<>0

{Units Sold Period 1}
{Units Sold Period 2} 
{Units Sold Period 3} 
{Units Sold Period 4} 
{Units Sold Period 5} 
{Units Sold Period 6} 
{Units Sold Period 7} 
{Units Sold Period 8} 
{Units Sold Period 9} 
{Units Sold Period 10} 
{Units Sold Period 11} 
{Units Sold Period 12} 
{Units Sold Period 13} 
{Units Sold YTD} 
{Units Sold LY}

({Units sold Period 1}+ {Units sold Period 2} + {Units sold Period 3})<>0

Quote:

---

Have you turned the filter on and selected the filer you created?

---

Quote:

---

There is a button on the toolbar for enabling or disabling the filter. If you are using the current version, it is to the left of the drop-down field where you can select filters. Or from the View menu, pick 'Toggle Filter' (or Shift-F6).

The purpose of having a way of immediately disabling the filter is while you are creating the view - it's a great way of testing to make sure the filter is reading the records you mean it to. If you enter a filter and the listed records are not as you anticipated, you can turn the filter off, check which records are (not) appearing, and then modify the filter accordingly.

---