Query question

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

How do I set a constant value for a field name in a query?
E.g., I have a query containing "Suffix: FamiliesSuffix" taken
from table "Families". I have a situation wherein I need the
value of Suffix to be "False", no matter what is in FamiliesSuffix
as taken from table Families. I.e., "False" for all records.

Thanks,
Bill
 
hahaha! I think I tried just about every syntax I could think of
besides that one.
Thanks,
Bill
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query record in SQL 4
combo box 1
This record has been changed by another user since you started edi 4
Access Dcount (multiple criteria) 3
Requery a table in a combo box query 1
Query problem 4
VBA: How can I use a string variable as autofilter criteria? 4
Combo RowSource 2

Back
Top