Search results for query: *

That's it, thanks Dhookom! I prevented SE from being = to 0 and that worked! Any idea why?

No, I exclude all of the null values in either arrival or triage in the Qry_Times_ArrTrge query. Yes, all of the date and numeric fields are right aligned. What I also notice is weird is that if I run a query from 1/1/06 to 4/1/06, that works, but the following will not work: 3/1/06 to...

I've created a form that times to the underlying query "Qry_Times_ArrTrge"

I'm not sure why I'm getting this error, I'm hoping someone can help me out. I'm using the query below and when I do a date range of 3/1/06 to 3/31/06 I get an error that says the Query expression is incomplete or too complex. However, when I do the same query from 2/1/06 to 3/1/06, there is...

...and cut out the excess. Makes sense. Thanks for your help! Mike SELECT HospCodes.[Hospital Name], Count(Records.AcctNum) AS CountOfAcctNum, 2*StDev((([Triage]-[Arrival])*24*60))/(Count([Records].[AcctNum])^0.5) AS 2SE, Min(Records.Date) AS MinOfDate, Max(Records.Date) AS MaxOfDate FROM...

I keep getting a "Cannot have aggregate function in Group By Clause" for the 2*[StDevArr2Triage]/([CountofAcctNum]^0.5) expression. Any suggestions? Thanks! Mike

...want it to? Thanks! This is my query: SELECT HospCodes.[Hospital Name], Count(Records.AcctNum) AS CountOfAcctNum, StDev((([Triage]-[Arrival])*24*60)) AS StDevArr2Triage, Min(Records.Date) AS MinOfDate, Max(Records.Date) AS MaxOfDate, 2*[StDevArr2Triage]/([CountofAcctNum]^0.5) AS 2SE FROM...

Perfect, that worked! Thanks for all of your help!

Knicks-thanks for your response. This is where I was getting a bit confused. Where do I actually enter: Between [Forms]![frmMyForm]![Text4] And [Forms]![frmMyform]![Text6]

I have a similar situation that I am trying to adapt my report to so I was hoping you could help with this. I have multiple queries in a report (through a sub-report) and I want to define the beginning and ending date for each query. One way I was thinking about solving this is by creating an...

thank you and I appreciate your help DZ!

that's an excellent point and rarely, yes, it's a situation that we encounter. However, this data is entered in the same way. For example: 1 AM the next day is 25:00 and 2 AM (2 days from now) is 49:00. However, I change the formatting in Excel to a numeric format (1.04 and 2.04...

I converted all of the dates over to a generic number format and this solved all of the problems. Before, I used the Excel format which allows you to see date/time and now that I used just a number to represent the date, access interprets the time difference correctly! Thanks!

I believe that Access actually converted 1/0/1900 to 12/30/1899, not 12/31/1899 as I would have predicted.

DZ-thank you for your response. I think part of the problem is the fact that Access doesn't recognize 1/0/1900 as a valid date and converts it to 12/30/1899 upon import. As far as importing the data, I've been using the Get External Data. I've been entering 27:00 into Excel, not Access...

I imagine this has been solved in another thread, I just cannot find the answer to my question. If you know the thread, please let me know. I've been spending too much time on this and can't find a solution. I have 2 times in an XL spreadsheet: Arrival and Discharge. When I look at the...

about 3 buttons, 1 GIF and 3 textboxes. Also, if Access does allow me to save the changes. When I shut the program down and go into it later, it won't let me open the form in design or by any other method. Aaaargggggh!

about 3 buttons, 1 GIF and 3 textboxes

I have no idea why this is happening so any help would be much appreciated. I've been creating a client interface with command buttons linked to macros. Initially when I created this main form, everything was fine. I went back to add a button that enabled another report to be run but when I...

This may sound really stupid, so I apologize in advance, but where do I input: DaysinLastThreeMo = DateDiff("d", DtEnd, DateAdd("m", 3, DtEnd)) Thanks! Mike