duplicate data in a query

  • Thread starter Thread starter ltmoya
  • Start date Start date
L

ltmoya

in the criteria box what would i type to stop duplicate data from showing up?

field req # site
Date completed
table material_req material_req
material_req
sort ascending
show
critera no idea what goes her????

data comes out looking like this
vw0111 B1 01/05/01
vw0111 B1 01/05/01
vw0112 B1 01/05/01
vw0112 B1 01/05/01
i want it to look like
vw0111 B1 01/05/01
vw0112 B1 01/05/01

thanks, army engineer Lt. in Iraq pushing paper work
 
Try using Distinct to iliminate duplicates

Select Distinct [req #], site , [Date completed] From material_req
Order By [req #]
 
Ofer said:
Try using Distinct to iliminate duplicates

Select Distinct [req #], site , [Date completed] From material_req
Order By [req #]
in the criteria box what would i type to stop duplicate data from showing up?
Click to expand...
[quoted text clipped - 16 lines]
thanks, army engineer Lt. in Iraq pushing paper work
Click to expand...
Click to expand...


hay thanks that helped me out and did the trick
 
Back
Top