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 MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by oliverme
-
Help with creating queries and reports!
The first 2 codes didn't work. The first doesn't like that expression at all. And, the second still brought up a negative value. The number is correct but it's still negative. As well, I need the tally sums for each class for a particular date range. I do have another table that has the list of...- oliverme
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
Help with creating queries and reports!
Thanks for your help, rac2! Each class a person can either be registered or a walk-in to attend the class. Should I still create 2 tables? I need to know the sum of attendees, plus if they are registered or walk-ins for each class.- oliverme
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Help with creating queries and reports!
I have a database I created for class registration for a small group. It is used to put registration information in there as well as pull queried reports to show attendance as well as if they registered or were walk-ins. Here are the tables I created: Language Instructor Session Subsession...- oliverme
- Thread
- Replies: 4
- Forum: Microsoft: Access Queries and JET SQL
