MS Access Help

I want to write a query to compare two date ranges and then, dependant upon the outcome i.e. date range 1 or 2, multiply them by different factors e.g. 1 or 2

Anybody know what I have to do?

Posted By: Stanley on December 30th 2009 at 12:02:24

Message Thread

MS Access Help (General Chat) - Stanley, Dec 30, 12:02:24
- Break it down into logical parts (General Chat) - Johnny Comecardiff, Dec 30, 12:09:58
  - Could you write a notional function for me? (n/m) (General Chat) - Stanley, Dec 30, 12:12:05
    - Can I suggest you RTFM then ask with what bits you don't understand (n/m) (General Chat) - Johnny Comecardiff, Dec 30, 12:13:54
      - Truncated message (General Chat) - Stanley, Dec 30, 12:21:54
        
        You're on the right lines (General Chat) - Johnny Comecardiff, Dec 30, 12:35:59
      - Function along the lines of: (General Chat) - Stanley, Dec 30, 12:19:03
        
        IIF([Date]=" (n/m) (General Chat) - Stanley, Dec 30, 12:19:45
- depends if the sufferer is in a wheelchair or not (n/m) (General Chat) - stringersrevenge, Dec 30, 12:04:13
  - Hope you get piles (n/m) (General Chat) - Stanley, Dec 30, 12:06:25

Reply to Message

In order to add a post to the WotB Message Board you must be a registered WotB user.

If you are not yet registered then please visit the registration page. You should ensure that their browser is setup to accept cookies.