Query Design -- If -Then -Else?

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 329,006 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,361 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

•

FAQ | Community Rules | Welcome Guide

Please support our MS Access and FileMaker Pro advertiser:

Thread Tools Display Modes

Views: 605 | Replies: 4

•

Join Date: Apr 2008

Posts: 3

Reputation: wallaby34 is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

wallaby34

Offline

Newbie Poster

Query Design -- If -Then -Else?

22 Days Ago

Still in a VERY steep learning curve with MS Access 2000 / 2003

Main Table has LastName - HomePhome - MobilePhone plus others of course
Some rows will have no entry in the HomePhone field but will have one in the MobilePhone field.
I am trying to set Query criteria to give me "If HomePhone is Null (no entry) then insert the data from the MobilePhone field into the HomePhone query result"
Have tried the IIf statements, but to no avail. Am fast losing what little hair I have left!
Please can anyone help ?

•

Join Date: Jan 2007

Posts: 2,210

Reputation: MidiMagic is an unknown quantity at this point

Rep Power: 6

Solved Threads: 75

MidiMagic

Offline

Nearly a Posting Maven

Re: Query Design -- If -Then -Else?

20 Days Ago

Try asking if the field equals "".

Daylight-saving time uses more gasoline

•

Join Date: Nov 2007

Location: Arkansas

Posts: 113

Reputation: buddylee17 is an unknown quantity at this point

Rep Power: 1

Solved Threads: 21

buddylee17 buddylee17 is offline

Offline

Junior Poster

Re: Query Design -- If -Then -Else?

19 Days Ago

 Help with Code Tags 
 SQL Syntax (Toggle Plain Text) 
UPDATE TABLE SET HomePhone=MobilePhone WHERE (HomePhone) IS NULL;
UPDATE Table SET HomePhone=MobilePhone WHERE (HomePhone) Is null;

Last edited by buddylee17 : 19 Days Ago at 10:17 am.

•

Join Date: Apr 2008

Posts: 3

Reputation: wallaby34 is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

wallaby34

Offline

Newbie Poster

Re: Query Design -- If -Then -Else?

18 Days Ago

•

Originally Posted by buddylee17

Help with Code Tags

SQL Syntax (Toggle Plain Text)
UPDATE TABLE SET HomePhone=MobilePhone WHERE (HomePhone) IS NULL;
UPDATE Table SET HomePhone=MobilePhone WHERE (HomePhone) Is null;

Thanks for the suggestion.
I guess my problem is the 10-12 years since I di much with Access, I have forgotten a lot (Not that I ever knew much !) and I am trying to keep my mind active

The following is what I have tried, with no success.

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
SELECT Tbl_Members.LastName, Tbl_Members.FirstName, Tbl_Members.City, Tbl_Members.HomePhone, Tbl_Members.EmailAddress, Tbl_Members.MobilePhone
FROM Tbl_Members
WHERE (((Tbl_Members.EmailAddress)<>" " AND (HomePhone=MobilePhone WHERE (HomePhone) IS NULL)) ));
SELECT Tbl_Members.LastName, Tbl_Members.FirstName, Tbl_Members.City, Tbl_Members.HomePhone, Tbl_Members.EmailAddress, Tbl_Members.MobilePhone
FROM Tbl_Members
WHERE (((Tbl_Members.EmailAddress)<>" " AND (HomePhone=MobilePhone WHERE (HomePhone) IS NULL)) ));

In which area have I gone wrong ??

Thanks

Last edited by peter_budo : 17 Days Ago at 7:30 pm. Reason: Keep It Organized - please use [code] tags

•

Join Date: Apr 2008

Posts: 3

Reputation: wallaby34 is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

wallaby34

Offline

Newbie Poster

Re: Query Design -- If -Then -Else?

14 Days Ago

•

Originally Posted by buddylee17

Help with Code Tags

SQL Syntax (Toggle Plain Text)
UPDATE TABLE SET HomePhone=MobilePhone WHERE (HomePhone) IS NULL;
UPDATE Table SET HomePhone=MobilePhone WHERE (HomePhone) Is null;