help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

iI have a problem with an program made in access 2003, (i am a beginner) i
have a form where i enter a period (01/10/06 10/10/06 for ex.) and then i
launch a report from this form using a command button (use a query for the
report) but i can’t sort the data with the period enter by me. What can i do?
I already try to sort the query , the data used by report but doesn’t work.
sorry for my english
 
Pufy:
Please understand that I am no access guru but I think I might be able to
help or point you in the right direction.

Before you try any of this it would be wize to make a copy of the report and
querry...just in case things don't go well.

First, I assume your report is basd on the querry and the querry's criteria
(date range) is being provided by the form. If you can open the querry in
design view and set the sorting in the query by example grid. Save the
querry and run the report to see if this has the desired affect you are
looking for.

If it doesn't then try opening the report in design view. Clcik on the View
menu and then choose Sorting and Grouping. Look at the fields listed here
and see how they are sorted. If need be you can move on of the fields up on
the list by clicking on the grey box to the left of the field name and
draging it up the list. The report will sort on the items at the top of the
list first and then work its way down the list.

Hope this helps,
FatMan
 
Back
Top