Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Canada
    Posts
    284
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How would I handle different years in a database? (Access 2000)

    Okay, I'm having a brain freeze! I can't seem to figure out how to handle different years. I want to be able to select the year I want to work in. Then I just see the invoice and payments for that year. I'm not sure how to say I want the information that corresponds to the year I select in a drop down box. Any ideas?

    I want to be able to select students from a list of that years (that I selected) students. Then do up invoices using that years fees list. I also want to show the year I selected on my forms and reports.

    I'm just going around in circles trying to figure this out! <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>

  2. #2
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How would I handle different years in a database? (Access 2000)

    Is it a normal year, January to December, Or is it a financial year like a April to march?

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Canada
    Posts
    284
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How would I handle different years in a database? (Access 2000)

    It's a financial year, from September to August.

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How would I handle different years in a database? (Access 2000)

    This program contains a form that you should be able to adapt to your needs. The only problem I foresee for you is that I use UK dates.

    I originally wrote this in a DOS based program called Alpha Four. Then I upgraded it to Microsoft Access.

    Many small businesses use a till to record their cash transactions. It is possible and sometimes necessary to group stock into

Posting Permissions

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