Query question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bill - 05 Mar 2005 00:03 GMT

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

Reply to this Message

PC Datasheet - 05 Mar 2005 00:18 GMT

NameOfMyQueryField:"False"
will put false in every record.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
resource@pcdatasheet.com
www.pcdatasheet.com

> How do I set a constant value for a field name in a query?
> E.g., I have a query containing "Suffix: FamiliesSuffix" taken
[quoted text clipped - 4 lines]
> Thanks,
> Bill

Reply to this Message

Bill - 05 Mar 2005 00:26 GMT

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

> NameOfMyQueryField:"False"
> will put false in every record.
[quoted text clipped - 13 lines]
>> Thanks,
>> Bill

Reply to this Message