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

Help with Golf DB

P: n/a
I have a Tabular Form which lists my score per hole in the way of "Par"
"Birdie" ect. I need to create a Text box which counts the number of times
"Par" is listed or each hole.
EG:
Form Name is: VPar1 Form
Field Name is: VPar01 (lists the data below)
Reord Source is: VPar1 (this is a query)

After 6 games Hole01 in the Tabular form shows:-"

Bogey
Par
Par
Bogey
Double
Par

What is the formula to count the number of Pars.

Thanks.
DGolfer.
Dec 1 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Hi,

not sure that you would want to organize your table that way or keep
records in that form (Par, Bogey, etc) - being a golfer I would think
you would have a hole, have a field for Par (say 4) and have records
indicating the score you received on the hole at various times - at
some point you are going to ask yourself, what is my average score on
hole 7 at Pebble Beach - you can't do that the way you are tracking
info now..

JimA

Dec 1 '05 #2

P: n/a
I think you could use DCount to perform this:

DCount("[Score]", "tblScore","[Score] = 'Par'")

you'd need to use DCount within your query and reference the result
with your textbox on your form. I recommend you read the DCount
Helpfile in Access. I must also confess I have never used DCount
myself and so I may be wrong!

DG

Dec 1 '05 #3

P: n/a
Hi JimA,
The data I listed is created from a query I produced from the course table
and score table. I do record individual strokes per hole per course, and do
have an indepth analysis set up. This query was produced from my tables of
scores and was step one in producing more details on the number of Pars,
Bogeys, Birdies ect for all Par3s, Par4s, Par5s.

I did ask for help on a particular formula, not for advise on how to set up
a database.


"Panzerlied" <JA*****@WorkOpportunities.net> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...
Hi,

not sure that you would want to organize your table that way or keep
records in that form (Par, Bogey, etc) - being a golfer I would think
you would have a hole, have a field for Par (say 4) and have records
indicating the score you received on the hole at various times - at
some point you are going to ask yourself, what is my average score on
hole 7 at Pebble Beach - you can't do that the way you are tracking
info now..

JimA

Dec 1 '05 #4

P: n/a
Hi David

I have used the DCount formula and solved my problem.
=DCount("*","VPar1","VPar01='Par'")

Thanks.
"David Gatheral" <da***********@yahoo.co.uk> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...
I think you could use DCount to perform this:

DCount("[Score]", "tblScore","[Score] = 'Par'")

you'd need to use DCount within your query and reference the result
with your textbox on your form. I recommend you read the DCount
Helpfile in Access. I must also confess I have never used DCount
myself and so I may be wrong!

DG

Dec 1 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.