Duplicate entries from Access query

[BasicBoy]

I have this query:

ListQuery(35) = "Select transactions.id, transactions.transdate, journaltranstypes.transtype, transactions.description, transactions.refno, paidforvotes.votename as paidforvotename, amountdt, vatondt, format(vatamountdt,'currency'), paidbyvotes.votename as paidbyvotename, amountcr, vatoncr, format(vatamountcr,'currency'), tasks.taskname, transactions.reconciled, transactions.enteredby from (((Transactions LEFT JOIN Votes as paidforvotes ON Transactions.paidfor=paidforVotes.voteno) LEFT JOIN Votes as paidbyvotes ON Transactions.paidby=paidbyVotes.voteno) LEFT JOIN journaltranstypes on transactions.transtype=journaltranstypes.id) left join tasks on tasks.id=transactions.taskno"

There are only three entries in the database but I get 5 records, some of them with duplicate ID numbers.
My Access ID is a long number which is the key and there are no duplicate records in the database.

Can someone please help.

Many thanks

 

[Andrzejek]

How many related records do you have in Transactions, Votes, journaltranstypes, and tasks tables?

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.

 

[BasicBoy]

As I understand your question.
I select from TRANSACTIONS which have fields for journaltranstypes (as in integer to be joiend from that table) selected from a dropdownbox, TaskNo which is adding one specific task to one specific transaction (to be added by selecting one task items from many tasks and adding the ID for that taskitem as TaskNo), and the two vote fields just add one debit and one credit vote for every transaction.
Hope it helps
Thanks

 

[dhookom]

Start removing tables until the number of records is as expected. The last table removed has multiple records on the foreign key side of the join.

Duane
Hook'D on Access
MS Access MVP