Search results for query: *

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

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

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.

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

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

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

Got it! Again, thank you so much!

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

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

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

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

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

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

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")

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 &...

I'm not sure I'm understanding fully, here is the formula now and it does not work, so I am positive I have it wrong. IIf([Completed Date]>[Ordered Date], Int(([Completed Date]-[Ordered Date])*24) & ":" & (([Completed Date]-[Ordered Date])*24-Int(([Completed Date]-[Ordered Date]*24))*60 &...

I'm sorry, I must not be understanding. I thought you meant for me to use the int formula you supplied: SkipVought (Programmer) 29 May 09 10:32 Substitute this for the FORMAT statement Int(([Completed Date] - [Ordered Date]) * 24) & ":" & _ (([Completed Date] - [Ordered Date]) * 24...

Int(([Completed Date]-[Ordered Date])*24) & ":" & (([Completed Date]-[Ordered Date])*24-Int(([Completed Date]-[Ordered Date]*24))*60 & ":")

A Data type mismatch error is showing on this formula. I've checked the design table and the data types on the columns are all set to Date/Time. Could there be a problem within the formula?

What is the & _ doing? Int(([Completed Date] - [Ordered Date]) * 24) & ":" & _ (([Completed Date] - [Ordered Date]) * 24 - Int(([Completed Date] - [Ordered Date]) * 24)) * 60 & ":"