I have a form to locate parts.  I also have a subform linked to a different
table to track when and how many parts were taken out of inventory.  I want
the operator to fill in the date in the main form ( because I'm using that
somewhere else also), but I want that date to populate ...

I have a form called ticketbook.  I have a command button on this form that I
would essentially like to print a report and update a two fields in my table
at the same time.  The report  is based on a query which has three
parameters.  They are called sent date, issue date, and dt ...

I have a form called ticketbook.  I have a command button on this form that I
would essentially like to print a report and update a two fields in my table
at the same time.  The report  is based on a query which has three
parameters.  They are called sent date, issue date, and dt ...

I have a form that requests a startdate and enddate for the transactions to
be reported. In Print Preview, these two variables appear on the report
header, but disappear when the report actually prints. Any help would be
greatly appreciated.

I want to make a report based from a query.  The problem I keep running into
is the information in the query comes from three different tables linked by a
primary foreign key relationship.  When I run the query I am getting
duplicate information because there is more than one ...

I want to add a group footer to my report. Right now I have a page footer,
but I want something to print at the end of each group on the report. So I
believe I need to add a group footer and then add the fields in it. right?
please help. Thanks

I want to convert a field, in a record, with zero value to a null value:
opposite of nz?
also when using a calculation such as avg=([x]) the null field should not be
used

Hi there, I really hope you can help me!
I have a database that has a bunch of names and dates, names of tenants,
dates that they moved in, and moved out, and then some other stuff.
I have produced a report that only has the names of tenants that were with

Within one group I have, let's say, a return that starts with "A" and "B and
"C".
if the value starts with "A" I want to sort by field [x] if it starts with
"B" sort by field [y]... etc.

Hi there everyone
Im trying to produce a graph based on the following set of data:
when    value
10:00:00    17

I have setup some labels to print and no matter what I do, a blank label
prints between each label. (Access 2003)
Each time I go to print I get the message I am grown to hate:  The section
width is greater than the page width. I don't understand how there can be

I have a report in which a given field will have data only rarely. Can I
suppress display of the label & field for that data in the event the field is
null, i.e. show the data only when there is data to show?
Appreciate your help.

I need to print a telephone directly, two pages to a 8.5"x11" sheet of paper.
How do I print it in Access XP?

We are working with a training module and need to print various
instructor signatures (currently .jpg format) onto a certificate
(Access report).  Data is stored in SQL2000, the vw used works great
but shows a file name on the certificates instead of the

Hi. My name is Charlie Simmons. I watched The Price Is Right since I was
baby. I just like to welcome Drew Carey to the Heartland. I watched his
shows ever since he became a actor. he is funny man and he will make the
next 35 years successful.    Welcome home Drew.