Hi, this post is helping me get closer to what I am trying to achieve, and I am hoping you might be able to help me.
Let me explain my data. I link an sql table into access. This is a live table of raw data that is constantly updating. I am counting the data on 2 columns of groupings. These are basically records of every phone call. I do a count on callid. i group on the type of call and the "call center" it was placed from.
Here is the deal. I am trying to figure out how to take this, as I have it in a cross tab, and pass date criteria to it. it will be passed as text because the field is like 20040130. Not good, but thats how we get it.
Anyway. I tried your parameter suggestion, but I dont see it making that parameter for the date field.
here is how the crosstab appears
calltypelocal calltypeinternational etc
place1 5 22 4
place2 14 41 9
place3 you get idea
I am trying to get this all to a report. The user will need to specify the dates to view this for. I tried to do a parameter in the first query, the one that feeds the crosstab, but the crosstab wont take it. I got the same error as the original poster. So here I am, I tried this parameter thing, but it isnt pointing to my date field, so no matter what I put in the [startdate] and [enddate] parameters, it gives me the same data.
Please help?
misscrf
Management is doing things right, leadership is doing the right things