Query duplication issues

[MiCCAS]

G'day all,
I have 3 tables, somewhat like the following:
tblName


NameID
Name
tblgroup
GroupID
NameID
GroupName
tblData
DataID
NameID
DataResult
I have NameID all linked, and in a query with all the tables included, I am getting each result twice.
IE:
NameID GroupName DataResult
1 Grp 20
2 Grrp 40
1 Grp 20
2 Grrp 40


I was doing a fancy mandangled query, but the fault still happens when I do this:
tblName.*
GroupName (from tblGroup)
DataResult (from tblData)


Thanks in advance for all of your help, I appreciate your responses even though I'm new.. I'll try and help out in return, but I'm still quite new to Access.

[pbaldy]

What is the SQL of your simple query? It sounds like you either have no join between the tables, or the wrong one. I'm guessing one of those tables has 2 records in it.