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