I have a query date long date field and an expression the formats the long
date to weekdays. I can't seem to create a report Iif statement that can see
the weekdays, no problem writing a statement that finds the long date.

When creating a report using the wizard, fields and their label are always
connected. It make it very difficult to make changes and customize the report.
How can I disconnect this "connection"???? Please help? It drives me crazy!

Does Access have an equivalent of the format painter found in Word and
Excel?  When designing reports I often find myself reformatting several text
boxes one at a time, and would like a faster way to do it.

Hmm.. I have a command button on a form have the following code: "DoCmd.
OpenReport "Hazards"".  When I press the button, instead of Opening the
report, it prints it!   I'm confused... any ideas?

I have an unbound commission rate textbox (field) in a report,where the
commission rate value is determined in the "On Format" event, depending on
the values in some of the record fields.  This commsion_rate field is then
used to calculate the commission amount textbox in the ...

I have a module that computes elapsed time for hours worked   DutyTime
In a report I show time on duty, time off duty, and hours worked
It looks like this
DutyIn                              DutyOut                                  

I have inherited a slow database.  I am going through all the suggestions
available in this community and elsewhere (splitting database etc), and need
to be able to show the users that these changes will speed up the system.  Is
there a way to add a timer to a form so that the ...

I have an "address" field in a report which
sometimes contains no data.
I have set the "can grow" & "can shrink"
properties to *yes* but all I get is a blank

Hi, and thanks for any help you can offer, I'm stumped. I'm working on a
quotation database. I need the ability to enter a quote and send it to
several people. I have the quote form established.
After entering the quote you click a button and a pop up form comes up. On

I have a database in Access 2007 that records details of sports clubs
and historical results.
Records start in 1929 to present date with a break for World War 2
I have reports showing League tables etc.

I need to count the number of values in a column that have been
recorded with the Yes/No tick box on the main form of my database
So far, I have tried
=DCount("*","[Table1]","[sleep risk]='true'")

I have looked at the examples for shading everyother row of a detail but I
would like every third detail to be shaded and have it restart each time a
new group header is displayed.
My report:

I need to know how to count the values in a column witihn a query.
I mean I have a column risk factor and 3 values in my table of H M L,
I would like to produce a query that counts all the H and allows me to
put that query dtright on to a table for emailing.

Hi Experts,
A2K and a main report (just to provide sequential page numbering) that holds
a few subreports.
I have put two hidden fields on each subreport named item_en & item_tr. I

We receive data from employers to print customized brochures for their
employees.  The employee packet can be anywhere from 2-4 pages.  The 1st page
could be info on medical benefits/premiums (based on job class - managers may
have higher premiums then technicians), 2nd page may ...