If statements

  • Thread starter If statement in a Query
  • Start date
I

If statement in a Query

I have a table called Tbl Melissa Timesheet and a query called Melissa Hours.
I am trying to make a timesheet so that the field called Billable rate in the
query will populate with "70" if the field called Billable vs Non-Billable
returns a result of "yes" if the result is no then I want it to return "0". I
tried the statement:

If [Tbl Melissa Timesheet]![Billable vs Non-Billable] = "yes", "70","0"
 
K

KARL DEWEY

Try this --
IIf([Tbl Melissa Timesheet].[Billable vs Non-Billable] = "yes", "70","0")

I am assuming that the field [Billable vs Non-Billable] is in table [Tbl
Melissa Timesheet] and not in query Melissa Hours.
 

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

Query set-up not using cross-tab 9
Query: Billable Hours vs. Non-Billable Hours 3
If statement to show rate or zero rate 0
Complex Lookup 3
Timesheet cube negative values Project Server 2007 6
Can we monitor timesheets in MS Project Server 1
Time and Billing Database Setup Question 2
How to write an MDX query to create a new Billed Hours measure? 0

Top