Hi there
Programmers have made a change in the database format for dates. This is causing query to not pull all the results.
Before the date format was mm/dd/yyyy: 00:00:00:000
to mm/dd/yyyy 05:00:00:000. This is causing my pre-existing access query that is either simple prompt to users to enter start date and enter end date. Where they enter 04/01/2015 and 04/30/2015 or some of the queries have date specified as
...

Thank you all for the suggestions. I will try them out today

Hi there
I have a 20 character string and I want to get the numbers from position 10 to 14 when they are equal to 5600
I did my access query in design mode as follows but I keep getting syntax errors
NumbA: Mid([fieldname],9,4)
under criteria I put 5600

Could someone please help and tell me what is wrong with that ?