Formulas in Access??

  • Thread starter Thread starter Jenny
  • Start date Start date
J

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??
 
You can link to your Access table from Excel and do your calculations also.
However whenever you refresh it will overwrite the linked data so save your
calculations in another sheet and expand your ranges to > than currently
using.

Marty said:
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??
.
Click to expand...
Click to expand...
 
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??
.
Click to expand...
.
Click to expand...
 
Back
Top