Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Displaying unique records
yes I dropped them because I don't need to use them in the report. I needed them only for WHERE clause. By meals I mean (MonAM, MonPM...and so on) Thanks! -
Displaying unique records
Thank you so much for such a quick reply. I dropped all the meals and used group by - IT WORKED! Thank you! -
Displaying unique records
Hello, I've tried many ways to solve my problem but nothing works. I have two tables: Customer Table with CustID(PK), Last, First, Route Meals Table with CustID(PK), MealType, MonAM, TueAM, WedAM and so on for the week For example: Customer Table: 001 John White 1(Route Number) 002 Mary Jones...
