I have a report that list various files that are being worked.
Example:
OM Number     ProjectNumber
12345              43060

I recently began accessing a Access 2000 database from a different server.  
After the transition all reports with date grouping no longer work.  Nor does
the Format$ function work if you recreate the report using the report wizard.
The reports still work properly if accessed via ...

I'm using Access 2003 at a customer site. They have a Dymo label Writer and
on an previous PC this worked fine. They replaced the PC with a new Dell and
installed Access. I revreated the label but the spacing does not work now
and I think it is because on the old pc Access (prev ...

Not sure if this is correct forum
Am looking to be able to set up routine to allow me to send emails from data
held in Access Query - either through outlook or some other third party
program.

I have a report which prints sub-totals and grand-totals at the end of the
report. In the sub-totals I have to print a total which represents items that
are not listed in the report. I get this total by doing a join that puts the
total in every row in the sub totalled group.

my problem is:
   - section "DETAIL" with vertical lines, with "can grow" and "can shrink"
properties enabled (I need this).
   - I have a function to draw all vertical lines and it works fine but

I would like to combine 2 field into 1 with a return between the two.  I
tried the following data source but instead of a return so that the second
information begins on a new line I get a square symbol.  Can someone
enlighten me so as to achieve what I need to do.

In Access 2002, I'm writing a report based on a query
that hits
two linked MS Project Server 2003 SQL tables,
dbo_MSP_PROJECTS

I have a Count Q that I would like to show the Count on a report.
The Report is not feed by the Query.
Can I do this?
Would be a great help if I can. Thanks

I need to develop a custom sort order for a control called ContactType on a
subreport. I've read in posts that this must be defined on the report Sorting
and Grouping rather than in the underlying query. The expression I am using
is too long for the Sorting/Grouping dialog box. ...

I have two databases on a server shared between 10 users.  
On one computer, I cannot open any reports in one
database...the other database is fine.  If I double-click
on a report, nothing happens (no error, just nothing as if

Can somebody offer advice as to what is wrong with this?
=(Select Case [DatePart("m",Now())] case 10 "October" case
else "February" end select)
Thanks a lot!!!!

I am looking for an inventory template (Excel or Access) which has fields for
model, serial number, as well as what software was installed and when.

I'm currently working on a report that shows Name, Address and Years
but if the address isn't a valid address (entry in the table confirms
this!), this should show on the report in Bold.  I used Conditional
Formatting to do this.

Calculated totals on my report work properly as long as the subreport has a
value or a related record.  However when there are no values or no related
records in the subreport, I get a #ERROR.
How can I get the calculated total to treat no values or related records as