|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 8th, 2004, 12:59 PM
|
|||
|
|||
Update query by 1/2 entered number
Two update queries. Number fields are being updated. Query
is simply [number field] + [Add this amount] A popup comes up and user enters number to be added. In second update query the number to be added will always be 1/2 of the number entered in first query . Instead of user having to figure 1/2 I am trying to have query do it. So second update query would be [number field] + [Add this Amount / 2]. If user enters 10, then 5 would be added to number field. I have tried many variations of second query but, can't get it right. Any suggestions would be appreciated. 
|
|
#2
July 8th, 2004, 01:26 PM
|
|||
|
|||
|
Update query by 1/2 entered number
[number field] + [Add this Amount ]/2
-- Good luck Jeff Boyce Access MVP
|
|
#3
July 9th, 2004, 02:07 AM
|
|||
|
|||
|
Update query by 1/2 entered number
Outside the brackets! Thank-you very much
-----Original Message----- [number field] + [Add this Amount ]/2 -- Good luck Jeff Boyce Access MVP .
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Update another table with a Max record query | Ngan | Running & Setting Up Queries | 2 | June 22nd, 2004 05:01 PM |
| Variable number of columns in query | MFCVCS | Running & Setting Up Queries | 2 | June 15th, 2004 05:18 AM |
| What formula would show me I already entered an invoice number once before? | Marvin Hlavac | Worksheet Functions | 4 | November 18th, 2003 01:40 AM |
Linear Mode
