Strange Situation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DESPERATELY NEED HELP 3
Exceptions to the rule 2
Dlookup a range with multiple criteria 7
Access MS access, Table id query help 0
It was working perfect 9
Query help please! 2
Percentage Change 2
Access Sorting and grouping using multiple tables 0

Back
Top