access expressions

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

Guest

how do I write this expression in a query:Count = 1=$100.00, 2=$500.00,
 
flyboy said:
how do I write this expression in a query:Count = 1=$100.00, 2=$500.00,
Click to expand...

Try this:

IIf([Count] = 1, 100, IIf([Count] = 2, 500, 1000))

Tom Lake
 
You must log in or register to reply here.

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

Calculate Start and End Date of a Quarter 8
Query Help.. Creating a running Total Field????? 8
Formula to extract only numbers and decimal 2
look for subtotal 5
Top 5records by highest 90+ bucket 1
to link information between two lists 16
Need help to write a query that returns a value for a given date 1
Average 5

Back
Top