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

Counting number of file numbers per created by

P: 2
I am having difficulty creating a report in MS Access that will subtotal the number of files per created id. Have query that will give grand total, but I need the subtotals first and not sure how. Please assist.
Peggy
Aug 14 '07 #1
Share this Question
Share on Google+
2 Replies


pbmods
Expert 5K+
P: 5,821
Heya, Peggy. Welcome to TSDN!

I'm going to go ahead and move this thread to the Access forum, where our resident Experts will be better able to help you out.
Aug 14 '07 #2

FishVal
Expert 2.5K+
P: 2,653
I am having difficulty creating a report in MS Access that will subtotal the number of files per created id. Have query that will give grand total, but I need the subtotals first and not sure how. Please assist.
Peggy
Hi, Peggy.

Its most likely you need to create query with GROUP BY clause. As soon as you will post your table metadata I'll be glad to give you more definite advice.

Here is an example of how to post table MetaData :
Table Name=tblStudent
Expand|Select|Wrap|Line Numbers
  1. Field; Type; IndexInfo
  2. StudentID; AutoNumber; PK
  3. Family; String; FK
  4. Name; String
  5. University; String; FK
  6. Mark; Numeric
  7. LastAttendance; Date/Time
Aug 14 '07 #3

Post your reply

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