i have a db that has many querys
now say i have 4 querys. and i put them together into a new query
access puts down 2 rows(records) instead of one
the data in other queries is only singular
only one piece of data
anyway how do you remove the extra record???????
PS the extra record is a duplicate of the other record
stu design
Wait sorry for this
i had the main query which gts data for following queries shownin the design view
removing this answered my question thanks anway
STU DESIGN
Edited by stu_design, 10 May 2005 - 12:52 PM.