Custum sort in a report

[abourg8646 via AccessMonster.com]

I have 2 questions. The 1st is I have a report built on a crosstab query. I'm
triing to do a custume sort on some field. In the query everything works but
when I set up my report and try to add a group header then my fields don't
sort correctly.

The second question is everytime I try to put something in the criteria of my
query then it puts brackets in my SQLatement and gives me an error. Is there
something that I can turn off so that it wont automaticly put brackets in my
SQL.

 

[KARL DEWEY]

Is there something that I can turn off
Any brackets that Access addds will not create an error that I know of. But
when you add something in the criteria of a crosstab query or a query that
feeds a crosstab you need to define the Parameters. Open the query in design
view, right click and select Parameters. Enter the exact name and datatype.
Reports ignore sort done in queries. In design view click on the Grouping
and Sorting. Select the field or fields to sort by.

 

[abourg8646 via AccessMonster.com]

It is the parrameter statement that changes. My statement looks like this

PARAMETERS Forms!frmDate!txtEndDate DateTime;

but when I change something it looks like this

PARAMETERS [[Forms!frmpDate]!t[xtEndDate]] DateTime;

Any brackets that Access addds will not create an error that I know of. But
when you add something in the criteria of a crosstab query or a query that
feeds a crosstab you need to define the Parameters. Open the query in design
view, right click and select Parameters. Enter the exact name and datatype.
Reports ignore sort done in queries. In design view click on the Grouping
and Sorting. Select the field or fields to sort by.

I have 2 questions. The 1st is I have a report built on a crosstab query. I'm
triing to do a custume sort on some field. In the query everything works but

[quoted text clipped - 5 lines]

something that I can turn off so that it wont automaticly put brackets in my
SQL.

 

[Duane Hookom]

I would make sure all the latest service packs are installed and turn off all
Autocorrect option in Tools->Options.

--
Duane Hookom
Microsoft Access MVP

It is the parrameter statement that changes. My statement looks like this

PARAMETERS Forms!frmDate!txtEndDate DateTime;

but when I change something it looks like this

PARAMETERS [[Forms!frmpDate]!t[xtEndDate]] DateTime;

Is there something that I can turn off

Any brackets that Access addds will not create an error that I know of. But
when you add something in the criteria of a crosstab query or a query that
feeds a crosstab you need to define the Parameters. Open the query in design
view, right click and select Parameters. Enter the exact name and datatype.

when I set up my report and try to add a group header then my fields don't sort correctly

Reports ignore sort done in queries. In design view click on the Grouping
and Sorting. Select the field or fields to sort by.

I have 2 questions. The 1st is I have a report built on a crosstab query. I'm
triing to do a custume sort on some field. In the query everything works but

[quoted text clipped - 5 lines]

something that I can turn off so that it wont automaticly put brackets in my
SQL.

 

[KARL DEWEY]

You might try putting your own brackets where they should go --
PARAMETERS [Forms]![frmDate]![txtEndDate] DateTime;

--
Build a little, test a little.

It is the parrameter statement that changes. My statement looks like this

PARAMETERS Forms!frmDate!txtEndDate DateTime;

but when I change something it looks like this

PARAMETERS [[Forms!frmpDate]!t[xtEndDate]] DateTime;

Is there something that I can turn off

Any brackets that Access addds will not create an error that I know of. But
when you add something in the criteria of a crosstab query or a query that
feeds a crosstab you need to define the Parameters. Open the query in design
view, right click and select Parameters. Enter the exact name and datatype.

when I set up my report and try to add a group header then my fields don't sort correctly

Reports ignore sort done in queries. In design view click on the Grouping
and Sorting. Select the field or fields to sort by.

I have 2 questions. The 1st is I have a report built on a crosstab query. I'm
triing to do a custume sort on some field. In the query everything works but

[quoted text clipped - 5 lines]

something that I can turn off so that it wont automaticly put brackets in my
SQL.