Need some help at adding new table in query

R

Ron Weaver

I am new at this and need some direction. After creating a 2 table database
with forms and reports, etc., I realized I needed to catagorize the accounts.
I have spent two days inputing data. Today I created a new table, 'Catagory'.
When I try to add it to a query, with the table 'Accounts', the datasheet
view goes blank (no records). I need to be able to pull these accounts up by
catagory as well as by name. Do I need to start over? The new table has a one
to many relationship with the 'Accounts' table.
Thanks for any advice.
 
R

Ron Weaver

I got it working. I went into the 'Accounts' table and filled in the
'CatagoryID' numbers. The query works now. I will try to proceed.
Thanks
 
K

Ken Snell \(MVP\)

Post the SQL statement of the query (SQL View); likely, your join(s) between
the tables are not set up the way you need them to be.
 
Top