Greetings all,
I am trying to create a form in access 2007 that will return multiple queries (count). I have an appointment table and based off of the date selection I want a grid similar to "Cheap Tickets" or "Travelocit y" to return the day off (count) 1 day after, 2 day after, 1 day before and 2 days before - all counts. The queries work but I can't figure out how to get them on the form. Do I need to create a separate table? I'm stuck.... I also plan to import the table into a web page so the end product would be like this: Input your date > A grid comes back with all the counts > You click on the count and it displays the selected counts with an option to select it.
I will be forever in your debt if you can assist with this!
Thanks,
Digi
I am trying to create a form in access 2007 that will return multiple queries (count). I have an appointment table and based off of the date selection I want a grid similar to "Cheap Tickets" or "Travelocit y" to return the day off (count) 1 day after, 2 day after, 1 day before and 2 days before - all counts. The queries work but I can't figure out how to get them on the form. Do I need to create a separate table? I'm stuck.... I also plan to import the table into a web page so the end product would be like this: Input your date > A grid comes back with all the counts > You click on the count and it displays the selected counts with an option to select it.
I will be forever in your debt if you can assist with this!
Thanks,
Digi
Comment