Help with Sorting

  • Thread starter Thread starter Justin
  • Start date Start date
J

Justin

I am completly lost with this sorting issue. I have a
table named time sheet along with a form for data entry.
I built a query to calculate time in and time out
diffrence. I need to sort the field called Nurses Name in
Acending order. I select it from the sorting pull down
menu in the query and I made sure that the item show was
selected. I then created a form based on the query and
also selected Acending order for Nurses Name. The problem
is that when I enter a new entry in the form and then run
the query its not in order. When I sort it in the dynaset
of the query it works then I save it but when I go to the
report to run it its not updating it tells me the nurses
name feild can not be found. I have retried over and
over. I can not get it to work. Please someone help.
Thanks in advance!!

Justin
 
The problem
is that when I enter a new entry in the form and then run
the query its not in order. When I sort it in the dynaset
of the query it works then I save it but when I go to the
report to run it its not updating it tells me the nurses
name feild can not be found.
Click to expand...

Two problems here:

- One, you don't need to "run" the query AT ALL. The form and the
Report would be based on Queries (the same query or a different query,
it doesn't matter).

- You're apparently assuming that specifying a sort order on the Form
affects the sorting of the report. It doesn't; they're completely
independent. A Table *has no order* - if you want to see data in a
particular sequence you need to be looking at a query with a sort
specified, or at a Form or Report with a specified sort order.

To sort data on a Report, be sure that the field that you're using for
the sort is included in the Report's Recordsource query, and use the
Report's Sorting and Grouping dialog to specify the sort order. Right
mouseclick the little square at the upper left in design view and
choose Sorting and Grouping.
 
Back
Top