Results 1 to 2 of 2
  1. #1
    JSHEL is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2010
    Posts
    8

    scheduling db

    Ok i'm really stuck now. I'm writing a scheduling db for services work. My table has the fields of SiteName/Frequency/Month/Price. When I select quarterly for the frequency and then select say January for the month. I want the database to automatically store January/March/June/September. That way when I pull a report for any one of those months that site will be on the report and that a quarterly is due. I find this extremely hard to explain if more clarification is need I will post right away. Thank you so much for your help.
    Note: SiteName is filled in from the form.
    Jshel

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,722
    Here's some useful info when designing a database

    http://www.databaseanswers.org/approach2db_design.htm

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

Similar Threads

  1. Scheduling database in Access
    By ACS Newbie in forum Access
    Replies: 4
    Last Post: 01-21-2010, 10:32 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