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

Counting records

P: 4
Newbie here - I need help. I am trying to calculate the number of time a particular date was requested. On the 5th request the user should get a message that states that the date is not available.

I have the following tables:

ScheduleTable
*Emp ID
*RequesteedDate
*Confirm
etc..

and

DateTable
*Date
*Tally (number of times requested)

Can anyone tell me how to do this?
Oct 25 '06 #1
Share this Question
Share on Google+
1 Reply


Expert 5K+
P: 8,434
Newbie here - I need help. I am trying to calculate the number of time a particular date was requested. On the 5th request the user should get a message that states that the date is not available.
I have the following tables:
ScheduleTable
*Emp ID
*RequesteedDate
*Confirm
etc..
and
DateTable
*Date
*Tally (number of times requested)
Can anyone tell me how to do this?
At the simplest level, perhaps using a query with WHERE Tally < 5 would be enough?
Oct 25 '06 #2

Post your reply

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