I want some queries to automatically look at the current date.
I hqve some fields, which are text fields with the input mask:
99"-"99"-20"00;0;
dd - mm - yyyy
I want the system to find the current dat in this format, and then only show the reservations AFTER and ON the date of today, but I can't figure it out.
One of the queries looks like this:
SELECT tblReservation.dat, tblReservation.programcode_ID, Sum(tblReservation.number_pers) AS Total, tblPrograms.program_name, Count (tblReservation.redervatiunnumber_ID) AS [# Reservations]
From tblPrograms RIGHT JOIN tblReservation ON tblPrograms.Programcode_ID = tblReservation.Programcode_ID
GROUP BY tblReservation.date, tblReservation.programcode_ID, tblPrograms.program_name;
With this query, I want to see al reservations, sorted by date, which show Date, name program, number of people and number of reservations.
Currently it shows all dates, but I want it to show all dates from now, including today.. I tried some code, but it doesn't work.
Maybe the solition is something with using a date/time field instead of a text field, but then I can't use the date format dd-mm-yyyy
Please help me out on this one!
I hqve some fields, which are text fields with the input mask:
99"-"99"-20"00;0;
dd - mm - yyyy
I want the system to find the current dat in this format, and then only show the reservations AFTER and ON the date of today, but I can't figure it out.
One of the queries looks like this:
SELECT tblReservation.dat, tblReservation.programcode_ID, Sum(tblReservation.number_pers) AS Total, tblPrograms.program_name, Count (tblReservation.redervatiunnumber_ID) AS [# Reservations]
From tblPrograms RIGHT JOIN tblReservation ON tblPrograms.Programcode_ID = tblReservation.Programcode_ID
GROUP BY tblReservation.date, tblReservation.programcode_ID, tblPrograms.program_name;
With this query, I want to see al reservations, sorted by date, which show Date, name program, number of people and number of reservations.
Currently it shows all dates, but I want it to show all dates from now, including today.. I tried some code, but it doesn't work.
Maybe the solition is something with using a date/time field instead of a text field, but then I can't use the date format dd-mm-yyyy
Please help me out on this one!