var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: no records showing, please help me check syntax
i have created a query to check for records between two dates.
its brings up no records but there are in the table
I have a jobDate field in the table.
in the query for criteria in jobdate i have
Between date() and date()-"6"
i am checking for all records between now and 6 days ago.
It works for me.
Is your jobDate a Date/Time-field? Are there other conditions in your query that may prevent the data from showing?
i do have a field which checks to make sure the product has not been returned, i just check to see if it is null. i have checked without, i have tried to change the field in the table to a text and datetime, i must be overlooking something.
thanks for the reply
Between date() and date()-"6" ??
Why do you use Apostroph, just use
Between Date() And Date()-6
I tried both, and both work for me. (Access 2000)
Originally Posted by
sorted it out, the field had to be set as short date.
thanks for the help