Recent content by ambrn14

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