Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Access 2003


  • Please log in to reply

#1
magusbuckley

magusbuckley

    Member

  • Member
  • PipPipPip
  • 625 posts
Hello:

At work, we use an access database to track our computer inventory. I have created a report that shows a list of the computers, but I would love for this report to show the number of computers we have. I'm not sure if this is done on the report, the table, or both.

Any and all information will be greatly appreciated.

Thanks,

Magus
  • 0

Advertisements


#2
piper

piper

    Retired Staff

  • Retired Staff
  • 2,459 posts
Hi Magus!!!

I'd put that calculation in the report, in the Report Footer section.

Open the Report Footer section, add the field you want to count. Right click the field, choose Properties, on the All tab scroll to Running Sum. Open the drop down box and choose how you want the field to sum (Over All or Over Group).

To manually add a Running Sum field, add a Text Box, right click over it and choose Properties. The second field under the All tab is Control Source. Click the "build" button to the right to open the Expression Builder. The command is "count". I'd probably count the Autoid field, making the expression count[autoid]. You can count any text field in the detail line, though.

Hope that helps!
  • 0

#3
magusbuckley

magusbuckley

    Member

  • Topic Starter
  • Member
  • PipPipPip
  • 625 posts
LindaGail:

I tried your two suggestions but must have been confused about something as I couldn't get either method to work. With the first method, I tried counting the Computer Name field. When I looked at the report, I saw the name of the first computer in our list as opposed to a total count. I told it to keep a running sum in "Properties" like you said though.

In the second method, I kept getting an error message on the formula. I was still trying to count the "Computer Name" field.

In the end, I wound up finding something in the Office Help documents. Hmm...not sure how I didn't see this before. I used =Count(*) to get it done.

Thanks for the help though...the confusion was on my part I'm sure.

Magus
  • 0

#4
piper

piper

    Retired Staff

  • Retired Staff
  • 2,459 posts
Glad you got the calculation to work!! I was using Access XP, as I no longer have access to Access 2003.
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP