1 query two different tables

[TToc2u]

I've been using access for a while, but I've always used the query wizard so i never developed any complicated query’s. I currently have two tables that record different data, but are related and I would like to combine them so that I can display the all data in a report.



Is it possible to do something like: display all records of table 1 grouped by name, and append data from table2 where the dates match?

This isn’t actually my database but for an example:
lets say I have a table that has customer information, name, address ect.
and I have a second table that has general information that i want to apply to all customers that visited that day. lets say...um... the weather that day. (not necessarily related but just as an example)

I would then have one from to record customer information(several records per day) and another form to record the weather(once per day).

could i combine the data into a new table somehow, if they both had = date fields? Something like
if(table1.date_field)=(table2.date_field) then add table2 field 3-6 to the records on table 1.

In summary I am trying to avoid having the user input the "weather" information more than once if it is the same for every other record that will be recorded that day.

[June7]

No reason to combine into a table.

Use form/subform arrangement for data entry.

http://office.microsoft.com/en-us/ac...010098674.aspx

For output on a report, use a query that joins the tables on common fields. In your example that would be the date.

http://office.microsoft.com/en-us/ac...005188568.aspx