Query Help needed

[wirelad]

Hello,

I have 4 forms - 4 tables that stores data from each form.

I want to create a report that shows 4 or 5 fields from each form

EG.

Form1 = Products
text1= date
text2= time
text3= name

Form2 = Prices
text1=date
text2=time
text3=name

So On....4 x's different form titles

All the forms store the same data - they just cover different products.

I want the report to show me a list of all the data fields needed.

What's the best way to complete this task?


Thanks

Mike

 

[Lynn Trapp]

All the forms store the same data - they just cover different products.
That sounds like your database is in bad need of being normalized. Could
you post the structure of your tables?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html