How to store report's calculated field

[beckymc]

I have a extensively calculated field in a report which would take many queries to reproduce. I need to take the existing reports' calculated field and store data for further use.

Is there a way to accomplish this?

[NeoPa]

Not easily no. Nor would I advise you to go that route of storing calculation results (Database Normalisation and Table Structures).

You should probably be looking at creating the data in a Query and referring to that from elsewhere when you need it.

[beckymc]

Under time restraint and need to do this temporary till I have the opportunity to create queries. Can you explain how I could store the calculated field? Thanks for any help.

[Rabbit]

It would help if you told us what this calculation consists of

[NeoPa]

BeckyMc:
Can you explain how I could store the calculated field?

Not easily no. As I mentioned earlier that's difficult at the best of times. Here, as Rabbit points out, you haven't even shared any basic information we could use to start thinking about your problem.

I still believe that, far from taking a short-cut, trying to save the calculated data will be more complicated, more convoluted, and will take more time, than doing it the standard way. I may be proven wrong if/when we learn the details of exactly what it is you're actually asking about, but I very much doubt it.