How do I go about making this type of report?

[menstroy]

Hello,

I want a query to be interactive. I want it to be in a form or to prompt the user to enter a Username and Date and pull back all the records that match, and then populate that infromation into a report so that I can format the infromation and print it out... (a mailing list kinda)


I have a database that is not normalized, I have 20+ tables that are farely duplicate. The fileds consist of

ID - Key
CreateDate
CreatTime
CreatedBy
FirstName
LastName
Address
City
State
ZIP

I went into the query editor and created one that will search and pull back all the records from all the tables (25) based on the records that were created on a certain date and by a certain user.. (I created a query that worked on one table, and copied it for the next table and put a UNION between the selects)


Any suggestions would be greatly apperciated.

 

[jrbarnett]

Menstroy,

If you don't mind putting your output on a report, a fairly easy way of doing what you want is detailed in this FAQ:

http://www.tek-tips.com/faqs.cfm?spid=702&sfid=3619

Your query won't be wasted though as it can be used to provide a data source for the report.
By the way, your table source above looks fairly normalised, it will only be denormalised if you keep the same data in multiple tables.

You also say you enter information on username - this doesn't seem to be stored in the table.

John