So I using Quey to find dates between for example Feb 1 to Feb 28 but when I run the Query this shows upit there a way to fix this issue thanks.
Novice
Windows 10 
Access 2016
So I using Quey to find dates between for example Feb 1 to Feb 28 but when I run the Query this shows up
VIP
Windows 10 Access 2010 32bit
If you change the query to a select query and bring in the WebOrdID do you get any records returned ?
And your dates need to be formatted as #2018/02/01# not with a dash
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
VIP
Windows 10 Access 2010 32bit
@minty - dash will work - sql will assume it is yyyy-mm-dd (ie. 1st Feb in the example provided) - something I learned only recently
@King - not sure why you need the other tables since you are not applying any criteria to them.
Very Inert Person
Windows 10 Access 2016
What do you consider the "issue" to be?it there a way to fix this issue thanks.
The fact that zero records are about to be updated? That you get the prompt at all? Aside from the observations already made, more info about the desired outcome and what's going on would help, including showing the complete parameter prompt and criteria.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Command Buttons Only Work If DB Opened In Design View Then Form View
Posting Permissions
Reply With Quote