Search results

Pat, No its not a pass-through query. Any other ideas what this might be? Garry

Hi All, I Am still having the same problem with my parameter query, but have tracked the problem down further using the tracing option in ODBC. To sum up:- If, in the criteria of my query, I hard code the dates thus - 'BETWEEN #03/09/01# AND #09/09/01#', the query works fine. The output in...

Rich, Do you mean have a form with two text boxes to fill in the dates, and then a button to start the query referencing the dates on the form? I shall give that a try tommorow and post the result. Many thanks. Garry

This is what I did. In the query parameters, I entered [Enter Start Date] as a Date/Time type. In the criteria for the field I entered >= [Enter Start Date]. I gather that this should work, but it returns an ODB--Call Failed error. The total part of the field in the query is set to...

Chris, Thanks for the response. I tried what you suggested, but got the following error :- 'the expression you entered has an invalid date value' So I then tried the following :- >= "#" & [Enter Start Date] & "#" This too produced an error, shown below. 'The expression is typed...

Hello all, I have a very frustrating problem with a query that is accessing a linked table via ODBC (actually a UNIDATA table) If I want select records greater than a certain date, I can put '>= #10/08/01#, and it works. However, if I then put a parameter query with the criteria of '>= [Enter...