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!

  • Congratulations Wanet Telecoms Ltd 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: *

  1. mward04

    Query expressoin is too complex???

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

    Query expressoin is too complex???

    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...
  3. mward04

    Query expressoin is too complex???

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

    Query expressoin is too complex???

    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...
  5. mward04

    Multiple expression query

    ...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...
  6. mward04

    Multiple expression query

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

    Multiple expression query

    ...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...
  8. mward04

    One Parameter Feeding Multiple Queries on One Report

    Perfect, that worked! Thanks for all of your help!
  9. mward04

    One Parameter Feeding Multiple Queries on One Report

    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]
  10. mward04

    One Parameter Feeding Multiple Queries on One Report

    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...
  11. mward04

    Query for Times Past Midnight

    thank you and I appreciate your help DZ!
  12. mward04

    Query for Times Past Midnight

    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...
  13. mward04

    Query for Times Past Midnight

    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!
  14. mward04

    Query for Times Past Midnight

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

    Query for Times Past Midnight

    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...
  16. mward04

    Query for Times Past Midnight

    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...
  17. mward04

    Form won't save

    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!
  18. mward04

    Form won't save

    about 3 buttons, 1 GIF and 3 textboxes
  19. mward04

    Form won't save

    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...
  20. mward04

    Calculating # of Days in past 3 months

    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

Part and Inventory Search

Back
Top