What If

  • Thread starter Thread starter Not clever enough by half!
  • Start date Start date
N

Not clever enough by half!

In Excell you can calculate 'backwards' to get a desired result. Ie. To find
a break even figure you provide 0 as the desired result and "What If"
calculates how many sales to acheive it.

Can I do something similar in Access?

Tried general discussion but no luck.
 
Sometimes IIF statements may help in your query. IIF([your
field]=something,[true part],[false part]) Post exactly what you need to do
and it will be a lot easier to give you advice.
 
You posted the same question in the main Access group. Multi-post (one
message to several groups) if you must, but cross-posting (identical
messages to several groups) is a waste of everybody's time.

"Not clever enough by half!"
 
Back
Top