Hello,
I have a query and a table that is showing duplicate information when I run a query. What should I do to remove the duplicate data. Thank you
Hello,
I have a query and a table that is showing duplicate information when I run a query. What should I do to remove the duplicate data. Thank you
Hmm. Could you show us the query sql? And tell us what you want the query to do.
SELECT [Copy Of All Table Summary].MoonPhaseYourNumber, [Copy Of All Table Summary].YourDate, [Copy Of All Table Summary].YourTableYourNumber, [Copy Of All Table Summary].Cash4YourNumber, [Copy Of All Table Summary].GAFiveYourNumber, [Copy Of All Table Summary].fantasy5YourNumber
FROM [Copy Of All Table Summary]
WHERE ((([Copy Of All Table Summary].YourDate)>=[Start Date] And ([Copy Of All Table Summary].YourDate)<=[End Date]));