Re: [MS_AccessPros] Lookup code

 

Toukey-

Do you mean DLookup?

    If Not IsNull(DLookup("DOB", "Members", "DOB = #" & Me.dob & "#") Then

       .. possible duplicate date

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

SQL Queries for Mere Mortals 

http://www.viescas.com/ 

(Paris, France)

On Mar 9, 2014, at 3:28 AM, toukey1 <no_reply@yahoogroups.com> wrote:

Hi,

What's the syntax to lookup a member table to see if a member already exist?  The member table contains lname, fname, dob, phoneno etc. with dob being the most unique field.  I am thinking lookup the dob and if it exist, check the lname and fname to see if it's the same?

Any assistance appreciated.

 

Regards

Toukey

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (2)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___