Formulas in Access??

[Jenny]

I have a wedding invitation list table in Access. I want
to calculate the ammount of people invited/actually
attending, I am going to have to Export it to Excel to do
this. I know there has to be a command I can put on my
form that will do this form me right? I just can not
think of the coding at the moment. If there was a way to
make it run a totaling reprt that would be best. Any
ideas??

 

[Jenny]

Thanks very much Marty - this did exactly what I wanted it
to do!

-----Original Message-----
There's are a lot of different way to achieve what your
asking. This SQL Query will get you there. Once the new
table is created you can add a sub-form to your main form
with the values of this table.

SELECT Count(tblWeddingInv.fldInvited) AS
CountOffldInvited, Count(TABLENAME.fldActual) AS
CountOffldActual INTO tblOutPutTableName
FROM tblWeddingInv;

You can either insert this into your code or create a new
query and insert this into the new query. To use this in
a query format click View > SQL View. To create your own
query like this in the "normal" query view Click Query >
New > [select the table]. Then select the fields you
want; then right click in the Fields area of the query and
select Totals. This will give you a new row called
Totals. In this row, for the selected fields, click the
down arrow and click Count.

-----Original Message-----
I have a wedding invitation list table in Access. I want
to calculate the ammount of people invited/actually
attending, I am going to have to Export it to Excel to do
this. I know there has to be a command I can put on my
form that will do this form me right? I just can not
think of the coding at the moment. If there was a way to
make it run a totaling reprt that would be best. Any
ideas??
.

.