Date()

[jwindon]

This worked a day or two ago. I created a query that pulls all the records entered on a current date. I am using the Date() criteria. It worked until today. Now it is only pulling the last record entered today. Any ideas on what's going on here?

 

[Chris RR]

Are you absolutely sure that more than 1 record was entered today?

 

[jwindon]

Yes. I opened the table to check. Now I found some errors in the tables that were joining the information in the query. My joins have SOMETHING to do with this. I realize now that each of the four tables I'm pulling information from (for equal joins of all four on ONE field) MUST have a match to execute. Now I have to audit the four tables to make sure that the information is there. That seems to do the trick.

I hate pulling in data from other people because I run into this a lot, but I have to start somewhere.

Thanks.