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?

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

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.