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

Creating a letter in Access with data from unrelated tables

P: 33
I have a form were users select data from 3 unrelated tables (combo boxes) and enter info in 1 text box(a date field). I need to pull data from the 3 tables based on the users choices and the info entered into the text box on a report (letter that will be mailed out). What is the best way to do this, or can it even be accomplished? I've tried a few different things with no success. Thanks for any suggestions you may have.
Feb 28 '08 #1
Share this Question
Share on Google+
1 Reply

P: 32
Depending on how you want to format your letter you could use sub reports on the report. You would just have the data pull a query for each report.

Another way would be to use a temp table and have queries append to the temp table and use that for the report.
Feb 28 '08 #2

Post your reply

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