Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Doc94
  • Content: Threads
  • Order by date
  1. Doc94

    Median and group by

    I am trying to expand upon and already useful median query in SQL. I need to figure out where to put a GROUP BY statement so I can get the median "length of stay" grouped by a field in the table called "TSheetTitleDescription". The folowing is the median query that works flawlessly: SELECT...
  2. Doc94

    Median

    I need some help with a median calculation. I can calculate the median length of stay for a group of patients with the following query I picked up. SELECT Avg([R1]) AS Median FROM [ SELECT Max(Q1.R2) AS R1 FROM (SELECT TOP 50 PERCENT LOS_min_amb_work.los AS R2 FROM...
  3. Doc94

    Median

    I am trying to calculate the median of some times taken from a query. The query calculates time from arrival to disposition in minutes. (by multiplying the time by 1440). My access report can spit out the average of these for all the patients but the median is a different story. I have dound...
  4. Doc94

    Number present during a time period

    I am looking for some expertise in writing a query. This is from a large Emergency Department database written in access 2000, front and back end...... I have a patient ID (unique), arrival time and discharge time. What I need to do is count the number of peole in the department each hour. I...
  5. Doc94

    Report field

    I have a report based on a query. I need one of the report fields to get it's result from two different query fields. Any help would be appreciated.
  6. Doc94

    Sorting and grouping

    I have a reprt based on a query. Each listing in the report has multiple items- name, account number, mode of arrival, diagnosis. All of the items are single in the listing except diagnosis which may have multiple items. When I run the report it lists a name and account number and all the...
  7. Doc94

    Security

    How do I move a database I created and secured on my laptop to a network drive and then on to computers for other folks to use? I have copied the security file (mdw) to the other computer but it does not give me the ability to use the workgroup administrator tool to join the mdw file. It says...
  8. Doc94

    Migration to SQL server

    I have an extensive database I would like to convert to SQL server. I created it in Access 97 and have upgraded to access 2000 (no further as all of the computers on the network do not support Access beyond 2000). I have a front end on each cmputer that uses it and a backend residing on one of...
  9. Doc94

    Time interval shutdown

    I am looking for a way to use the time interval to automatically shut down a database after a period of inactivity. It is health care related and HIPPA requirements dictate this. Any thoughts on the code would be appreciated. And where the code should be inserted- into the main data entry form...
  10. Doc94

    Find duplicates in last 48 hours

    I am working on a duplicates query. Some data points I am using are the date and say medical record number. I am looking to run a duplicates query between certain dates. That part is easy. But I want the records to be returned only if it is a duplicate in the last 48 hours. So for instance...
  11. Doc94

    Subreports

    I have a main report based on 3 subreports. Of course the three subreports are based on 3 queries. I want all three subreports to limit the records to a certain date range. Now I can do it for each subreport by specifying in the query under the date field "between [paramter 1] and [parameter...
  12. Doc94

    Persons in a department

    I need some help writing a query. I need to know how many patients are in my department at a given day and time. Currently, my database records the time they are admitted and the time they are discharged. Arrival time is HospitalArrivalTime which gives date and time. It is shortened using...
  13. Doc94

    Yet another date/ time question

    I have taken a few folks advise and created a date field that defaults to todays date and a time field that remains an enterable field on the form. However, I still need to have the date/ time field as I have multiple queries(hundreds) based on it so I am looking to this group for an answer- On...
  14. Doc94

    Another Date Question

    I have a form that uses a query of an underlying table as it's record source. I have a date/time field as follows: Arrival Time 09/02/03 16:33 I use an input mask as follows 99/99/00\ 00:00;0;* Now to the problem- to speed up data entry (since my IT department can not generate an interface...
  15. Doc94

    Interesting Date Problem

    I have an interesting problem in trying to get report dates. I have a query to report a count of certain records. a report is linked to this query that is run each day and gives the total by day starting at the begining of the month through the current day. I t is run each moring for the...
  16. Doc94

    11pm to 11 pm

    OK complex problem I have not been able to get to the bottom of. I have a query that needs to pull out records for a time period as follows: SELECT [11-7_tally_report].DispositionVehicle, [11-7_tally_report].[ED#], [11-7_tally_report].Pediatric, [11-7_tally_report].Adult...
  17. Doc94

    Hours

    How would I return a time interval based not on 24 hour clock but rather based on 11pm one day to 11 pm the next day? I am able to sort my records by hour but I need to then count them by the time interval of 11pm-7am(which of course crosses over the midnight time period into a new day) 7am-3pm...
  18. Doc94

    Month Report

    I want to run a report part of which is based on a query with a date/time field. I want the report run each day from the begining of the month without user input of dates. So for example, today is 8/13/03 and todays report would include all of the dates from 8/1/03 through today and tomorrow...
  19. Doc94

    IIf Statement

    I have the following SQL statement in a query: IIf([Detail]![DispositionCode]=41,1) AS Admitted Where 41 is the admitted disposition code. I would like for it to say if it is 41 or 31 or 12, 1 as admitted but I can not come up with the correct syntax. And I need to use this because in the...
  20. Doc94

    Help Files

    I am trying to create help files for my database. Any suggestions on how to set this up? I have thought about setting up a control that opens a switchboard but am not sure then where to place the help files.

Part and Inventory Search

Back
Top