MSAccess Query Blues

[kaharthemad]

ok running into a small problem. I am trying to simplify 12 different excell spreadsheets that a small group of IT techs use on a daily basis into one access database. I have all but one part of the database complete but i am having a problem with my queries.

I have to generate a report each date with the tickets I have generated and or work orders completed. My problem is that when i generate the query it does not show any of the ticket generated that day.
I have it set up with a field in the query called "datecreated' with Now() for the input. I have limited the date group to just '##-##-##'

In my query I have placed the following in the Date created area's criteria

Between Date and Date+1.



What am I doing wrong on this?

If need be I can edit the data and post a link to download if it would help.

[Naethyn]

I've not worked with MSAccess much but I do know that you're trying to add an integer to a date time variable. Use the DateAdd() method to increment the date variable.

http://www.techonthenet.com/access/func ... ateadd.php

[Lueyen]

can you post the sql from the query? Access generate SQL is usually god awful, but It will show exactly what your query is doing.

Oh and "##.##.##" as a format filter may do very different things then you expect, Use "mm.dd.yy" instead.