If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
Count by short date and group by agent name
Sorry, but I don't see how to relate that error to the query
I posted. There is nothing in the query that can get a data type mismatch error, much less in a nonexistent criteria. At this point, I am lost and have to wonder where you pasted the SQL. Into a "blank query" in SQL view or some place in a new query's design view?? Because it is rather difficult to use text messages to explain things in the query design grid, we normally speak queries using SQL view. If you are using design view we are speaking different languages and coherent communications have gone south. -- Marsh MVP [MS Access] Whitney wrote: Like I said, I used your exact SQL code and pasted it into a blank query. I did not specifiy any criteria. "Marshall Barton" wrote: Criteria? What criteria? You never mentioned any criteria. The least you could do is post an explanation of whatever the criteria is supposed to do along with a Copy/Paste of the query with this criteria. |
|
Thread Tools | |
Display Modes | |
|
|