I have a table where each family member is in a separate record (imported
from another program that has it that way). There is a fldFamilyIDNumber
field. Each record has a fldFamilyPosition field, i.e., head, spouse, child.
I need to make a name tag that gets the dad's name ...

Does any one have any ideas how I can get data from access to a word document
that can be linked, so that if the source data canges the word document is
updated as well.
The database containes transaction for a general leger and the word document

Am using the expression:
=Switch((Sum([Raw]*24))>=40,"super",(Sum([Raw]*24))>=24 And
(Sum([Raw]*24))<=39,"PLUS",(Sum([Raw]*24))>=0 And (Sum([Raw]*24))<24,"NONE")
This results in (Example)

I have a report with a open date and a due date, the difference is 7 days
between these two dates.  I need to show an over due date after the 7th day.  
How can I do this?
Thank you

I'm trying to build a table of available reports. I've been able to build the
table with report names pretty easily, but I can't seem to get the
"description" property from the AllReports collection. The description is
entered by right-clicking on the report name and clicking ...

I am printing tags for items we sell. Most of the fields have the vertical
format set to Yes in the Other section of the properties sheet. When I
print, the vertical text seems to be printing in some system default font.
When I try to change the font, weight, etc, it doesn't change ...

I run I have Access 2000 (Norwegian version) and Access 2003 (English
version) on a Norwegian verion of WinXP sp2. I'm not able to create nor run
reports from my 2003 installation.
I would appreciate if somebody could explain why, and, then, how to fix the

I have a report that has numerous totals and everything works fine except one
total needs to reset each time the member changes - I know it sound simple -
but the report has lots of running totals
MemberIDHeader - Nothing

I have a form (TrailsDetail) that has a calculated control (TimeCalc). I
built a report (Trails) and would like to use the Dlookup function to grab
TimeCalc from the form TrailsDetail.  Both share a common numeric key
(TrailID).   For the life of me I can not get this to work:

Am using the following in reports to identify various categories, based upon
an accumulated total:
=Switch((-Sum([Raw]*24))>="40","super",(-Sum([Raw]*24))>="24" And
(-Sum([Raw]*24))<="39","PLUS",(-Sum([Raw]*24))<"24","NONE")

I'm trying to display an Access 2000 report total on the same page as the
list of numbers being totalled. But Access is not allowing me to do this,
insisting instead on displaying the total on the following page, along with
where I have a chart. This is despite there being plenty of ...

I need to run a report that is bound to a table where some fields have
several different values.  I need to put controls in the report that would
give me a total for each different value (eg. =count([ques], "doctor"))  or
"nurse" or "assistant".  Can this be done without a query?

When I run a report with the printer not attached or offline I need to
get an error message so that I can redirect thatprinter elsewhere.
Right now when I run the Print Report from a command button, othing
happens.  Is there a way around this?  How can I get it to go to another

I find it hard to believe that we don't have a way to check the status
of a printer in Access before we send the report there.  Shouldn't this
be easy to do in Access?  It's kind of like checking that the elevator
is in the shaft before stepping in!!!!!  There has got to be a ...

??
I'm using ACCESS program. It provides me MAX, MIN, AVG,... but not Median
function..??
How to get Median from ACCESS?