My Queries dont work

[Harold via AccessMonster.com]

Hi,
Im having problems with running queries. If I run them on my Address and
Event table they work but when I include my Business table I dont get any
records. These are my tables:

tblAddress
AddressID - Primary key
StreetNumber
Direction
StreetName

tblBusiness
BusinessID - Primary key
BusinessName
BusinessPhone
ContactName
ContactPhone
AddressID - Foreign key

tblEvent
EventID - Primary key
DateTimeOS
DateTimeIS
Reason
SystemType
DownTimeEst
Notes
CalledOSBy
AddressID - Foreign key

The two lower tables are linked to the address table by AddressID. The
foreign keys are set to Yes (Allow Duplicates)and they are Number , Long
Integer.

Ive worked and worked on this and I just dont understand how to get it to
work. Please help.

Harold

 

[Marc]

Hi,
Post your query syntax, it will be easier to help. In the query builder
window, click SQL.
Marc