Search results

What you said is exactly what I've done. The problem is that instead of creating a query, I need a report off of a crosstab query. Things don't work that easily with the crosstab query.

Well, I was glad that I made this cross-tab query finally work the way I wanted but now there's another problem... The whole point of creating this cross-tab was to create a report out of it that would be easier for me to read, but now, when I try to create a report using the wizard based on...

Nevermind, I figured it out, and yes it works now! Finally, this was driving me insane. Thanks a lot Pat Hartman and Doc_Man.

Ok, but how exactly should I define these parameters?

Already tried that, still doesn't work. By the way, I changed the form "Report"'s name to "form_dateinput", but it still wouldn't work. I just give up, I guess I'll have to deal with the confusing report that the regular query provides. I tried to see if I can get support from Microsoft, but...

Well I think you might be misunderstanding somethings here. The "Report" here is not actually the report itself but just the name of the form which has the fields "DateX" and "DateY" for the user to input the date interval. I guess I should have named it something different to avoid confusion...

Well, I looked at the SQL code for the crosstab query and I couldn't see anything that would be causing that. Here is the code, maybe you could tell if there's anything out of order: TRANSFORM Sum(TimeSheet.Id) AS SumOfId SELECT TimeSheet.Employee FROM TimeSheet WHERE (((TimeSheet.Date) Between...

Let's say we have a table in which one of the fields is Date. Now let's say we want to create a simple report from that table, but the user has to pick the date interval. So, the report will have to display records only from X date to Y date. We create then a form called Report with 2 fields for...