Queries calculations

[Nick Druce]

I running a querry to mulitply to fields together using this

Cost Per Week=([Number Of Sessions Per Week]*[Price])

But It wont do it and it will not update the querry?

any ideas Would be wonderfull

 

[Rich]

there are no equals signs in calculated fields, it should be
Cost Per Week:[Number Of Sessions Per Week]*[Price]
it's also good practice not to have spaces in field names

 

[Mile-O]

I running a querry to mulitply to fields together using this

Cost Per Week=([Number Of Sessions Per Week]*[Price])

But It wont do it and it will not update the querry?

any ideas Would be wonderfull

Cost Per Week: [Number Of Sessions Per Week]*[Price]

 

[Nick Druce]

Cost Per Week: [Number Of Sessions Per Week]*[Price]

This only prompts me for the number of sessions and will not prompt me for the price

 

[Mile-O]

That would imply the table your query is based on does not have a field called [Number Of Sessions Per Week] but does have a field called [Price].

 

[maxmangion]

Cost Per Week: [Number Of Sessions Per Week]*[Price]

This only prompts me for the number of sessions and will not prompt me for the price

If you are trying to calculate two fields from your table, make sure that [Number Of Sessions Per Week] and [Price] corresponds to the correct names (not captions) of your fields ... otherwise you will get the prompts.