Query to display ONLY entries from today

[Juan4412]

I want to run a query that will only display the records that were input into the database TODAY, but I do not want to have to input the date on the query. If that makes sense; I want the query to prompt you to enter what user they want to query, and then display records for TODAY, not prompt asking what day to display records from. Is that possible?

[ajetrumpet]

I don't think you can do it unless you have a resource built into the tables that tells you when it was entered.

do you have that? If not, I think you're out of luck. One way to do it would be a hidden field on your form with a default value of "date()".

But regardless of that, you have to filter your query with a date of somekind. You have no choice. sorry

[Juan4412]

My table does display the date/time that the record was entered. Is that what you are referring to?

[ajetrumpet]

My table does display the date/time that the record was entered. Is that what you are referring to?

yes, use that in the query. you can't leave it out. it's not possible

[Juan4412]

Simply adding my "date_entered" field to the query will cause the query to only display the records entered from today?

[ajetrumpet]

Simply adding my "date_entered" field to the query will cause the query to only display the records entered from today?

are you familiar with queries Juan?

you need a criteria clause. eg:

select ........... from.........

where date_entered = date()

make sense?

[Juan4412]

Somewhat. Could I set the date_entered = Today(), or if I chose Now(), would that be able to provide the records from that day only?

[ajetrumpet]

Somewhat. Could I set the date_entered = Today(), or if I chose Now(), would that be able to provide the records from that day only?

I don't think so, but you can try it. That includes time as well and it'll always return 0 records if that part is indeed included.

Trial and error, Juan.

If it doesn't, parse the date out with a date function...

[ajetrumpet]

I'm sorry Juan. I left you hanging there a little I guess.

If you want to parse the date out of the NOW() function-based field of yours, you can do so like this:

SELECT ........... FROM ...........

WHERE datevalue([date_entered]) = date()

[Juan4412]

That makes more sense. I can do the trial-and-error to determine what will work, and what will not work. Thank you for your assistance in this matter.