Search results

I have a query with the following code: SELECT aqryMonthsDatesForComboQuery.[Month/ Year], [aqryTotalEDInHouse&RegionalTreated].TotalEDTreated, [aqryTotalED(RegionalTransferred)PtsTreated].[Total Regional Transferred Pts Treated], [aqryTotalEDInHouse&RegionalTreated].TotalInHouseTreated FROM...

I have a query that has been running perfectly until yesterday. There is a parameter criteria which states "Which Neurologist?". It works for all Neurologist but one. Here is the error message that I get- "This expression is typed incorrectly, or it is too complex to be evaluate. For example, a...

First, I am a novice to experienced beginner so bare with me. I have a form that requires a start date and end date. I have made a combo box (on the same form) with list of the doctors to be selected as the criteria in a query. The query is not working. Here is the SQL: "SELECT...

I have two queries and give me a result for each that I want to subtract. In the SQL world, this is not as easy as it sounds. I am about the drive myself insane. :confused: And the info. that I have found on the internet has been no help. Here are the two queries- TotalEDCalled= SELECT...

I have form with a date range criteria, a combo box with a list of queries to perform and a command button to run the median of a result located in a tablefrom the selected query. I am a true beginner of code so I have pieced this together. But I don't know how to get it to perform three...

I want to use a form to select the date range and query to be ran and then calculate the median of a list of values within the query. I have the form built, the queries built but I can not get the record source right to call up the list of queries. :confused: I would like the median to be...

I have a database that I want to be able to produce a report of total individual treatments received. For example, Month/year Total IV tPA Total IA tPA Total IV & IA tPA 12/10 4 0 1 1/11...