Help with Golf DB

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DGolfer - 01 Dec 2005 06:31 GMT

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.

Reply to this Message

Panzerlied - 01 Dec 2005 13:53 GMT

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

Reply to this Message

David Gatheral - 01 Dec 2005 15:20 GMT

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

Reply to this Message

DGolfer - 01 Dec 2005 21:33 GMT

Hi David

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

Thanks.

>I think you could use DCount to perform this:
>
[quoted text clipped - 6 lines]
>
> DG

Reply to this Message

DGolfer - 01 Dec 2005 21:30 GMT

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.

> Hi,
>
[quoted text clipped - 7 lines]
>
> JimA

Reply to this Message