Need to caculate in Access

[Stephanie53]

unfortunately I cant...I signed a waiver when I was contracted to do this job to not send out company info...wish I could..but thanks anyways..

[Stephanie53]

and from as many views on this thread I guess I am not the only one with this issue...

[June7]

Sorry, but have never encountered a thread that showed so much difficulty with simple calculation.

Don't care about data, it is db structure that is the issue. If you want to delete data and provide empty db that will be only way I can help at this point.

[Stephanie53]

Good Heavens...Not sure you realize how big this DB has become for me to do that...ughhh...guess I have to just let them know that this is just not going to work to the way they want it to work

[June7]

Big? Have you run Compact & Repair?

Could extract just the objects related to this issue.

[Stephanie53]

give me until tomorrow...I am creating same DB with just this info in it and I will post it to here ...it will have just minium of some things in it that I can get away with showing to you..it might be later this afternoon by the time I have this done but wont be able to try probably until I get back in the morning...

[ssanfu]

PMFJI,

Attached is an example of what June told you.. (Access 2000 format)

"Query1" has a calculation that is not stored in the table. As June said, calculated values should not be stored in the table since it can be calculated at any time.


"Query2" has a calculation that is stored in the table.


Hopefully this will show you what your query should look like.

[June7]

Steve, not seeing attachment.

[Stephanie53]

neither am i..lol

[Stephanie53]

I am trying to attach DB but even having errors on that too...UGHHH this is just not my day!!

[Stephanie53]

ok now before I go further I created an Info Table that has a few of the hoses, and a MasterHose list where I want to be able to see all the orders go in and the quantity..but I am not seeing in the QRY where i can put in the Expression ...can i just send to you as is and see if you can see it?

[Stephanie53]

still wont let me attach!!

[June7]

You can but not sure how much that will help since I seem unable to guide you on how to do a calc in query or textbox.

[Stephanie53]

ok I will have to contact microsoft to find out what the issue is..thanks for all the time in this matter...

[June7]

I am still willing to look at file. Did you run Compact & Repair, zip it? Up to 2mb zip allowed.