Order by Clause

[Twila]

I'm utilizing a pre-designed template "Marketing Project Management Database"
and am experience a problem running some of the reports. Receiving the
message "the multi valued field 'Category' cannot be used in ORDER BY clause".

What do I need to do to correct the problem? I able to open all tables,
forms & queries without a problem.

Thanks.

 

[golfinray]

That is usually a problem in your query that drives the reports. You have an
"orderby" where you need where, or max, min, last or one of the other
functions. Or you can't have order by for category in the query.

 

[Twila]

This is the query that was written and seemed to work when I 1st openned the
database. Do I need to delete the "Order by" line?
SELECT Projects.*
FROM Projects
WHERE (((Projects.Status)="Completed" Or (Projects.Status)="On Hold"))
ORDER BY Projects.Status DESC , Projects.Priority, Projects.[End Date] DESC;

Thanks.

 

[KARL DEWEY]

Do you have a multi valued field 'Category' in your table?

Open the reports in design view and check to see if there isn't some left
overs in the Grouping and Sorting that you need to remove.
--
KARL DEWEY
Build a little - Test a little

This is the query that was written and seemed to work when I 1st openned the
database. Do I need to delete the "Order by" line?
SELECT Projects.*
FROM Projects
WHERE (((Projects.Status)="Completed" Or (Projects.Status)="On Hold"))
ORDER BY Projects.Status DESC , Projects.Priority, Projects.[End Date] DESC;

Thanks.

That is usually a problem in your query that drives the reports. You have an
"orderby" where you need where, or max, min, last or one of the other
functions. Or you can't have order by for category in the query.

 

[Twila]

I've tried deleting the "Order by" line in the query, but still receive the
same message when trying to open the report. Any Suggestions????

Thanks.

This is the query that was written and seemed to work when I 1st openned the
database. Do I need to delete the "Order by" line?
SELECT Projects.*
FROM Projects
WHERE (((Projects.Status)="Completed" Or (Projects.Status)="On Hold"))
ORDER BY Projects.Status DESC , Projects.Priority, Projects.[End Date] DESC;

Thanks.

That is usually a problem in your query that drives the reports. You have an
"orderby" where you need where, or max, min, last or one of the other
functions. Or you can't have order by for category in the query.

 

[Twila]

I do have Multiple Values built into the Category field of my table. Am I
unable to run a query or report if this function is used?

Thanks.

Do you have a multi valued field 'Category' in your table?

Open the reports in design view and check to see if there isn't some left
overs in the Grouping and Sorting that you need to remove.
--
KARL DEWEY
Build a little - Test a little

This is the query that was written and seemed to work when I 1st openned the
database. Do I need to delete the "Order by" line?
SELECT Projects.*
FROM Projects
WHERE (((Projects.Status)="Completed" Or (Projects.Status)="On Hold"))
ORDER BY Projects.Status DESC , Projects.Priority, Projects.[End Date] DESC;

Thanks.

That is usually a problem in your query that drives the reports. You have an
"orderby" where you need where, or max, min, last or one of the other
functions. Or you can't have order by for category in the query.

:

I'm utilizing a pre-designed template "Marketing Project Management Database"
and am experience a problem running some of the reports. Receiving the
message "the multi valued field 'Category' cannot be used in ORDER BY clause".

What do I need to do to correct the problem? I able to open all tables,
forms & queries without a problem.

Thanks.

 

[Gina Whipp]

Twila,

Try checking the OrderBy for the report...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I've tried deleting the "Order by" line in the query, but still receive
the
same message when trying to open the report. Any Suggestions????

Thanks.

This is the query that was written and seemed to work when I 1st openned
the
database. Do I need to delete the "Order by" line?
SELECT Projects.*
FROM Projects
WHERE (((Projects.Status)="Completed" Or (Projects.Status)="On Hold"))
ORDER BY Projects.Status DESC , Projects.Priority, Projects.[End Date]
DESC;

Thanks.

That is usually a problem in your query that drives the reports. You
have an
"orderby" where you need where, or max, min, last or one of the other
functions. Or you can't have order by for category in the query.

:

I'm utilizing a pre-designed template "Marketing Project Management
Database"
and am experience a problem running some of the reports. Receiving
the
message "the multi valued field 'Category' cannot be used in ORDER BY
clause".

What do I need to do to correct the problem? I able to open all
tables,
forms & queries without a problem.

Thanks.

 

[Twila]

Thanks everyone. I believe we have figured it out. Appreciate your
assistance.

Twila,

Try checking the OrderBy for the report...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I've tried deleting the "Order by" line in the query, but still receive
the
same message when trying to open the report. Any Suggestions????

Thanks.

This is the query that was written and seemed to work when I 1st openned
the
database. Do I need to delete the "Order by" line?
SELECT Projects.*
FROM Projects
WHERE (((Projects.Status)="Completed" Or (Projects.Status)="On Hold"))
ORDER BY Projects.Status DESC , Projects.Priority, Projects.[End Date]
DESC;

Thanks.


:

That is usually a problem in your query that drives the reports. You
have an
"orderby" where you need where, or max, min, last or one of the other
functions. Or you can't have order by for category in the query.

:

I'm utilizing a pre-designed template "Marketing Project Management
Database"
and am experience a problem running some of the reports. Receiving
the
message "the multi valued field 'Category' cannot be used in ORDER BY
clause".

What do I need to do to correct the problem? I able to open all
tables,
forms & queries without a problem.

Thanks.