By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,191 Members | 1,067 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,191 IT Pros & Developers. It's quick & easy.

Query Nightmare

P: 6
I'm stuck into something I thought would have been easier that this....

I've got 2 tables
1. tblClubs (clubID, ClubName)
2. tblTrainingSessions (sessionID, ClubID, Weekday)
Note: Weekday is the day number (Mon=1, Tue=2, etc).

I need to create a roll for each club.

i.e. Club Alpha has training sessions on every Tue and Fri. I need to generate the following report (1st day is a parameter manually entered, so can be anything)

[
Expand|Select|Wrap|Line Numbers
  1. B]Club Name      [/b]Tue 7 Feb  Fri 10 Feb  Tue 14 Feb  Fri 17 Feb....... etc for about 3 months.
  2.  
I will then list all Students that belong to this club.


I can't seem to be able to create the query or the report, can someone help?

At this point of time, I can still modify the tables structure if need be.


Thanks a lot in advance

Yann
Feb 24 '12 #1
Share this Question
Share on Google+
2 Replies


P: 10
sorry your question is very vague....you want to make a report, depending on the Club ID you type into a search, that will display the training session dates of that Club ID?
and then you want it to list all the students for that training session?
Feb 27 '12 #2

P: 6
I'll try to be more precise. I need to create a student roll for each club which will display training dates for a term. Each club has different training day (some clubs have 2 training days, and some only 1). The report will need to display the different training days for a 3 months period and list the student belonging to this club.

The training days are based on a selected first day (parameter) and the known training days for the club (i.e. Tuesdays and Fridays).


Thanks
Feb 27 '12 #3

Post your reply

Sign in to post your reply or Sign up for a free account.