Calculated

[Jishnu Surendran]

I have a calculated field =Sum([Shares]) in access where Shares represent a field showing number of shares held by each person. The field does the calculation but unlike excel it is taking some time and I hate that. Is there a work around to make it faster?

[ranman256]

it should take 1/2 second....unless youre dealing with millions of records.

is your query pulling straight from the table?
more than 1 table?
are you connected to both wireless and hardwired cat5? (one of my users was connected to both slowing the queries a lot)

this query should not take anytime to resolve.

[Jishnu Surendran]

I'm talking about a form created from a query which is in turn created from a table. There aren't millions of records.

[ssanfu]

I have a calculated field =Sum([Shares]) in access where Shares represent a field showing number of shares held by each person.

Are you saying that you have a calculated field in a table? I would suggest NOT using calculated FIELDs in tables. I have NEVER used a calculated field in a table.

Is there a work around to make it faster?

The calculation should be done in a column in a query.

The field does the calculation but unlike excel it is taking some time

Forget about Excel. Access and Excel are two completely different animals (models).

[Jishnu Surendran]

Are you saying that you have a calculated field in a table? I would suggest NOT using calculated FIELDs in tables. I have NEVER used a calculated field in a table.



The calculation should be done in a column in a query.



Forget about Excel. Access and Excel are two completely different animals (models).

I'm talking about a 'FORM created from a query which is in turn created from a table. The sum field is at the form footer.

[ssanfu]

OK, post the SQL of the query.......