I have created a query in MS-Access that reads the Invoice Header table from MAS90 and selects a group of records by a date range on "InvoiceDate". This works great as long as the dates are hardcoded in the criteria cell.
Example: Between #03/01/02# and #03/31/02#
I need to covert the hardcoded dates to parameters:
Example: Between [BeginDate] and [EndDate]
When I run the parameter query and it asks for the "BeginDate" and "EndDate" variables I get a "Conversion Error" returned from the ODBC driver.
Does anyone have any suggestions on resolving this?
Thanks,
ProdOps
Example: Between #03/01/02# and #03/31/02#
I need to covert the hardcoded dates to parameters:
Example: Between [BeginDate] and [EndDate]
When I run the parameter query and it asks for the "BeginDate" and "EndDate" variables I get a "Conversion Error" returned from the ODBC driver.
Does anyone have any suggestions on resolving this?
Thanks,
ProdOps