My report uses a query with the DatePart function that sorts by day of week.
The report does not obey the sort order sent by the query. I would like to
sort my report by the day of week in ascending order such as:
1/1/1990

Help!  I just installed an 2003 database on a new network and whenever I try
to open a report I get the above error.  How can I stop it?

I would first like to say that this is my first post to this invaluable
group. Kudos to all who are involved here.
I am using Access 2002 and am having trouble with a report which is
based on a crosstab query which is based on an aggregate query. This

Dear Professionals:
I have several reports which I filter with a query on dates that I print
each Friday. We will not necessarily have entries on each report daily. In
fact, some report will contain for example, entries on Mon. 2/14, Tue. 2/15,

How do i use code to seet format properties like for
number , e.g, 0.000, or 0000 or 00.00  depending upon the
value of the field
thanks

Hi there, I am working on an invoice that was displaying my information built
on a select query with all the general stuff- PO#, ship dates,etc. When I
saved and closed it, then reopened it, the information no longer appears in
the report. I checked the record source and it is ...

I am working on an invoice based on a report that has al the general stuff in
it: PO#, etc. The report is based on a select query from my inventory,
purchase Order, Employee, shipping, etc. tables. The query has a parameter in
the PO# field so that I can pull them up by PO#. The ...

I have a report based on a query prompting for a start and end date.
Is is possible to have those dates appear in the report header?

I have Feilds that are coming from a a table into a report (F1,F2,F3,F4). How
can I merge them to make one feild with a Comma seperating them. Thanks

How can i check if a report is opened? I use visible property , if it is
opened it returns -1, but if it is closed it returns #Name? and i can't use
IIf function.

I am creating a mailing report and would like to ignore address fields if
they are blank.  I have tried the 'can shrink' which does work if the text
boxes aren't touching each other, but the gap above and below the shrunken
text box are still there so the address still has a ...

I have a calculated control in the detail section of a report. The
calculation is
=[txtDomfacsoleqtr]-(DLookUp("[txtDomfacsoleqtr]","tblmaintabs","[txtMonthla
bel]= [txtqtr1]"))

What kind of expression do I have to write down in a text box control source
to make a selection of records from a table field?
I can not use the "Record source" as it is allready occupied by another query.
Thanks in advance

I'm creating a report that is basically a listing of all of the Old Time
Radio programs I have of a certain series. The basic report is working
fine, but I'm getting fancy and that's where I'm getting over my head.
Each episode has a number and they are sorted in ascending order. ...

I am trying to calculate a count of records on my report that have a
specific RoleID and were enrolled by a specific date.  I am able to
count the records with a specific RoleID with the following in a text
box: