Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2009
    Posts
    3

    Question Access 2003 Query Help?

    Can you help?
    I need to create a query based on a cost price which may vary each year (e.g. Cost Price for Year1,2,3,4,5 etc all different?)

    I have created the Query which works fine - for Year 1 - but now need to "expand" for Year 2,3,4,5 etc

    I have a Date field within the same table / form to "dictate" which cost to insert?


    (Basically if cost in Year 1 = £1.00 & Year 2 = £2.00 etc - i need the Date field in the table / form to dictate the "correct" cost for that year?

  2. #2
    SpotoR1 is offline Novice
    Windows Vista Access 2007
    Join Date
    Mar 2009
    Location
    Japan
    Posts
    6
    If statement, if Year =1, 1.00, 2.00

    Like this: IIF([table]![Year], "1", "1.00", "2.00"

    Ray

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Import in Access (2003)
    By Claude in forum Programming
    Replies: 2
    Last Post: 06-18-2009, 12:49 AM
  2. converting from Access 2003 to Access 2007
    By LawrenceLau in forum Access
    Replies: 6
    Last Post: 11-20-2008, 03:53 PM
  3. Replies: 1
    Last Post: 09-06-2006, 11:48 AM
  4. access 2003 automation issue
    By BevA in forum Programming
    Replies: 2
    Last Post: 05-01-2006, 08:37 AM
  5. Help! Newbie needs help with Access 2003!!!
    By infernojericho in forum Access
    Replies: 0
    Last Post: 12-03-2005, 08:11 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