How to Sum a Column and Display in Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a Database that I have attempted to build from Scratch to keep track
of my online poker money... I have several field some are numbers and some
are Text. I would like the ability to view a report that shows the current
status of my poker winnings. Have had some luck in creating the Entry Form
and the Table but I am not having any luck producing the report info. In
order to obtain the info I nee to Calculate the Sum of all the [Winning
Payouts] and subtract from that the Sum of all the Tournament [Buy-in
Amounts]. I cant get this to work.

Currently I am trying to display just the Sum of [Buy-in Amount] using the
formula =Sum([Buy-in Amount])

I am getting an error message on the report... it just inserts "#Error" in
the Text Box I have created on the Report Footer. I have tried to eliminate
potential problems by changing the Field From Currency to just Number
Fields... but with no success.

Any Help??? I bet this is so easy i must just have some setting wrong...
 
Will,

Sounds like you need an online tutorial about Access.

Access uses TABLES to store data, FORMS to add data to tables and look at
data in tables, QUERIES to ask questions about the data, and REPORTS to print
out data.

You need to build a QUERY to ask the questions, then build a report based on
the query.

Here is a link to a good tutorial that can help you get started.

http://www.functionx.com/access/

Good luck with the Access Database and the Poker! (Texas Hold'em Rules!)

Santara
 
Back
Top