Please please please

[neileg]

I´ve realised why the records weren´t showing. Basically because I had linked tables and they wouldn´t display the ones with null values.

So I presume you fixed this by changing the join type between the tables?

 

[dazedandconfused]

its hard without seeing your code.
Does it look like its pulling out entries where date > startdate AND entries where date < enddate?
Or is it just pulling out entries where date < enddate regardless of its relationship with startdate?

was that a clear question?

Clear enough.

The code is as I quoted in the previous post as in the criteria part of the query. It doesn´t seem to regard the dates at all. It just pulls out all the records.

 

[dazedandconfused]

So I presume you fixed this by changing the join type between the tables?

Yes, thanks

 

[dazedandconfused]

Sorry to resurrect this old thread...

This date issue is the only thing that isn't working now. The rest of the database is fine and dandy.

On the records that I want to pull out, the dates have to be entered as mm/dd/yy and then Access reformats them to display the dates as dd/mm/yyyy and they are also stored this way in the table.

But...it still disregards the date control on the query...???

 

[boblarson]

If it is just a date and not date and time then it would be:

Between "#" & [Enter Start Date] & "# And #" & [Enter End Date] & "#"

 

[dazedandconfused]

If it is just a date and not date and time then it would be:

Between "#" & [Enter Start Date] & "# And #" & [Enter End Date] & "#"

Thanks Bob. I forgot to mention that I'm stupid though. Do I copy and paste this into the criteria section of the query? The statement currently in the criteria part that isn't working is '>=[enter startdate] And <=[enter end date]'

 

[boblarson]

Yes, it is the criteria, replace >=[enter startdate] And <=[enter end date] with what I wrote.

 

[dazedandconfused]

Thanks but when I did it I got the following error message:

'You did not enter the keyword And in the Between...And operator

The correct syntax is as follows:
expression [Not] Between value1 And value2'

So what to do?

 

[neileg]

You seem to have some unneeded apostrophes in your posts. If these are actually in your queries then you'll get errors.

 

[boblarson]

Post the exact criteria you wound up using

 

[dazedandconfused]

If it is just a date and not date and time then it would be:

Between "#" & [Enter Start Date] & "# And #" & [Enter End Date] & "#"

Exactly what you wrote above ie:

Between "#" & [Enter Start Date] & "# And #" & [Enter End Date] & "#"

 

[boblarson]

Sorry - I should have tested it first. It actually is just:

Between [Enter Start Date] And [Enter End Date]

 

[dazedandconfused]

Thanks! I appear to be set up and working!

 

[boblarson]