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

{Solved} Real basic Access question

P: 4
Sorry if this is a little basic, but I'm a real newbie with Access, and this is driving me crazy. What I'm trying to do is use the Count function in such a way that I can get it to return values based on other values. Specifically, I have a table that lists a number of gaming devices distributed between three locations. Each of these has its own unique serial number which I'm using as the primary key [fldSN], and then an ID number field which tells what type it is [fldID]. Finally, each of the locations has their own ID number [fldLocID]. What I'm trying to do is set up in a report footer, a function which will show the total number of machines at each location. So if there were 100 total, it might show 30 at location 1, 60 at location 2, and 10 at location 3. I'm having no luck getting this to work though, I know I need =Count([fldSN]), which would just show ALL of the machines, but I cannot figure out what I need to do to specify a location in the command. Any help would be deeply appreciated, this is driving me nuts!
Nov 12 '06 #1
Share this Question
Share on Google+
7 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
What I'm trying to do is set up in a report footer, a function which will show the total number of machines at each location. So if there were 100 total, it might show 30 at location 1, 60 at location 2, and 10 at location 3. I'm having no luck getting this to work though, I know I need =Count([fldSN]), which would just show ALL of the machines, but I cannot figure out what I need to do to specify a location in the command. Any help would be deeply appreciated, this is driving me nuts!
In a Report you can set group headers and footers. Go to View -Sorting and Grouping. When the sorting and grouping window opens choose your location field. Set the group footer property to yes. You can also if you wish set the group header property to yes and move your location field into it.

now puting unbound textbox control in the group footer with control source = Count([fldSN]) shoudl work.
Nov 12 '06 #2

P: 4
In a Report you can set group headers and footers. Go to View -Sorting and Grouping. When the sorting and grouping window opens choose your location field. Set the group footer property to yes. You can also if you wish set the group header property to yes and move your location field into it.

now puting unbound textbox control in the group footer with control source = Count([fldSN]) shoudl work.
That worked, thank you! There is one strange thing though that I cannot figure out, the report itself has about 29 blank pages, with the total I get from the count command on the last page. I don't have anything in details, so I'm at a loss for what might have caused that. Any ideas?
Nov 13 '06 #3

100+
P: 1,646
That worked, thank you! There is one strange thing though that I cannot figure out, the report itself has about 29 blank pages, with the total I get from the count command on the last page. I don't have anything in details, so I'm at a loss for what might have caused that. Any ideas?
How many pages in total?
Sometimes, if one of your fields strays a little to the right you will generate an extra page which looks blank.
Nov 13 '06 #4

P: 4
How many pages in total?
Sometimes, if one of your fields strays a little to the right you will generate an extra page which looks blank.
Total of 29, I have about one line of data under my header, and then the feedback from the count command and that's it. I have things pretty compact at the moment, the header only goes about half way across the page, so unless I'm missing something, seems like it should be far enough over.
Nov 13 '06 #5

MMcCarthy
Expert Mod 10K+
P: 14,534
That worked, thank you! There is one strange thing though that I cannot figure out, the report itself has about 29 blank pages, with the total I get from the count command on the last page. I don't have anything in details, so I'm at a loss for what might have caused that. Any ideas?
Click on the grey bar over the details section and open the properties. Set visible to no if there is nothing there and see if that solves the problem.
Nov 13 '06 #6

P: 4
Click on the grey bar over the details section and open the properties. Set visible to no if there is nothing there and see if that solves the problem.
It most certainly did! Thank you so much, I was getting nowhere with this on my own!
Nov 13 '06 #7

MMcCarthy
Expert Mod 10K+
P: 14,534
It most certainly did! Thank you so much, I was getting nowhere with this on my own!
Glad to be of help
Nov 13 '06 #8

Post your reply

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