IF

  • Thread starter stephendeloach via AccessMonster.com
  • Start date
S

stephendeloach via AccessMonster.com

When I run my report, it queries the date, name, and bill to.. how can I
make it when I type in Bill to: Stephen. it puts my address in the Bill To:
text box?
 
S

stephendeloach via AccessMonster.com

Im guessing it would be an IIF function? IF [Bill To]=Stephen, then [Bill To]
=the address...
 

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

Ways to create a budget chart for money managment 1
Re-install office 2019 1
Spell Check issue 2
function like vlookup in infopath 0
Look Up Formula With Veried Search Range 2
Count 3
Pass Dialog Box entry to new Query Dialog Boxes 5
using iif and like in control Source of report 1

Top