Results 1 to 2 of 2
  1. 02-02-2011, 10:28 AM #1
    lhysell
    lhysell is offline Novice
    Windows Vista Access 2007
    Join Date
    Feb 2011
    Posts
    1

    Length of Stay

    I am new to using access and am having trouble figuring out how to calculate length of stay. I have 2 tables 1 containing admission date and 1 containing discharge date. I need to know how to find the length of stay. Any help would be greatly appreciated.
    Reply With Quote Reply With Quote
  2. 02-02-2011, 10:45 AM #2
    NoellaG's Avatar
    NoellaG
    NoellaG is offline VIP
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    1,044
    Hi,

    I suppose you can link the two tables in a query. When done so, look at the function datediff to calculate the difference between the two dates.

    gr
    NG
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Sort according to field length?
    By wawinc in forum Queries
    Replies: 4
    Last Post: 12-15-2010, 04:27 PM
  2. Converting a date to length of time
    By Duncan in forum Access
    Replies: 2
    Last Post: 11-10-2010, 05:53 AM
  3. Pop-up form to stay on top of other forms while executing VBA code
    By evander in forum Forms
    Replies: 3
    Last Post: 09-16-2010, 09:50 AM
  4. How to add leading zeros for 12 char length
    By catguy in forum Access
    Replies: 6
    Last Post: 04-30-2010, 01:57 PM
  5. How to check textbox field length dynamically
    By access in forum Forms
    Replies: 1
    Last Post: 06-01-2009, 04:05 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums