Search results for query: *

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

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

Please, can someone tell me what is wrong with this formula? IIF([Completed Date]>[Ordered Date][Completed Date-Ordered Date]),"Order Date Time After Completed") The results should be if the Completed Date is greater than the Ordered Date, subtract the ordered date from the completed date...

I have a hughe db that captures all of the information needed to create a check request based on the different type of procedures by each physician. The check request query is capturing all of the correct data, which consist of 3 different test types; holters, resting ecgs and exercise testing...