Need some help at adding new table in query

G

Guest

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.
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top