I have a report that pulls the date from a table using a short date. I would
like to see only month and year. Can someone help?

I have a main report that needs to add a field from a sub report. I keep
getting #error.
This is what I have on the Main Report to test for errors:
=(NZ([Blank Weekly subreport].Report!SUMOTRA))

I have several different forms which contain different variables from one
table.  I need to create reports from each form.  Is there an easy way to get
only the variables from a form into a report, or is there a way to get a list
of the variables used in a form.

I have a report which works as a letter to an individual inviting them to
training.  I have a page break at the end of the standard text.  Our company
name and contact details sit in a text box in the page footer and a map to
our training location in the report footer.  

How to inport Access report in Word document as it is (with all headers,
data, colors, etc.)?

I am trying to run a report with a filter on the data using the property
window.  The data is coming from a query named PCI.
The Record Source SQL is: SELECT PCI.FIELD_TEAM, PCI.[Net Merch],
PCI.[PCI/STI] FROM PCI;

Hello.  I am hoping someone out there can help me.  I track homicide
data and run reports for police administrators when they request it.  I
have data from 2005 and 2006.  I want to be able to give them the count
of homicides by district to-date.  So, today's report would give a

I am trying to turn a letter into an Access report because some of the
records in the query are near-duplicates except for two pieces of data in
each one, which need to print as a list.  The only problem is that in the
text of the letter, there is some text (the name of the show) ...

I'm using Microsoft Access Professional 2003 at my business and any time I
try to create a report or open a database that generates a report.  It says
"There was a problem generating this form or report".  That is the only
message I get and it just doesn't work.

When I go to view my report it prompts me for the parameter value of 'Freq'
which is one of my field names.  I have double checked it is pointing the
right place in the queries, tables etc and when the report shows it has the
appropriate information in it.  How do I stop it ...

I have in my Access database a field that shows multiple values per record.
For example, AAAA~BBBB~CCCC~DDDD. In a good database, AAAA, BBBB, CCCC and
DDDD would be placed as different records. However, the data that I got, they
are placed together, as one record separated by "~" ...

I have  Dlookup-function in report which lookups the price of a product based
on customerID and productID. This works fine as far as it consers product
details. But this report is an invoice which should have a total sum also. In
report I can't refer to the name of a calculated ...

Thought this would be easy...
A report is based off a table:  tblServer
There is another table:  tblServerIPS, which stores the IPAddresses of each
server (1 to many).

I have a report created from Excel to record employee’s time. I am new to
writing SQL so I need some assistance in creating this, if this is the
solution. I have a query for each employee’s time worked for the week, the
report needs to display the employees time for the week, but ...

I have a form that "filters" a report.
It works fine but now I would like to have a message pop up anytime the
criteria entered has no results.  Right now I get a report with no data.
How to I capture the amount of records using VB?