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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: whitespaces
- Order by date
-
Query to Add Counters
'genius' I meant of course!!- whitespaces
- Post #9
- Forum: Microsoft: Access Queries and JET SQL
-
Query to Add Counters
dhhokom you're a genious. Many many thanks mate, I can't thank you enough. I've never used nested SELECT statements within SELECT statements like this. I'll have to learn how to do them. Would you say this was a fairly complex query then? Because I thought I knew a lot about queries etc. but...- whitespaces
- Post #8
- Forum: Microsoft: Access Queries and JET SQL
-
Query to Add Counters
Sorry the new link to the file is http://www.box.net/shared/r7o7id0y8p http://www.box.net/shared/r7o7id0y8p- whitespaces
- Post #6
- Forum: Microsoft: Access Queries and JET SQL
-
Query to Add Counters
Please, please can you tell me the solution I have exactly the same problem my data is attached for info. Basically the records are sorted by YEar and Term (SP = Spring, SU = Summer, AU = Autumn) but I need the counter to reset after each pupil (When the UPN changes) as shown in the highlighted...- whitespaces
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
