What is wrong with my query?

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

Guest

In the criteria of a column in a query I have written the following statement:

IIf(tbl_Budget.MonthYear="Jul 05" And tbl_Budget.GL=60 And
tbl_Budget.Process="S",tbl_Budget.Budget,0))

I get a #Name? error in the field that this is pointing to on the form. Is
it because I have too many And's? Is there a way around this? Thanks. :)
 
I would make this a calculated field (expression) in the query.

CalcBudget: IIf(tbl_Budget.MonthYear="Jul 05" And tbl_Budget.GL=60 And
tbl_Budget.Process="S",tbl_Budget.Budget,0))

Also, if the double quotes give a problem, try single quotes.

UpRider
 
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

Data Mismatch in Excel 2010 4
Query Criteria IIf statement 4
Option Buttons to Pass Criteria to Query 6
Reusable statements in queries 2
Excel Need Countifs Formula Help 0
Query problems with Count(IIF( ...&....)) 2
Access Query problem 1
Aggregate Function Error 0

Back
Top