Search results for query: *

Yep - its working finally [thumbsup2] Thanks for the help.

If one beats one's head on a brick wall long enough you'll either break through or come to a realisation .... The [Dispense History].Major and [Dispense History].Minor were NOT being found due to them not being selected individually! They were referenced but wrapped up by an AS clause - this...

I deleted occurances of [Dispense history] in strWhere - now it asks for "Major" and "Minor" grrrrrrrrrr

The reports record source is the SQL query at the start of this thread - it does include [Dispense History]![Major] and [Dispense History]![Minor] in the first few expressions after SELECT - and in the WHERE clause those are referred to as [Dispense History].Major and [Dispense History].Minor...

I am having a problem with the query - I am being asking for "Dispense History.Major" and "Dispense History.Minor" Both fields do exist in the table - and it appears that Access is finding the table as I am not asked for any date input. I am out of ideas as to why that is...

So "WHERE" should be left in the SQL I take it

I am not too sure if I follow you correctly...but here goes All I need to do is to truncate the SQL string from &quot;WHERE&quot; to the end then pass a string at the end of the DoCmd line? &quot;1=1 AND [Database date]>=#Users start date# AND [Database date]<=#Users end date# AND [Database...

I am trying to modify a database (That works) written by a predecessor, to be more user friendly - I need to pass four variables to a report/query. It currently uses dialog boxes that I presume are the query asking the user for input. No forms are designed for this input. There is no provision...