Sarah,
It typically helps us older/mature members if you include enough of the previous messages to at least jog our failing memory.
If Numeric:
=DLookUp("FieldName","TableName","[TextField] = '" & [StringValue] & "'")
If text/string that might contain an apostrophe like O'Brien:
=DLookUp("FieldName","TableName","[TextField] = """ & [StringValue] & """")
If Date:
=DLookUp("FieldName","TableName","[DateField] = #" & [DateValue] & "#")
You may need to copy and paste the above into Word or some place that you can enlarge and change the font to fixed space.
To: MS_Access_Professionals@yahoogroups.com
From: sarahk@schemesoftware.com
Date: Thu, 1 May 2014 08:52:11 -0700
Subject: RE: [MS_AccessPros] Dlookup in (sub)Report
Duane, Thank you!! Your syntax made it work. I am totally confused on how to use the &,",# etc symbols. I dont know when and how to use it and find it very confusing.
Thanks again.
Sarah
It typically helps us older/mature members if you include enough of the previous messages to at least jog our failing memory.
If Numeric:
=DLookUp("FieldName","TableName","[NumericField]= " & [NumberValue])
If text/string that will never contain an apostrophe like O'Brien:=DLookUp("FieldName","TableName","[TextField] = '" & [StringValue] & "'")
If text/string that might contain an apostrophe like O'Brien:
=DLookUp("FieldName","TableName","[TextField] = """ & [StringValue] & """")
If Date:
=DLookUp("FieldName","TableName","[DateField] = #" & [DateValue] & "#")
You may need to copy and paste the above into Word or some place that you can enlarge and change the font to fixed space.
To: MS_Access_Professionals@yahoogroups.com
From: sarahk@schemesoftware.com
Date: Thu, 1 May 2014 08:52:11 -0700
Subject: RE: [MS_AccessPros] Dlookup in (sub)Report
Duane, Thank you!! Your syntax made it work. I am totally confused on how to use the &,",# etc symbols. I dont know when and how to use it and find it very confusing.
Thanks again.
Sarah
__._,_.___
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
Now you can search Photos & Files in your Group !
You can now search not only your archive of conversations, but also photos and files stored in your Yahoo Group. Give it a try!
.
__,_._,___
Tidak ada komentar:
Posting Komentar