How do you get quarterly results using Crosstab qry? 1

[drussum]

Following is a question I posted earlier. If there is anyone who can help I would really appreciate it.

I am creating a crosstab qry that uses the following fields: [ItemNumber] [ItemDesc] for row headers. Then Column Header: [Plan Del Date] and sum by [Back Order]. The [Item number] is being taken from a list box on a form as well as is [Plan del date] (similar to Qry by form). I am able to make the above work fine when I a grouping by "MONTH", however when ever I try this with gouping by "Quarter" I keep getting an error saying

" The Microsoft Jet engine database does not recognize '[forms]![frmdate4]![ctlItem#ListBox]'as a valid field name or expresion."

The problem is that the field name and expresion are entered correctly and work fine with "MONTHLY" Grouping.
There is no error. They are both using the same qry. Only when I try to use "GROUPING" do I get an error.

any ideas??
Thanks

 

[drussum]

any ideas??

 

[Trainingjason]

Perhaps another method in a cross tab would be to type the following

nameoffield:format([plandeldate],[enter date type]), column

select the query menu and parameter and type
[enter date type] text

When you run your query you can then enter any formatted date you like for example
q-yyyy quarterly yearly
ddd day of week

Hope this helps


Jason


Jason