popup dialogue box for a query
Posted on 2001-06-18
It's an Access 2K database with ODBC links to an MS SQL 2K table. I've got a Make Table query to thin out the records. The field is bill_month and it's text.
If I specify the Criteria in the query (either as "04-00" or "Between 04-00 and 12-00"), it works fine.
If I set up the Criteria as a popup dialogue box (as in [Enter Bill Month]), it will work for a specific instance ("04-00") but the between command finds zero records.
What's going on here? Thanks for the help,