•
•
•
•
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 375,221 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 2,179 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.
Please support our MS Access and FileMaker Pro advertiser:
Views: 1524 | Replies: 4
•
•
Join Date: Apr 2008
Posts: 3
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
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 ?
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 ?
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MS Access and FileMaker Pro Marketplace
Threaded Mode- Database Design (Computer Science and Software Design)
- Not able to save query in access (Techies' Lounge)
- i want to save a query in MS Access Database throug c# coding (C#)
- nested joins, from mdb. Possible? (Visual Basic 4 / 5 / 6)
- Automation design in a table (Database Design)
- problem with autogenerated mysql query (MySQL)
- Database design (Database Design)
- Database Design (PHP)
- How do you integrate a database w/web design? best solution for online catalogue? (Database Design)
- web design, development, marketing, and hosting directory (Ad Space for Sale)
Other Threads in the MS Access and FileMaker Pro Forum
- Previous Thread: How do you guys handle autoupdating MS local databases?
- Next Thread: Complex SQL query Please help
