Results 1 to 2 of 2

Thread: Query for inventory report

  1. #1

    Thread Starter
    Hyperactive Member yousufkhan's Avatar
    Join Date
    Jan 2002
    Location
    India
    Posts
    492

    Query for inventory report

    I have 2 tables I SQL DB
    1.BedMaster - fiels(WardNo,BedNo,BedSts)
    Data(G2,G1,A)
    2.Admissions fileds(AdmNo,PatientNo,BedNo,AdmissionDate,DischargeDate)
    Data(101,55,G1,21/07/2013,27/07/2013)

    this type of data I m capturing in the tables
    I want to generate a report for bed inventory on any date example on 28 JUl
    I want to know how many beds were occupied on 25th jul
    how can I make a query for it
    I have the admissiondate and dischargedate for bedno
    how can query to know about the date between this tow dates

  2. #2

Posting Permissions

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



Click Here to Expand Forum to Full Width