I have two columns and don't what to print them if they both = 0.  need some
help?

I have a form that I use (in new-entry mode) to enter
data into a table.  The form is opened by a new-entry
button in a switchboard.
Is it possible to have the last (from the table) value

I am trying to create a report that groups events biannually.  Thus all
events in the current and last year would appear in the first group, 2 and 3
years ago in the 2nd group, etc.  I used sort/group on the date field using
the year and set the interval at 2, but the report came ...

Office 2000 or 2003. When printing labels, the bottom row of the label stock
is always blank. I'm not missing any data, it just skips over the last row.  
This happens in two different DBs with different size labels.  I used the
Wizard to create the report.

(This is a more detailed version of a question I posted a few days ago.)
Sorry, but I'm VERY new to Access.  I have the RTF control that someone
directed me to, from http://www.lebans.com/richtext.htm#RTF2 - but I
have no idea how to actually use it!  As far as I could tell, the

Office 2003.  I have a simple mailing list database in Access.  Only some of
the records have a title or a company.  How do I include a line on a label or
report if the title or company field contains data or skip the line without
leaving it blank if there is no data in the ...

I have a report that has been working fine.  VBA code sets the RecordSource
conditionally as follows:
Me.RecordSource = _
SELECT [tbl_Accounts].* FROM [tbl_Accounts] ORDER BY [AccountNo]

I'm using Access 2003. I have a report that reflects our account
receivables. The query is pulled from a large database with fields
that are populated by a DOS based system. I have a report that looks
like this:

I have a command button on my form (''Print10a''). I want
to be able to click this button and print the report
(''10aConfirmation'') twice but only for the current
record. My whole database is defined by the selected date

I wonder if anyone can help me out with a BIG problem I have
I have a database running on Access 2000 and within it I have a report set
up that produces product picking notes.  At the moment it needs to print off
285 of these picking notes and yet whenever I send the report to the ...

-- Hi
I am trying to print a directory with Access 2000 in book form. I am doing
this in landscape with each family using one half sheet (so there will be 4
families total on front and back of page). I want to fold and staple all the

Re: Patient x-ray information system
Upon booking in a patient in my application, any number of different labels
need be printed (Ie one for film packet, another for the film camera ID
etc).

Company trip form has a place that lets you put in how
many bags the employee is taking.
I've made a report to print luggage labels, but I would
like to encorporate the # bags. For example if Jane Doe

Greetings,  I am trying to get the following expression to work and it
currently does not.  Here is my logic:  I have a report called invoice that
I want to say ie: "1 Night Stay in Cousin Amy at $149 per night beginning
7/20/04" if a 1 night stay and "5 Nights Stay in Cousin Amy at ...

I have a command button that prints a report when clicked
and has the following code;
Private Sub Print10a_Click()
On Error GoTo Err_Print10a_Click