I have a command button called TodaysReport and an unbound textbox called
txtDate whos defauld value is set to Date(). I need the on click event
property of the button to filter the report only for the records whos dates
are the same as that in the textbox. The name of field in the ...

I have a crosstab query that displays totals for each month. How do I convert
the month numbers to their actual name on my report? I used the monthName
function but it displays them in alphabetical order instead of chronilogical
order. Do I define this in my query or do I need to do ...

how can i add the result of a query that my report is not based on into the
report header

I use Access 2007 to store the data of a dictionary. Now, when it comes
to print it out, I wonder if the following task can be done from within
Access:
First, I want to explain the structure of my dictionary: The entries in

A very minor bug really, but it's really annoying me. Can anyone tell me what
can be done to stop the select pparametre message coming up every time the
report starts? Obiously, I've had this before, but I can't find anyway round
it this time. Some sort of code would proberly do it. ...

I'm creating a report (about to go on a holiday so it must be done quick)
and need to group my data. The query has a datefield on which I would like to
group by.
In the groupheader I would like to present the datefield grouped by year.

I have a form with 2 option buttons. Each option button has a combobox
associated with it. One option will allow report to run based on client
selection, the other will run same report by a date. I have a command button
to run the report. The code for this command button checks ...

Am sure there must be an easy way to do this and I'm completely missing it!  
I've just worked out how to set up option groups on a form to populate a
field on a table.  So they just click either yes or no.   I  need to put the
Yes or No fields on a report in two columns with ...

When printing out a report, how can fields that are empty not be displayed so
you don't have blank spaces on the report

I have a massive database that I inherited from someone who is no longer with
the company and need to produce some reports.  
My problem right now is figuring out which tables have the fields I need.  
If I could get a list of all the tables and the fields each contains I could

I have a memo field in a data entry form, which is extracted by query to a
report.  The problem I have is that not all of the data appears in the
report.  It is set to "can grow", but the area assigned in the report has
plenty of room for the contents of the memo field.

I am trying to change the color of the font on an entire line of a report if
one field meets certain criteria.  When I insert the conditional formating
[EFFECTIVE] > 12/31/2005, it returns #name? in the field when you review the
report.  I have tried every possible format for the ...

I have a report which is run from a button on a form.
The report contains a subreport which has a calcualted field displaying a
total of all items on the subreport.
I have created a macro and attached it to the On Format property of the

I have a report with section page header and page footer, I need that the
page footer appear only at the first page of pages.
Help please!!

With a list of labels - 2 columns per page, I would like the report head &
footer to span the entire page - centered .  So if I have two columns of 3.5"
each I want the header/footer to be centered on an 8"page.  I'm pretty sure
this can be done, but when I try to make the ...