Results 1 to 2 of 2
  1. 04-29-2015, 10:03 AM #1
    De Riva Giana
    De Riva Giana is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2015
    Posts
    1

    Help me, please... (novice user)

    Hi, I'm a novice user, I have a list of items that have 2 different payment method, one is daily the other is weekly, I already make a Yes/No in one of my column, yes for daily payment. Can I make a query statement that will calculate price with 'No' multiplied by 4 and price with 'Yes' multiplied by 30, so I will have result for monthly payment? Sorry if my question is kinda silly, but if you can help me how top solve this, I will be really, really, really grateful, thank you so much.
    Reply With Quote Reply With Quote
  2. 04-29-2015, 10:09 AM #2
    pbaldy's Avatar
    pbaldy
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    Along the lines of

    Price * IIf(PaymentMethod = True, 30, 4)
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Design Help for Novice Access User
    By jk1809 in forum Database Design
    Replies: 3
    Last Post: 08-07-2012, 10:20 AM
  2. Novice User Needing Help Building a Database
    By softspoken in forum Database Design
    Replies: 1
    Last Post: 10-11-2011, 09:29 AM
  3. Novice User Help Please
    By bmschaeffer in forum Access
    Replies: 18
    Last Post: 08-26-2011, 09:12 AM
  4. Very Novice User needs HELP with Form
    By Insanity Queen in forum Forms
    Replies: 1
    Last Post: 12-02-2010, 01:20 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Other Forums: Microsoft Office Forums