calculated fields cant see in the database

[Dhanu]

dear all,

I have created some calculated fields. but I cant see them in my database. pls advice. I'm new to access. I have attached two JPEG fils with this.

thank you

 

[arnelgp]

what is the Expression of your calculated Fields?
does all the fields and expression in the calculated fields available in your table?

 

[isladogs]

You shouldn't have calculated fields in a database
Instead the values should be obtained using queries.

Also another issue would appear to be that you are using text fields for several currency and percentage fields

 

[Dhanu]

what is the Expression of your calculated Fields?
does all the fields and expression in the calculated fields available in your table?

TotaleAdulti =[adulto]*[adulti]
TotaleRagazzi=[ragazzo]*[ragazzi]
TotaleBambini=[bambino]*[bambini]

Quota_Totale=[TotaleAdulti]+[TotaleRagazzi]+[TotaleBambini]
Commissione Euro=[Quota_Totale]*[Commissioni]
Netto=[quota_totale]-[commissione euro]

these are my expressions. yes, all fields are visible also in the table.
more important filed is netto . because I need to know the final euro value when I run the reports

 

[plog]

Yeah, don't store that in a table--calculate it in a query when you need it.

 

[Dhanu]

You shouldn't have calculated fields in a database
Instead the values should be obtained using queries.

Also another issue would appear to be that you are using text fields for several currency and percentage fields

is there anyway i can save these values in the table? atleat net total (netto) ?
I tried to run a query but i couldn't see the net price ( Netto field)in the query also

 

[Dhanu]

When the ControlSource starts with an equal sign or is empty, the control is not bound and therefore will never be automatically saved. Do as ridders suggested and calculate the values in the query. Then you can use the query in other places so you have only a single place where the calculations happen.

ok, thanks, i can understand.

what should I write in the query ?

 

[plog]

Put your calculated values in the query like so:

TotaleAdulti: [adulto]*[adulti]

 

[arnelgp]

did you set the Properties
of your Calculated Fields
in General tab (go to Design View of your table).

Result Type: Double
Format: Standard

 

[Dhanu]

Put your calculated values in the query like so:

TotaleAdulti: [adulto]*[adulti]

ok, thanks, i have done as you said. can you please check the attached JPEG fill for verification.

 

[Dhanu]

did you set the Properties
of your Calculated Fields
in General tab (go to Design View of your table).

Result Type: Double
Format: Standard

no, i didn't do anything. can you explain what should i do?

 

[Dhanu]

i changed thanks. check the JPEG fill attached

 

[plog]

can you please check the attached JPEG fill for verification.

Incorrect. And you are following 2 people who are giving you conflicting advice. I (and most people here) are advising you against calculated fields in your table, Arn is trying to get you to set them up properly. You can't follow both paths.

 

[Dhanu]

Incorrect. And you are following 2 people who are giving you conflicting advice. I (and most people here) are advising you against calculated fields in your table, Arn is trying to get you to set them up properly. You can't follow both paths.

please, I'm very new to access. what should I do now?
what are the steps I can do in the query field?
did I put my formulas([adulto]*[adulti]) incorrect place?
in "criteria", I have to put them right?

 

[arnelgp]

which parth are you going, the calculated field?
i think you cannot change the field to ordinary number format.


if you want to get rid of calculated field, you must make new table
and import the not-calculated field from the one you have to the new table.

 

[Dhanu]

dear all,

I have attached my database fill. you can modify it and send back to me. so i can learn the steps by watching it. thanks.

 

[isladogs]

As plog has already said, you have 2 different approaches being suggested.

Decide which approach you want & then perhaps someone will respond...

 

[Dhanu]

As plog has already said, you have 2 different approaches being suggested.

Decide which approach you want & then perhaps someone will respond...

which one is most suitable for my case?

 

[arnelgp]

do as what the old folk says, the old way lol.

 

[isladogs]

YOU choose.
You have been given advice already.

And arnel - I assume you are referring to yourself with the 'old folk' comment