Hello all you friendly people.
I need to create a report that enables the users to select the fields they
want to see from a form. Problem is i don't want to just hide/unhide the
selected fields as this would create empty spaces in between selected fields.

Hey all, thanks for listening.
My brain teaser is that I need to show a date when I print a Cheque.
The issue is the bank has 8 spots on the CQ ... D  D  M  M  Y  Y  Y  Y
There can be no slashes or dashes.... 9 point font... and no

I've searched & searched the archives, but no cigar!  Your help would be
appreciated.
(I have very quickly found out how to put the database name in a text box!)
Thank you.

Is there some way to display the Report Name in a footer (without Hard
coding the actual name, of course)?
Thanks,
Bernie

In the report footer I inserted =Count([OrderID]). Instead of getting total
orders, I am getting the total of line items for those orders. The OrderID is
in a group named OrderID. I would appreciate it if someone would give me some
direction.

I have a report that uses a parameter query.  The reports lists ProjectName,
ProjectType and FiscalYear with the parameter being FiscalYear.  I want to
add a pie chart to this report in the report footer that shows the various
ProjectTypes as a pecentange of all ProjectTypes in a ...

I have a report that gets data from a select query.  There are three columns
of dates.  Some columns do not have any dates for some of the rows and some
of the rows only have one date in the column.  How do I filter out the rows
that do not have any columns with dates?  Note: my ...

I am trying to use the OutputTo macro to save my reports in snapshot, which
is working fine.
Each report is for indivisual employees so I want to be able to have it save
reports as "employees name" & "report name" automatically.

I am using the Microsoft Date and Time Picker Control 6.0 (SP4) with MS
Access 2002 (SP2) and it is not working. I am using the below code which
works fine until I replace the txtDate textbox with the date picker named
DTPicker9. Then, the On No Data event fires in the report. ...

We have a database in our office that contains multiple tables, which are
linked in various fashions.
A report has been generated which includes a person's name, which department
they are employed by, and their start date (this information is being pulled

I have the following code but I am doing something wrong with the "if
me.fitler" part of the statemenet since it always comes up with the label New
Activities Report even when it is an Internal Reference.  What is wrong with
the syntax?

I would like for my report to calculate the totals for each column based on
the date range parameters entered, but instead I'm getting the cumlative
total for each column.  I've set up similar reports in the past, but I can't
remember what I did to make it work.  The formula that ...

I have a textbox which contains the month and year.
It calculates as =Format$([soldmonth];"mmmm aaaa";0;0)
I´d like to obtain this information, august 2006 and convert it in another
textbox, in something else, another language.

Is it possible to link (rather than import) an Outlook calendar to a table
in Acces?
I am using the the 2007 Beta and whilst I have been able to link to a
calendar file, it only shows email fields rather than calendar fields.

Print margins are all 0.5". Report width is 9". Print options are set at
Landscape, and the diagram shows the report in landscape mode. But in Desugn
View the green still shows in the corner of the report control and the
information given is that report width is greater than page ...