Okay so in my computer class I was taking a test on queries on access. Piece of cake. Well the database is setup with 2 tables. One is called agent and the other is policies. Last question ask to make up a report that had the names of the agents from one table and 4 other items from the policies table. Well I went into wizard started to add the items and when I got all that I wanted I clicked next and it gave me this error about how the table are not in relationship with each other. Told me to set that up and then I could make my reports. I was like wtf? I looked thru the book and found nothing about relationships. When they created a report in the book it was all from one table not two different tables. So me being the smart one I went into Microsoft help and got information on how to make a relationship. Well I get to relate I go back into wizard and it takes the changes. No relationship errors. But when I click finish the report the report comes up all blank. No names, polices type cost or nothing. It has the outline and that’s about it. im stumped what am I doing wrong? I get to finish my test Wednesday and I need some help guys
If a relationship is defined (at least in the query) then you should see a line connecting the two tables by those fields.
If you establish a default relationship, then at least one record in each relating field must match or your results will be NULL.
example: table1 and table2 have the default (one-to-one) relationship created between fields NAME & WHOLENAME
table1:
name
weight
eye color
table2:
wholename
address
phone number
If [name]=DVNT1 and [wholename]=DVNT1 then the 1st matching row in each table will be passed through, else it won't show anything. (again, this is with the default one-to-one relationship)
You can define relationships within the queries or within the Relationship Manager (under TOOLS|RELATIONSHIPS I think)
Linear Mode
