MS Access 2003

[Russ]

Real simple. How do I do calculations in Access? In my table, I have a Cost,
Tax, Shipping, and Total Cost. I want to have the sum of all fields in my
Total Cost field. How do I do that? Thank you.

 

[ChrisM]

It's not recommended to have a total(calculated) field actually in the
table, (one of the rules of data normalisation).

Create a query based on your table, create a formula field:

TotalCost: [Cost] + [Tax] + [Shipping]

 

[Russ]

Thanks for your reply. Where do I enter that formula?

It's not recommended to have a total(calculated) field actually in the
table, (one of the rules of data normalisation).

Create a query based on your table, create a formula field:

TotalCost: [Cost] + [Tax] + [Shipping]

Real simple. How do I do calculations in Access? In my table, I have a
Cost, Tax, Shipping, and Total Cost. I want to have the sum of all fields
in my Total Cost field. How do I do that? Thank you.

 

[ChrisM]

You need to create a new Query based on your table.
You would enter the formula as a calculated field in this query.

Cheers,

Chris.

Thanks for your reply. Where do I enter that formula?

It's not recommended to have a total(calculated) field actually in the
table, (one of the rules of data normalisation).

Create a query based on your table, create a formula field:

TotalCost: [Cost] + [Tax] + [Shipping]

Real simple. How do I do calculations in Access? In my table, I have a
Cost, Tax, Shipping, and Total Cost. I want to have the sum of all
fields in my Total Cost field. How do I do that? Thank you.

 

[Russ]

Where is this calculated field? Where in the query would I place the below
formula?

You need to create a new Query based on your table.
You would enter the formula as a calculated field in this query.

Cheers,

Chris.

Thanks for your reply. Where do I enter that formula?

It's not recommended to have a total(calculated) field actually in the
table, (one of the rules of data normalisation).

Create a query based on your table, create a formula field:

TotalCost: [Cost] + [Tax] + [Shipping]



Real simple. How do I do calculations in Access? In my table, I have a
Cost, Tax, Shipping, and Total Cost. I want to have the sum of all
fields in my Total Cost field. How do I do that? Thank you.

 

[ChrisM]

In the query design form, you have your Table at the top and you can drag
your fields into the query grid, Ok?
In a blank column, type the formula as I've shown.

If this is not making sense, you should really read the helpfiles within
Access on creating a query.

Cheers,

Chris.

Where is this calculated field? Where in the query would I place the below
formula?

You need to create a new Query based on your table.
You would enter the formula as a calculated field in this query.

Cheers,

Chris.

Thanks for your reply. Where do I enter that formula?

It's not recommended to have a total(calculated) field actually in the
table, (one of the rules of data normalisation).

Create a query based on your table, create a formula field:

TotalCost: [Cost] + [Tax] + [Shipping]



Real simple. How do I do calculations in Access? In my table, I have a
Cost, Tax, Shipping, and Total Cost. I want to have the sum of all
fields in my Total Cost field. How do I do that? Thank you.

 

[Russ]

Thank you! Now I see. it works perfectly fine. Let me ask you this. My first
column is PO# and I set it up with autonumber. As you know, the first entry
starts with the number 1. Is there way I can customize that so the first
entry is INDS001 and then the next field will automatically use INDS002?

In the query design form, you have your Table at the top and you can drag
your fields into the query grid, Ok?
In a blank column, type the formula as I've shown.

If this is not making sense, you should really read the helpfiles within
Access on creating a query.

Cheers,

Chris.

Where is this calculated field? Where in the query would I place the
below formula?

You need to create a new Query based on your table.
You would enter the formula as a calculated field in this query.

Cheers,

Chris.

Thanks for your reply. Where do I enter that formula?

It's not recommended to have a total(calculated) field actually in the
table, (one of the rules of data normalisation).

Create a query based on your table, create a formula field:

TotalCost: [Cost] + [Tax] + [Shipping]



Real simple. How do I do calculations in Access? In my table, I have
a Cost, Tax, Shipping, and Total Cost. I want to have the sum of all
fields in my Total Cost field. How do I do that? Thank you.

 

[ChrisM]

Excellent!

In answer to your second question. Don't think so. Autonumber is exactly
that, a number.
The only way to do that would be some VBA code to generate the Purchase
Order numbers,
or let the system generate 1,2,3... and use another formula to pad it with
zeros and stick the INDS in front.
Look at how to format a number in the Access online help files.

Cheers,

Chris.

Thank you! Now I see. it works perfectly fine. Let me ask you this. My
first column is PO# and I set it up with autonumber. As you know, the
first entry starts with the number 1. Is there way I can customize that so
the first entry is INDS001 and then the next field will automatically use
INDS002?

In the query design form, you have your Table at the top and you can drag
your fields into the query grid, Ok?
In a blank column, type the formula as I've shown.

If this is not making sense, you should really read the helpfiles within
Access on creating a query.

Cheers,

Chris.

Where is this calculated field? Where in the query would I place the
below formula?

You need to create a new Query based on your table.
You would enter the formula as a calculated field in this query.

Cheers,

Chris.

Thanks for your reply. Where do I enter that formula?

It's not recommended to have a total(calculated) field actually in
the table, (one of the rules of data normalisation).

Create a query based on your table, create a formula field:

TotalCost: [Cost] + [Tax] + [Shipping]



Real simple. How do I do calculations in Access? In my table, I have
a Cost, Tax, Shipping, and Total Cost. I want to have the sum of all
fields in my Total Cost field. How do I do that? Thank you.

 

[Russ]

OK. Thank you for your help Chris.

Excellent!

In answer to your second question. Don't think so. Autonumber is exactly
that, a number.
The only way to do that would be some VBA code to generate the Purchase
Order numbers,
or let the system generate 1,2,3... and use another formula to pad it with
zeros and stick the INDS in front.
Look at how to format a number in the Access online help files.

Cheers,

Chris.

Thank you! Now I see. it works perfectly fine. Let me ask you this. My
first column is PO# and I set it up with autonumber. As you know, the
first entry starts with the number 1. Is there way I can customize that
so the first entry is INDS001 and then the next field will automatically
use INDS002?

In the query design form, you have your Table at the top and you can
drag your fields into the query grid, Ok?
In a blank column, type the formula as I've shown.

If this is not making sense, you should really read the helpfiles within
Access on creating a query.

Cheers,

Chris.


Where is this calculated field? Where in the query would I place the
below formula?

You need to create a new Query based on your table.
You would enter the formula as a calculated field in this query.

Cheers,

Chris.

Thanks for your reply. Where do I enter that formula?

It's not recommended to have a total(calculated) field actually in
the table, (one of the rules of data normalisation).

Create a query based on your table, create a formula field:

TotalCost: [Cost] + [Tax] + [Shipping]



Real simple. How do I do calculations in Access? In my table, I
have a Cost, Tax, Shipping, and Total Cost. I want to have the sum
of all fields in my Total Cost field. How do I do that? Thank you.