Search results

Yes, I know. But I have not had any luck with the combinations that I have tried. Should I remov the sort from the query?

Access 2007

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

Thanks for the replies. I found the problem. There was an error due to a missing data element in one of the queries within the main query and therefore it would not work. So you guys were right that it was in the problem record. Thank you!

Thanks! I will look at this record again. I just don't see anything different about this record.

I forgot to say that my form has pages on it. I have a form header that holds the text boxes for the start and end date. Then pages for different reports and queries. I don't know if that has anything to do with this combo box criteria not working. :confused:

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

Thanks for the suggestion. I will let you know if I get it working later. Have to go for now. ambrn

Is there any way around having Date/Time fields? My whole db have split date/time fields. And I am not sure that I follow your comment on "Between. . And. . .". ambrn

I also am having a problem with this. I am just trying to find how many times an event happened during this date and time range. My data is divided date and time fields. When I enter "18:45" as my "txtStartTime" and "06:45" as my "txtEndTime", my result gives me times from 06:45-18:45 instead of...

I have matching data (by month/year) for both counts. A third query that joins my 2 queries by the [month/year] field and do the subtractions is the query that I am having trouble with. Can you help me with the SQL for that type of query?

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

Well, I'm back. I am now trying to use the same concept as before with the median but to calculate the average. I know that the average is a standard calculation by using the Totals function but I would like for it to resulted in a message box like the median. I have attached the db. Any...

:p I made the changes and added the code: DoCmd.OpenQuery cmbQuery and it works!!! It runs both of my queries from the form!!!! Thank you soo much for all your help!!!! Have a great rest of the day!!!

Yes, I understand that the results are correct. But I did not run the queries using my form. I just ran the queries by themselves. When I use the form, it gives me the same answer for both queries. It is like it is not switching to the second query when it is selected or not clearing the...

Sorry that all ran together. I have attached a word file with the results from the excel calculation.

Here are the results (calculated in excel) of the two "aqmak. . . " queries if ran without the form. So there is a difference in the two medians. CodeStrokeDate(Onset to Door)CalcValue03-Jan-114504-Jan-113905-Jan-117545CodeStrokeDate (Onset to Door)CalcValue...

For example, I changed one of the door time values to give a long period of time and thus change the median value. When I test the form, it seems like the form is not clearing between queries. When I run the "aqmakDoortoIVtPAStartInterval", I get a median time of 45 min. from these values-...

I have updated the db with you suggestions. And it seems to be running the queries but is there any way that I can clear the queries and or "tmakMedianCalcValue" to be sure that it is not rerunning the previous query? I hope that this makes sense. I have attached the db with updated...