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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by mddaniels

  1. mddaniels

    Query Results by Quarter of Year

    You are a God send. I knew it had to be simple and not complicated. Thank you so very much. Have a Blessed weekend.
  2. mddaniels

    Query Results by Quarter of Year

    I need to be able to pull data by quarters of year. Quarter 1 should be months 10, 11, 12, quarter 2 should be 1, 2, 3, quarter 3 should be 4, 5, 6 and quarter 4, 7 , 8, 9, then I need to be able to count how many Pacer upgrades are in each quarter, how many Pacer new are in each quarter and...
  3. mddaniels

    Syntax Error in Expression

    If that is what the Access software is doing when it highlights the area in the sql statement syntax error, that was my asumption. However, removing that portion did not correct the syntax error.
  4. mddaniels

    Syntax Error in Expression

    I'm probably confusing the issue trying to explain. The syntax error is in the sql statement- SELECT ID, [Completed Date], [Procedure], [Dictating MD], Technologist, Location, [Ordered Date], [Arrived Date], IIf([Completed Date]>[Ordered Date],(24*Int([Completed Date]-[Ordered...
  5. mddaniels

    Syntax Error in Expression

    This expression is working in that it returns correct results in the query, however, when I try to filter the query say by 'between 5/1/09 and 6/1/09', a syntax error message happens. VH helped me with the expression initially and as I said it does work in the query, as long as I don't try to...
  6. mddaniels

    IIf formula help

    Can you tell me where the syntax error is in this expression? SELECT ID, [Completed Date], [Procedure], [Dictating MD], Technologist, Location, [Ordered Date], [Arrived Date], IIf([Completed Date]>[Ordered Date],(24*Int([Completed Date]-[Ordered Date])+Format([Completed Date]-[Ordered...
  7. mddaniels

    IIf formula help

    Got it! Again, thank you so much!
  8. mddaniels

    IIf formula help

    Thank you so much for your help!! I have not idea why this is working, but I intend to study it until I do know. Placing PHV's expression in the 'field' area of the query is giving the results that I need, with the exception of the seconds. Sorry it took so long, but believe me I do...
  9. mddaniels

    IIf formula help

    This expression returns no data: Why does the ; continue to appear in the expression, when it is not typed into the expression? Is this causing the problem? SELECT ID, [Completed Date], [Procedure], [Dictating MD], Technologist, Location, [Ordered Date], [Arrived Date], IIf([Completed...
  10. mddaniels

    IIf formula help

    Sorry, I did not mean to be confusing. Is this how the entire expression should look to have the query to return the lapse of time from ordered date to completed date? If so there is still a data type mismatch. SELECT [Critical Value Quality Report tbl].ID, [Critical Value Quality Report...
  11. mddaniels

    IIf formula help

    SELECT [Critical Value Quality Report tbl].ID, [Critical Value Quality Report tbl].[Completed Date], [Critical Value Quality Report tbl].Procedure, [Critical Value Quality Report tbl].[Dictating MD], [Critical Value Quality Report tbl].Technologist, [Critical Value Quality Report tbl].Location...
  12. mddaniels

    IIf formula help

    I think it will be easier to just put the formula into the excel spreadsheet that has to be imported anyway. But, could you tell me how to make the custom formatting in excel [h]mm:ss to work in Access. I don't see custom formatting in the design view for the table. The difference is the...
  13. mddaniels

    IIf formula help

    Here is the result from the simple expression ([Completed Date]-[Ordered Date]). Notice that ID #1 and #1 5 are missing. I'll show you why but don't understand why. ID Completed Date Location Ordered Date Ordered to Completed HH:MM 2 3/13/2009 9:38:00 AM CARDIOLOGY - MEDICAL CENTER 3/13/2009...
  14. mddaniels

    IIf formula help

    Still getting the 'data type mismatch in criteria expression' error. IIf([Completed Date]>[Ordered Date], Int(([Completed Date]-[Ordered Date])*24) & ":" & (([Completed Date]-[Ordered Date])*24-Int(([Completed Date]-[Ordered Date])*24))*60, "Order Date Time After Completed")
  15. mddaniels

    IIf formula help

    The error is 'the expression you entered contains invalid syntax, or you need to enclose your text data in quotes'. IIf([Completed Date]>[Ordered Date], Int(([Completed Date]-[Ordered Date])*24) & ":" & (([Completed Date]-[Ordered Date])*24-Int(([Completed Date]-[Ordered Date]*24))*60 &...
See more

Part and Inventory Search

Back
Top