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!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Please help me with Sql count

Status
Not open for further replies.
unforgiven

unforgiven

Technical User
Dec 27, 2002
7
US
I've been trying to get this simple Sql statment to work but can't It's SelecttblTrainingClass.[tblTrainingClass_Seats]- Count(tblTrainingScheduled.[tblTrainingScheduled_ID (PK)]) AS RemainingSeats. It's just taking the value in tblTraining class seats and the counting tblTrainingScheduled_ID and then subtacting the tblTrainingClass_Seats from the count. Please in advance for your help
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

caykamanj1966
  • Locked
  • Question
Help With Search Form Results 2
Replies
15
Views
328
caykamanj1966
caykamanj1966
BJZeak
  • Locked
  • Question
Struggling with finding an answer to a simple question
Replies
5
Views
504
BJZeak
BJZeak
TrekBiker
  • Locked
  • Question
Running query with parameter from Inputbox 2
Replies
8
Views
534
TrekBiker
TrekBiker
rccline
  • Locked
  • Question
Highlighting Duplicates with Conditional Formatting 2
2
Replies
26
Views
949
strongm
strongm
InkyRich
  • Locked
  • Question
Basic help with Access forms
Replies
3
Views
159
InkyRich
InkyRich

Part and Inventory Search

Sponsor

Back
Top