Results 1 to 4 of 4
  1. #1
    Kumar is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Mar 2020
    Posts
    5

    How to create Calendar table in MS Access ?

    Hi,
    I am working on to create a database in MS access for my vacation rental firm. In one of the table I need to store the day wise rental  details ( base rent, additional bed charges, kids charges etc) of our property for all the days of the year. I think it is very difficult to create this manually.

    Is there any option create like Calender table to maintain day wise details...I am basically a mechanical engineer and not familiar with coding, please let me know if we have any easy ways to create.



    Thanks,
    S.Kumar

  2. #2
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,557
    Hi

    This gives you an idea of how to model this http://www.databaseanswers.org/data_...tals/index.htm

  3. #3
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    do you mean you have a rental say from 1st March and 10th April at £10/day and you need a view detailing each day? and then another rental 1st May to 5th May at £12/day?

  4. #4
    Kumar is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Mar 2020
    Posts
    5
    Quote Originally Posted by Ajax View Post
    do you mean you have a rental say from 1st March and 10th April at £10/day and you need a view detailing each day? and then another rental 1st May to 5th May at £12/day?
    Dear Ajax,
    Thanks for reply.
    Yes, I need to create and maintain day wise rental in the same way you said for the whole year.

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

Similar Threads

  1. Create an event calendar
    By WAVP375 in forum Access
    Replies: 1
    Last Post: 04-21-2019, 06:05 AM
  2. Replies: 4
    Last Post: 05-30-2016, 10:53 AM
  3. Replies: 3
    Last Post: 10-12-2010, 11:15 PM
  4. create calendar form
    By nwalke in forum Forms
    Replies: 0
    Last Post: 06-30-2009, 10:35 AM
  5. Create a calendar report?
    By valkyry in forum Reports
    Replies: 0
    Last Post: 09-14-2006, 11:34 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