B
Bayou BoB
Hello There!
I have a form that has 2 subtables in it, that display today's medical
appointments, and today's program activities respectively.
When user's enter scheduling information for the month they enter the
date and time into a scheduling form for each appointment and
activity. They enter the date and time of these activities and
appointments into a field called ActDate (actual date of
activity/appointment).
I have made a query based on the scheduling table. Due to having date
and time in the same field, I created an expression in the query to
return "Today's" appointments. The expression I used for this is:
Int([ActDate]). This gives me the numeric value of the actual date and
time entry. In the Criteria of the query I simply placed: Date(). This
is effective in allowing the user to call up "Today's Schedule" (the
viewschedulefrm) and see just today's activities.
I'd like to copy this query however, and add a feature where the user
can click a button much like the one calling up "Today's Schedule" and
be able to enter the date they want to look at, and see the results
for that day they select. I have tried using [Enter Date to Check] as
the criteria in the above expression I created, in place of Date() and
it doesn't seem to work at all. How can I have the user simply type
the date in and get the results they are looking for? What do I need
to replace as the criteria here in place of Date()...? Many thanks. I
hope this made sense.
Kevin
I have a form that has 2 subtables in it, that display today's medical
appointments, and today's program activities respectively.
When user's enter scheduling information for the month they enter the
date and time into a scheduling form for each appointment and
activity. They enter the date and time of these activities and
appointments into a field called ActDate (actual date of
activity/appointment).
I have made a query based on the scheduling table. Due to having date
and time in the same field, I created an expression in the query to
return "Today's" appointments. The expression I used for this is:
Int([ActDate]). This gives me the numeric value of the actual date and
time entry. In the Criteria of the query I simply placed: Date(). This
is effective in allowing the user to call up "Today's Schedule" (the
viewschedulefrm) and see just today's activities.
I'd like to copy this query however, and add a feature where the user
can click a button much like the one calling up "Today's Schedule" and
be able to enter the date they want to look at, and see the results
for that day they select. I have tried using [Enter Date to Check] as
the criteria in the above expression I created, in place of Date() and
it doesn't seem to work at all. How can I have the user simply type
the date in and get the results they are looking for? What do I need
to replace as the criteria here in place of Date()...? Many thanks. I
hope this made sense.
Kevin