Hello,
I have a database in Access2003. I have set up several queries that use the parameter entry [Enter serial number, SN:]. Each query produces different outputs from various tables that go into a report. Sometimes, a report calls for more than one query using the same serial number. Is there a way to not require the operator to input that same parameter for every query short of building a hugh query for all the data for that report?...

Thanks for your reply, Nico.

I will study your last response and try to implement a solution to the problem I posed. I'll assure you I'll get back to you when I need more help. Meanwhile, is there a VBA for Dummies or equivalent that will catapult me to more understanding in writing or understanding this code? Perhaps that has been asked in previous messages. I'll search the archives. If someone finds it, please let me know....

Thanks for your response.

Most of the time, testing is only done once a day but where multiple testing is likely, I would use time of day also. I think a maximum number of columns might be an acceptable way to go about accomplishing this task.

Now, what's the best way to learn about VBA coding that I'm apparently going to need to use to make this happen? I need to learn this fast or perhaps be able to "buy"...

Hi.
I'm new to this database world. Just started Access training a few months ago and have a somewhat complicated database already built. In a nutshell, I have a select query that uses a parameter callout so the user can enter a serial number of a widget and get test information for a report. The query pops out the test data in, for simplicity, in two columns, rest result Type A and Type B. The challenge for me is getting the results broken...