Frontpage - db - total

[Leprakawn]

Hey, all!

Okay, I am updating a form from last year here at work, and it is necessary to use FP. Anyway, it was asked to add an option for ppl to select if it is their first time to attend the event, which is simple to do... but it was also asked that on the attendee list to show a total of how many ppl are attending for their first time.

I know I could set the db to show who selected "yes" for that field, but does anyone know if there is a way for me to get it to sum up the total and print it below the attendee list? And is there a way for me to get a total number of everyone signed up as well? I know I could just add the ID number in the db, but considering I have it sorted by last name... it would look really weird having the ID column all out of order.

Thanks for the help and the ideas!

[curtiss]

What kind of database are you using? Does it accept SQL code? If so, you should be able to do a query like:

SELECT COUNT(*) AS total FROM table WHERE first_time='yes';

[Leprakawn]

I am using the standard Access db, and this would be one of those situations where I wish my desktop publishing class had covered Access.

Now I could do the same thing with that code to get a total count of applicants, correct?

[curtiss]

IIRC, Access does accept the COUNT function (which is a fairly standard SQL command). If so, absolutely, you can use that to get the total number of applicants.

[Leprakawn]

Okay, cool. I will see if I can try that out tomorrow... I have been swamped at work the past few days!

Thanks, Curtiss!