How do you join multiple Select Statements? Here is my example
How do you join multiple Select Statements, here is what I would like to join;
SELECT Count(SCD.Status) AS [# Actions Returned]
FROM SCD

I need to direct Access 07 to start printing with a certain label on the
sheet.  I have reviewed the thread "choose label to start printing" on this
site, which gives the following instructions that were helpful to the person
that asked the question:

I am having a brain freeze, I need a sum of a field where a name = Carla
could someone please assist?
=Sum [SCD the table] [Assigned fieldname] = Carla
Thanks

I did som research to the prior post, I am using this
=Sum(IIf([Assigned]= "Carla",1,0)
I have this in a text box, but is repeating itself for 12 - 13 pages with a
total count of 453 posts. Is there a way to limit it to one entry?

My report heading contains a text box with the following data source:
="Transactions since " & Forms!frmPrintTran!txtDate
The on-screen preview shows the date fine, but on printing, this textbox
displays #Name?

I have a report that has worked fine for years on my system.
The query is based on one yes/no check mark on about 10 records every
quarter but now it has 50 records.
To much to change by hand.

I have an access database that now needs to deal with multi currency. Using
code, I have just changed the format on all text boxes in forms from Euro to
Standard.
I could do the same on reports, but it would be better if the currency

I'm opening a report. I turn hourglass on directly before and off directly
after. I have a msgbox in the report open event.
I get the hourglass and a message 'opening report'. The report never prints
and the hourglass never goes away. Have to terminate Access to get out. The

I have an existing database that employs checkboxes.  I'd like to create a
report that displays those boxes as "yes/no" text values, so that I can
export them to an .rtf format, and have them actually show up.
I'm a novice, so any help is greatly appreciated.

I have a report with a a few subreports.  One sub report has the total fees
for an Exhibitor My problem is with in the Report Footer section the grand
totals display correctly but when the report is printed to a printer, the
grand total section is not correct.  Below is what I ...

I am using Access 2007 and I have created a report, and I would like to have
a command button that would
open a print dialog so that the user can choose to print the report to any
printer they should choose, including a PDF.

Once again I begin what seems like a simple project and reality hits me with
a two by four on the back of the head.
THE ISSUE:
Continuous form, custom product and serial number label for our products

I have read many of help topics on this same exact subject. I am new to
access, and self taught.
I am using Access 2003.
Here is what I have. I have a Form DB with all of Clients. The form is based

I have a report running from a parameter query where a start and end date are
entered and then the report opens within those dates.  I want the report name
to look something like this...
Jobs Worked from ________ to _________.  

I use IIf([ReserveDate] Is Null,Null,([ReserveDate] & " & " &
[ReserveDateTo])) to display ReserveDate & ReserveDateTo if ReserveDate is
Null. It works fine.
However, when ReserveDate has value, it displayed with &.