I’m sorry. I’m just so flustered cause I got hit with so many things this morning. I don’t actually think it is the query after all. I think it is how I have it formatted or the code or something.
It is a decimal but formatted as a percent. It’s still showing 0 in the code but it is allowing me to step through it, but then I realize that isn’t even the number I want calculated anyway. I want 100-(countofid/opportunities) instead.
It’s time for me to step away for lunch break and then I’ll gather my thoughts and let you know what I find. I’m sure I am doing something stupid.
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Monday, August 28, 2017 11:45 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] update query with a calculation
Liz,
Also, "isn't working for me" is not very helpful. We would like to know your results and what's not working.
Regards,
Duane
From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of John Viescas JohnV@msn.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Monday, August 28, 2017 1:33 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] update query with a calculation
Liz-
It would help to see your actual code and not just the SQL.
John Viescas, author
Effective SQL
SQL Queries for Mere Mortals
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
| If you’re at all interested in Microsoft Access or SQL Server, this is the place to be! Check out the book recommendations and all the cool links! |
On Aug 28, 2017, at 8:20 PM, Liz Ravenwood liz_ravenwood@beaerospace.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Pros, I don’t know if I’ve actually ever tried this before, but this calculation isn’t working for me in an update query. In the interest of time, I’m going to set a variable because this is all running in code anyway, but I was just curious as if anyone knew what I was doing wrong or if there was a known issue.
Here is the SQL:
UPDATE Skeleton SET NumSquawks = 2, FPY = 2/[NumOpportunities] WHERE Program = 'aprog' AND SS = 15 AND OPSeq = 'anum' AND WorkCenter = 'aworkcenter' AND Suite = 'asuite'
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
Tidak ada komentar:
Posting Komentar