Results 1 to 8 of 8
  1. #1
    4 Star Lounger
    Join Date
    May 2002
    Location
    Roanoke, Virginia, USA
    Posts
    493
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Receipt form (A2K)

    We currently have a guest check in form (frmCheckIn) where the operator enters minimum information and a receipt (rptReceipt2) can be generated. Basically the operator enters the guest name, room # and length of stay and the rent begin date. The program looks up the room rate, calculates the rent end date, the sales taxes and the total amount due.

    The Federal Government has a new requirement that in order to get reimbursed, government employees must have a receipt that shows the daily room rent and the daily taxes. Currently, the only way to satisfy this requirement is to print out a daily receipt for each day stayed. This is rather labor intensive and would produce a separate receipt for each night stayed.

    The requirement for government reimbursement is a maximum of a 7 days stay per receipt. I would think the rate portion of the invoice would look something like this. Each date stayed would be listed separately.

    Date Rate Total Taxes Total Due
    02/16/09 $79 $8.69 $87.69
    02/17/09 $79 $8.69 $87.69
    02/18/09 $79 $8.69 $87.69
    Grand Total $26.07 $263.07

    The four records (Receipt numbers) in tblRental are 106686-106690. If you open frmCheckIn it will ask for a receipt number.

    We may need to create a separate Check In form for government employeed.

    Any suggestions would be appreciated.


    Tom
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Receipt form (A2K)

    What exactly is your question?

  3. #3
    4 Star Lounger
    Join Date
    May 2002
    Location
    Roanoke, Virginia, USA
    Posts
    493
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Receipt form (A2K)

    I haven't been able to figure out how to design and populate a receipt that would accomplish the listing by date.

    Tom

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Receipt form (A2K)

    I'd create a table tblDates with a single Date/Time field; populate it with a list of all dates you want to cover (say from 01/01/05 to 12/31/10 or so); the easiest way to get the dats is to fill a series in Excel and copy it into tblDates.
    Next, create a query based on tblDates and tblRental. Add the date field from tblDates and all fields (*) from tblRental, and set the criteria for the date field to

    Between [RentBegDate] And [RentBegDate]+[NumberofDays]-1

    This query will return all dates of each stay. You can use this query in further queries.

  5. #5
    4 Star Lounger
    Join Date
    May 2002
    Location
    Roanoke, Virginia, USA
    Posts
    493
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Receipt form (A2K)

    I have created the tblDate and it is returning the initial date twice and then lists the other dates correctly.

    Tom

  6. #6
    4 Star Lounger
    Join Date
    May 2002
    Location
    Roanoke, Virginia, USA
    Posts
    493
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Receipt form (A2K)

    I am also confused as to how the tblDate is related to tblRental. How does it know which RentBegDate to use? I tried manually inserting the OrderID number into the query (to select the needed record) but this does not seem to help.

    Tom

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Receipt form (A2K)

    See the query qryRental in the attached version. I had to remove the forms, report and macros to keep the file size down.
    Attached Files Attached Files

  8. #8
    4 Star Lounger
    Join Date
    May 2002
    Location
    Roanoke, Virginia, USA
    Posts
    493
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Receipt form (A2K)

    Thanks. I will try to figure out where to go from here.

    Tom

Posting Permissions

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