J John Vinson Mar 1, 2004 #2 What criteria do I need to enter in order to print todays results? thanks, Ted Click to expand... That depends on how your table records what are "today's results". Do you have a date/time field in the table? How is it filled? GUESSING that you do, and that it has a default property of Date(), just use a criterion of =Date() If the default is Now(), giving the exact date and time, use a criterion of = Date() Click to expand... If the table might have data from the future as well, use a criterion of =Date() AND < DateAdd("d", 1, Date()) Click to expand... If you don't have such a field, you can't do it at all; Access doesn't know or care when the record was created.
What criteria do I need to enter in order to print todays results? thanks, Ted Click to expand... That depends on how your table records what are "today's results". Do you have a date/time field in the table? How is it filled? GUESSING that you do, and that it has a default property of Date(), just use a criterion of =Date() If the default is Now(), giving the exact date and time, use a criterion of = Date() Click to expand... If the table might have data from the future as well, use a criterion of =Date() AND < DateAdd("d", 1, Date()) Click to expand... If you don't have such a field, you can't do it at all; Access doesn't know or care when the record was created.
B Bruce Loving Mar 1, 2004 #3 depends on how you define "Todays" same numeric day? last 24 hours? since midnight? look at like datediff datepart
depends on how you define "Todays" same numeric day? last 24 hours? since midnight? look at like datediff datepart
