By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,504 Members | 1,448 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,504 IT Pros & Developers. It's quick & easy.

How to run multiple queries and display in form/grid style

P: 1
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 "Travelocity" 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
Apr 29 '10 #1
Share this Question
Share on Google+
2 Replies


Jim Doherty
Expert 100+
P: 897
Can you not not just create separate forms for your queries then mount those forms as SUBFORMS on your main form?

Welcome to Bytes :)
Apr 30 '10 #2

NeoPa
Expert Mod 15k+
P: 31,186
As Jim says, Forms can be populated with various subforms, and so too can reports (with subreports). It sounds like this understanding may help you to find a solution appropriate for your requirements.
Apr 30 '10 #3

Post your reply

Sign in to post your reply or Sign up for a free account.