how print a range of labels?

  • Thread starter Thread starter Geoff Cox
  • Start date Start date
G

Geoff Cox

Hello,

Cannot see how to print a range of labels rather than the whole lot?

Can I use the ID value in the criteria box in a query?

Appreciate any thoughts?

Thanks

Geoff
 
You can filter the record source of the report like you would add a criteria
to any query. Do you need information on how to do this?
 
You can filter the record source of the report like you would add a criteria
to any query. Do you need information on how to do this?
Click to expand...

Duane,

Certainly do - have tried and failed ! Also I notice that when going
to "print" with a labels report, to the From and To options, the To
box is greyed out so presumably you do not have the option here to
select say a range of labels?

Cheers

Geoff
 
To filter a query, I recommend using controls on a form. For instance if you
have a field [Dept] and you want to limit your report to the Department
selected in a combo box [cboDept] on a form [frmRptSelect] then you would
set the criteria in the query under the [Dept] field to:
Forms!frmRptSelect!cboDept
To find out how to begin printing labels in the middle of a sheet, search
google groups for "fredg labels report" or something similar.
 
To filter a query, I recommend using controls on a form. For instance if you
have a field [Dept] and you want to limit your report to the Department
selected in a combo box [cboDept] on a form [frmRptSelect] then you would
set the criteria in the query under the [Dept] field to:
Forms!frmRptSelect!cboDept
To find out how to begin printing labels in the middle of a sheet, search
google groups for "fredg labels report" or something similar.
Click to expand...

Duane,

Thanks for this but is it possible to enter a criterion in the query
criteria box, in design view, for the ID? I would like to have
something like

ID = 1-20

so that the first 20 labels are printed, or even

ID = 20-30 etc.

I know the above do not work but can this be done?

Cheers

Geoff
 
To filter a query, I recommend using controls on a form. For instance if you
have a field [Dept] and you want to limit your report to the Department
selected in a combo box [cboDept] on a form [frmRptSelect] then you would
set the criteria in the query under the [Dept] field to:
Forms!frmRptSelect!cboDept
To find out how to begin printing labels in the middle of a sheet, search
google groups for "fredg labels report" or something similar.
Click to expand...


Duane,

I thnink I have been missing the blindingly obvious !!

"<21" in the ID criteria box in query design view !

Cheers

Geoff
 
You should try not to enter hard-coded values into queries. At the very
least, try
<[Enter Maximum Number]

--
Duane Hookom
MS Access MVP


Geoff Cox said:
To filter a query, I recommend using controls on a form. For instance if you
have a field [Dept] and you want to limit your report to the Department
selected in a combo box [cboDept] on a form [frmRptSelect] then you would
set the criteria in the query under the [Dept] field to:
Forms!frmRptSelect!cboDept
To find out how to begin printing labels in the middle of a sheet, search
google groups for "fredg labels report" or something similar.
Click to expand...


Duane,

I thnink I have been missing the blindingly obvious !!

"<21" in the ID criteria box in query design view !

Cheers

Geoff
Click to expand...
 
You should try not to enter hard-coded values into queries. At the very
least, try
<[Enter Maximum Number]
Click to expand...

Duane,

I see what you mean but this data base is for my use only ...

Cheers

Geoff
 
Back
Top