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..
Need to caculate in Access
Competent Performer
Windows 7 32bit 
Access 2010 32bit
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..
Competent Performer
Windows 7 32bit Access 2010 32bit
and from as many views on this thread I guess I am not the only one with this issue...
VIP
Windows XP Access 2010 32bit
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.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Competent Performer
Windows 7 32bit Access 2010 32bit
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
VIP
Windows XP Access 2010 32bit
Big? Have you run Compact & Repair?
Could extract just the objects related to this issue.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Competent Performer
Windows 7 32bit Access 2010 32bit
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...
Master of Nothing
Windows XP Access 2000
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.
VIP
Windows XP Access 2010 32bit
Steve, not seeing attachment.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Competent Performer
Windows 7 32bit Access 2010 32bit
neither am i..lol
Competent Performer
Windows 7 32bit Access 2010 32bit
I am trying to attach DB but even having errors on that too...UGHHH this is just not my day!!
Competent Performer
Windows 7 32bit Access 2010 32bit
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?
Competent Performer
Windows 7 32bit Access 2010 32bit
still wont let me attach!!
VIP
Windows XP Access 2010 32bit
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.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Competent Performer
Windows 7 32bit Access 2010 32bit
ok I will have to contact microsoft to find out what the issue is..thanks for all the time in this matter...
VIP
Windows XP Access 2010 32bit
I am still willing to look at file. Did you run Compact & Repair, zip it? Up to 2mb zip allowed.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Auot caculate
Posting Permissions
Reply With Quote