Query Advise please

D

Dermot

I have a table of contacts with a field for cards.

I want to use a query to produce a report that will print labels for all the
contacts that have "YES" in the Card Field.

How do I set the query criteria to list only the contacts that have "Yes"
entered in the "Card" field.

Please suggest alternative methods to printing a selection of labels
 
D

Douglas J. Steele

Is the Card Fields a Yes/No field, or is it a text field?

If it's a Yes/No field, put True as the Criteria under that field in your
query. If it's text, put "Yes" as the criteria.
 
J

Jeff Boyce

Dermot

Create a new query. Select your table. Select the field(s) you wish to
print on the labels.

Select the [Card] field. In the criterion row under the [Card] field, enter
the value you want selected. If your [Card] field is a Yes/No data type,
you may want to use "0" (False, No) or "Not 0" (True, Yes), depending on
where your data is stored (Access, SQL Server, etc.) as your selection
criterion.
 
D

Dermot

Hi Jeff,
Thanks for the information,
Much appreciated
Regards
Dermot

Jeff Boyce said:
Dermot

Create a new query. Select your table. Select the field(s) you wish to
print on the labels.

Select the [Card] field. In the criterion row under the [Card] field, enter
the value you want selected. If your [Card] field is a Yes/No data type,
you may want to use "0" (False, No) or "Not 0" (True, Yes), depending on
where your data is stored (Access, SQL Server, etc.) as your selection
criterion.

--
Regards

Jeff Boyce
<Office/Access MVP>

Dermot said:
I have a table of contacts with a field for cards.

I want to use a query to produce a report that will print labels for all the
contacts that have "YES" in the Card Field.

How do I set the query criteria to list only the contacts that have "Yes"
entered in the "Card" field.

Please suggest alternative methods to printing a selection of labels
Click to expand...
Click to expand...
 
D

Dermot

Hi Jeff
I have my report and labels are fine Thanks.
Is there a way to modify the position of the text on each "individual label"
within the report?

I am using Labels W6.77 X H9.91 in size. This is a good size for me as some
addresses I have are very long. The smaller addresses could be positioned
better relative to the label size if you know what I mean.

Any suggestions would be appreciated

Jeff Boyce said:
Dermot

Create a new query. Select your table. Select the field(s) you wish to
print on the labels.

Select the [Card] field. In the criterion row under the [Card] field, enter
the value you want selected. If your [Card] field is a Yes/No data type,
you may want to use "0" (False, No) or "Not 0" (True, Yes), depending on
where your data is stored (Access, SQL Server, etc.) as your selection
criterion.

--
Regards

Jeff Boyce
<Office/Access MVP>

Dermot said:
I have a table of contacts with a field for cards.

I want to use a query to produce a report that will print labels for all the
contacts that have "YES" in the Card Field.

How do I set the query criteria to list only the contacts that have "Yes"
entered in the "Card" field.

Please suggest alternative methods to printing a selection of labels
Click to expand...
Click to expand...
 
J

Jeff Boyce

No idea how this relates to your original post...

Jeff Boyce
<Office/Access MVP>

Dermot said:
Hi Jeff
I have my report and labels are fine Thanks.
Is there a way to modify the position of the text on each "individual label"
within the report?

I am using Labels W6.77 X H9.91 in size. This is a good size for me as some
addresses I have are very long. The smaller addresses could be positioned
better relative to the label size if you know what I mean.

Any suggestions would be appreciated

Jeff Boyce said:
Dermot

Create a new query. Select your table. Select the field(s) you wish to
print on the labels.

Select the [Card] field. In the criterion row under the [Card] field, enter
the value you want selected. If your [Card] field is a Yes/No data type,
you may want to use "0" (False, No) or "Not 0" (True, Yes), depending on
where your data is stored (Access, SQL Server, etc.) as your selection
criterion.

--
Regards

Jeff Boyce
<Office/Access MVP>

Dermot said:
I have a table of contacts with a field for cards.

I want to use a query to produce a report that will print labels for
Click to expand...
all
the
contacts that have "YES" in the Card Field.

How do I set the query criteria to list only the contacts that have "Yes"
entered in the "Card" field.

Please suggest alternative methods to printing a selection of labels
Click to expand...
Click to expand...
Click to expand...
 
D

Dermot

Hi Douglas,
Is there a way to see the outline of a label in my label report. So I can
determine how the text is positioned on each label. It would appear to me
that once the label text position is set during the wizard, all labels are
the same.
Any suggestion how I could approach this problem
Thanks
Dermot
 
D

Dermot

I don't suppose it does....I should really post a fresh posting.
Sorry
Dermot

Jeff Boyce said:
No idea how this relates to your original post...

Jeff Boyce
<Office/Access MVP>

Dermot said:
Hi Jeff
I have my report and labels are fine Thanks.
Is there a way to modify the position of the text on each "individual label"
within the report?

I am using Labels W6.77 X H9.91 in size. This is a good size for me as some
addresses I have are very long. The smaller addresses could be positioned
better relative to the label size if you know what I mean.

Any suggestions would be appreciated

Jeff Boyce said:
Dermot

Create a new query. Select your table. Select the field(s) you wish to
print on the labels.

Select the [Card] field. In the criterion row under the [Card] field, enter
the value you want selected. If your [Card] field is a Yes/No data type,
you may want to use "0" (False, No) or "Not 0" (True, Yes), depending on
where your data is stored (Access, SQL Server, etc.) as your selection
criterion.

--
Regards

Jeff Boyce
<Office/Access MVP>

I have a table of contacts with a field for cards.

I want to use a query to produce a report that will print labels for all
the
contacts that have "YES" in the Card Field.

How do I set the query criteria to list only the contacts that have "Yes"
entered in the "Card" field.

Please suggest alternative methods to printing a selection of labels
Click to expand...
Click to expand...
Click to expand...
 
D

Dermot

Hi Douglas,
Just forget this las question.
It should really be in a fresh posting
Thanks
Dermot
 
Top