Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 19th, 2008, 05:17 PM
Authorized User
 
Join Date: Jan 2006
Posts: 48
Thanks: 0
Thanked 0 Times in 0 Posts
Default Returning Null Values in a query

I'm dealing with existing records that contain missing data in some fields. For example, i run a query on a clients name and i want to include all the project #'s associated with his name and the zip code to each project #. the problem is if the older records dont contain a zip code then the query doesn't display those paticular records. How can i can i return null values in these fields so i can display all the project #'s regardless if there's a zip code associated with them?

In my Query i have a Client table, a Work Order table, & Zip Code table. The Client & Zip code table each have Primary ID's that are included as fields in my Work Order table. so there is a relationship to each table.

any thoughts on how to solve this issue???

 
Old March 19th, 2008, 06:05 PM
Authorized User
 
Join Date: Jan 2006
Posts: 48
Thanks: 0
Thanked 0 Times in 0 Posts
Default

NEVERMIND!!! i solved my own problem for the moment and it appears to be giving me the results i'm after :)

 
Old March 21st, 2008, 03:59 PM
pjm pjm is offline
Authorized User
 
Join Date: Jul 2006
Posts: 70
Thanks: 0
Thanked 0 Times in 0 Posts
Default

If you post a question and then find the answer on your own, you should (out of curtesy) post some of your solution.

-Phil-





Similar Threads
Thread Thread Starter Forum Replies Last Post
returning null value Vince_421 Access VBA 3 March 6th, 2007 01:54 PM
e.Item.FindControl("DropdownId") Returning Null anup_daware .NET Framework 1.x 1 March 27th, 2006 03:53 PM
Checking null values in Query(SQL Server) Prob leo_vinay Classic ASP Databases 2 December 28th, 2004 04:31 AM
EXEC function not returning values aingalsbe PHP How-To 0 June 1st, 2004 10:03 AM
returning values with SQL stu9820 SQL Language 6 December 8th, 2003 02:36 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.