Nevermind. It seems that all I needed to do is use the pt query as source for a subquery with a “/100” on the field.
Arrgh.
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, October 22, 2015 9:27 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] pass through query with numeric mask
Pros, I’m running a passthrough query:
SELECT WLOPSQ, WLMCU, WLDSC1, WLRUNL FROM WORLD.F3112 F3112 WHERE WLDOCO = '7216031'
In which WLOPSQ really needs some kind of a mask to scale 2 decimally. I’m bringing in a 1 when I should be bringing in a .5.
Googled to no avail. Please help.
Respectfully,
Liz Ravenwood
Programmer / Analyst
B/E Aerospace | Super First Class Environments
1851 S Pantano Road | Tucson, Arizona 85710
Office +1.520.239.4808 | Internal 814-4808
beaerospace.com
Passion to Innovate. Power to Deliver
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 (2) |
Tidak ada komentar:
Posting Komentar