Query Problem - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Query Problem

Spencar Diedrich

4 years ago

I am running a query to figure a drivers pay. I am pulling information off numerous other queries and totaling all of them here. When all queries are returning values the query runs correctly. When one of the original queries has no data returned then the final query shows up empty. What am I missing?

	Richard Rost @Reply 4 years ago
Nz function

	Spencar Diedrich OP @Reply 4 years ago

	Spencar Diedrich OP @Reply 4 years ago
Still not working. New at this.

	Kevin Robertson @Reply 4 years ago
I tried using Nz in a query with a similar setup as yours - didn't work for me either. Instead, I used the IIF Function to set my Null/blank values to zero. I then fed that query into a second query to perform the final calculation.

	Spencar Diedrich OP @Reply 4 years ago
will give that a whirl. Thanks

	Richard Rost @Reply 4 years ago
Works fine for me...

	Richard Rost @Reply 4 years ago

	Richard Rost @Reply 4 years ago

	Richard Rost @Reply 4 years ago
If you don't have a RECORD in one of those tables, you're going to run into a null value too. Make sure you use an OUTER JOIN.

	Spencar Diedrich OP @Reply 4 years ago
Thanks

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View