|
| 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
August 25th, 2006, 07:45 PM
posted to microsoft.public.access.queries
|
|||
|
|||
Strange Situation
Okay, everytime I think I'm done...
I have a table for contract changes. This table fits in the value of the change. In the query I have the change table connect to the project table which provides the percentages for the markups. This works beautifully, but I have one problem. In one change (the first one) one of the markups was not taken so as a result I have a entry of 88,000 that needs to go away. Is there a way to allow for special situations so that when I run the query it will allow me to change this for special conditions? -- Lori A. Pong 
|
|
#2
November 21st, 2006, 08:26 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Strange Situation
No, I don't think so.
"Lori" wrote in message ... Okay, everytime I think I'm done... I have a table for contract changes. This table fits in the value of the change. In the query I have the change table connect to the project table which provides the percentages for the markups. This works beautifully, but I have one problem. In one change (the first one) one of the markups was not taken so as a result I have a entry of 88,000 that needs to go away. Is there a way to allow for special situations so that when I run the query it will allow me to change this for special conditions? -- Lori A. Pong
|
|
#3
November 21st, 2006, 08:47 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Strange Situation
Actually, since this post is old, I did find a solution. I created another
field with a yes/no box, if it is checked it uses the values entered, if it is not check it uses the formula written to use the percentages entered into the linked table. -- Lori A. Pong "Anthony" wrote: No, I don't think so. "Lori" wrote in message ... Okay, everytime I think I'm done... I have a table for contract changes. This table fits in the value of the change. In the query I have the change table connect to the project table which provides the percentages for the markups. This works beautifully, but I have one problem. In one change (the first one) one of the markups was not taken so as a result I have a entry of 88,000 that needs to go away. Is there a way to allow for special situations so that when I run the query it will allow me to change this for special conditions? -- Lori A. Pong
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
