queries

[r]

Hello, Im having a problem with some of my queries. The
situation is the following: I have created all of the
tables and their relationships and then I created queries
where I used several tables to get fields to put into my
forms. The problem is when I add more than three tables
into my query the database acts like it's reffering to a
whole new set of fields. For example if I had one query
that contained the following three tables: Personal info,
address info, and submission info, and I entered
information into these tables using a form that was ok.
The problem is when I created another query using those
same three tables and adding another table to them, the
information from those tables was not read into the new
query. Is there any logical explanation for this?

Thanks!

 

[[MVP] S. Clark]

If there is an inner join between the tables, and there is no matching
information between the tables, then it would be logical that no information
is shown.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-