Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2009
    Posts
    2

    Smile Fortnightly Dates


    I am a little new to VBA. I have a table of start dates and values which are weekly, fortnightly and monthly payments. I want to expand this table into a new table showing all the dates and values for a 12 month period.

    eg Start Date 1-4-09 $100 Fortnightly

    Expand to 1-4-09 $100
    15-4-09 $100
    29-4-09 $100
    etc.......

    Hope someone can help me.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Why do you need this table since all of the dates can be calculated?

  3. #3
    Join Date
    Apr 2009
    Posts
    2
    I am trying to set up a personal budget showing all payments in one table so I can then generate a graph from it.

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Have you already looked at all of the templates available from Microsoft?

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

Similar Threads

  1. Exracting Dates
    By Elizabeth in forum Access
    Replies: 2
    Last Post: 04-02-2009, 11:26 AM
  2. Handling dates in queries
    By mrk68 in forum Access
    Replies: 4
    Last Post: 03-23-2009, 06:35 AM
  3. calculating due dates in access
    By trixxnixon in forum Forms
    Replies: 0
    Last Post: 09-28-2008, 12:35 PM
  4. Searching Dates
    By knightjp in forum Database Design
    Replies: 2
    Last Post: 08-16-2008, 11:39 PM
  5. Help with Searching Dates
    By rededdie in forum Access
    Replies: 1
    Last Post: 11-02-2007, 08:34 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
  •  
Other Forums: Microsoft Office Forums