Query return duplicate results

  • Thread starter Thread starter Bill.Carlson
  • Start date Start date
B

Bill.Carlson

Access 2007

we are a small cpa firm processing Quicken information for a client
we have a table, tblTrnsctnQkn comprising Quicken transactions (Date,
ckNmbr, Amount, Category)
we have a table, tblMap, that maps the Quicken category to our
internal AccountNumber structure (Category,AccountNumber)
I'm trying to create a query that will return all records from
tblTrnsctnQkn and the corresponding AccountNumber from tblMap, Date,
ckNmbr, Amount, Category, AccountNumber
I've joined the tables using the respective Category fields, selecting
all records from tblTrnsctnQkn and only those records from tblMap
where the joined fields are equal..

The query returns 2 records for each transaction (400 records in
tblTransctnQkn, query returning 800 records)

What am I doing incorrectly?

As always, help is much appriciated,

Bill Carlson
 
Access 2007

we are a small cpa firm processing Quicken information for a client
we have a table, tblTrnsctnQkn comprising Quicken transactions (Date,
ckNmbr, Amount, Category)
we have a table, tblMap, that maps the Quicken category to our
internal AccountNumber structure (Category,AccountNumber)
I'm trying to create a query that will return all records from
tblTrnsctnQkn and the corresponding AccountNumber from tblMap, Date,
ckNmbr, Amount, Category, AccountNumber
I've joined the tables using the respective Category fields, selecting
all records from tblTrnsctnQkn and only those records from tblMap
where the joined fields are equal..

The query returns 2 records for each transaction (400 records in
tblTransctnQkn, query returning 800 records)

What am I doing incorrectly?

As always, help is much appriciated,

Bill Carlson
Click to expand...

Solved my problem, simple error on my part -- hate it when I'm
stupid......
 
Back
Top