Page 2 of 2 FirstFirst 12
Results 16 to 19 of 19
  1. #16
    djclntn is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2011
    Posts
    476
    Ok, I made some time.

    In my DailyTask Table I created a Markup Field.

    Here the expression I tried:
    IIf([TDATE]>=12/1/2011,[ProjectID]*1.1,[ProjectID]*[.7%])

    I didn't know what to put in the "markup" brackets?

  2. #17
    stevepcne is offline Novice
    Windows XP Access 2007
    Join Date
    Nov 2011
    Location
    Boston, Ma.
    Posts
    23
    Bob:I agree with your reply, thanks for the correction and link.

  3. #18
    djclntn is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2011
    Posts
    476
    I tried:
    =iif([TDATE]>=*#*12/1/2011*#*,[ProjectID]*1.10,[ProjectID]*[markup%])

    "You may have entered a comma without a proceeding value or identifier"

  4. #19
    boblarson is offline --------
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    1,272
    Quote Originally Posted by djclntn View Post
    I tried:
    =iif([TDATE]>=*#*12/1/2011*#*,[ProjectID]*1.10,[ProjectID]*[markup%])

    "You may have entered a comma without a proceeding value or identifier"
    I'm a little ready to scream ...

    Did I have quotes around the # when I posted what I posted? NO I DIDN'T! So why did you add them? WHY???????

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. What's wrong with my query?
    By Grek in forum Queries
    Replies: 2
    Last Post: 10-31-2011, 12:12 PM
  2. Expression gives wrong results
    By newtoAccess in forum Queries
    Replies: 22
    Last Post: 12-03-2010, 12:21 AM
  3. What's wrong with this query?
    By jsoldi in forum Queries
    Replies: 2
    Last Post: 10-11-2010, 07:45 AM
  4. Query for latest date? what am I doing wrong?
    By Overdive in forum Queries
    Replies: 1
    Last Post: 12-18-2009, 06:04 AM
  5. What's wrong with this expression
    By tallroger in forum Access
    Replies: 1
    Last Post: 05-05-2009, 04:00 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums