Grouping record I need help NOW!!!!!

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

Guest

I have a time & billing databse. I have entered all my records. when I display the "Print Invoice: form all the records for both Time & expenses appear sorted under the "Project Name". As I do want them to e sorted my project name I first need them sorted by the "Project ID" the by the "Project Name". How do I do this so that when I preview the invoice I see the individual Project ID sorted by the Project Name
 
MrHmpstr

To control the sort order on your form, use the sorting within the query
that the form is based on. This may involve adjusting the left-to-right
order that the fields are included in the query, and then, if you are
using the query design window, entering Ascending or Descending as
applicable into the Sort row or the query design grid. When it comes to
output the data to a report, the procedure is different. Regardless of
any sorting in the query that the report is based on (which may be the
same query that feeds your form), you should use the Sorting & Grouping
facility (available from the View menu of the report design) to
determine the sort order of the data in the report.
 
Steve,

Could I email you a Screen Print of my problem with my record sorting. I thinik if I give you an example I could better explain my problem. I really want to thank you for you response
 
Mark,

I have had a look at the screen shots you sent. You have a subform on
the Print Invoice form, with the time worked. I understand that you
only want this to show the time worked for the project as shown on the
parent form, which is indeed the way a subform would normally be used.
It seems to me that the key to this will be in the settings of the
LinkMasterFields and LinkChildFields properties of the subform. Open
the Print Invoice form in design view, and look at the properties of the
subform. These properties will need to show the field that identifies
the Project.
 
Hi Steve,

I have taken your advise. but now i am getting the following message "The table <name> is already opened exclusively by another user, or it is already open through the user interface and cannot be manipulated programmatically. (Error 3008)". I have checked to see that on the tools menu I have the the default open mode to "shared". and that the option for that tables is set to the run permission setting to "users"., And I still get the same message. What do I do now

----- Steve Schapel wrote: ----

Mark

I have had a look at the screen shots you sent. You have a subform on
the Print Invoice form, with the time worked. I understand that you
only want this to show the time worked for the project as shown on the
parent form, which is indeed the way a subform would normally be used.
It seems to me that the key to this will be in the settings of the
LinkMasterFields and LinkChildFields properties of the subform. Open
the Print Invoice form in design view, and look at the properties of the
subform. These properties will need to show the field that identifies
the Project

--
Steve Schapel, Microsoft Access MV



Mr Hmpstr wrote
 
Mark,

When does this error occur?

Anyway, we are still pretty much shooting in the dark here. Can you
give me this information. Is the main form based on a table or a query?
If a table, please post back with a list of the fields in the table.
If a query, please post back with the SQL view of the query. Same for
the subform. And also, what is now entered in the LinkChildFields and
LinkMasterFields properties of the subform. Thanks.
 
Back
Top