i wish to show date in report as "JUL" instead of "Jul"
i can only do it by converting date to string first and report with ">"
format type.
is there another simple way to do it?

i have a report that lists duplicative records. at the end
of report, i'd like to add the total number of "UNIQUE"
or "Distinctive" records as well as the total number of
records.

I have created report in ms access 2000. It has two sub reports.
I am able to view the data in that report (Preview mode)
The issue is whenever I send this report to a printer it wont + most of the
time the printer get wiped!!!!!!!!!

Please can someone help with my report:
I have a report listing desk usage on our site and who is at whatever desk
in whatever room and whatever building.
If there is an unoccupied desk the table field 'surname' contains the word

I have the following tables/fields relevant to the query I’m after:
Screened.site
Recruitment.DateOfReferral
all I want to do is design a query and subsequent report which shows the

Hi Folks - I have a database that tracks criminal cases. For each case,
there can be multiple charges. Also, for each case, there could be the same
charge for many counts. So, the data would look something like this:
Count          Charge

I have a report that is grouped by Artist's Name and I need to get the Total
Amount Paid to each Artist. I have tried adding a text box (unbound) and
having the controlsource set to =SUM([Amount to Artist]) and I've put it in
the GRoup Footer, but it's not working. Does anyone ...

I'm strong in Excel & Word, but a newbie in Access.  I think Access might be
able to do this easily, but need advice.  I \Our company currently prepares
letters of quotation for machinery we build.  We cnfigure these machines in
a variety of ways, different horsepower nototr, ...

I downloaded the "Issues" database template and modified it pretty heavily.
One of the fields is a lookup type of field.  In a canned report, this field
displays fine when I place it in my detail section or my section header.  If
I try to use it in an unbound text box, I get an ...

I use the print button for a report and select the # of copies to something
other than 1.  The report is always being printed as 1 copy only.
Any reason why?

In order to give the users the option to change some properties of the report
on runtime (like the fontweigth and size). If created a table with all the
needed values loaded.
My problem is I can't figure out how to load these properties at runtime.

I have Access2007 and I have developed a report with some fields,
pictureobjects and a small 'Microsoft Graph Chart' object down in the right
corner.
This Graph object handles its own data and are not dependent of the report.

I have an application in which I have re-designed the query which is the
record source of a report.  The query has exactly the same fields as before,
and it returns about 10 records from the existing data.  However, the report
will no longer open; instead I get error 3021 "No ...

I want to insert a picture into a group header section. However, not all
groups will have a picture associated with them. To populate the picture, I
have an unbound object in the report, then on formatting, I load it from a
file (this is because I have the binary info in the ...

I am trying to select a specific label printer for a report in Access 2007.  
In Page Setup, I can pick the printer, but then the info doesn't stay put
after I leave the dialog box and preview the report.  What's happening?  It
worked in previous versions.  Anyone have a fix?