Is Not Null Doesn't work right

X

XeniaEagle

I have a query based on a table. With 3 columns.
CharityName Paidto50%Charity PaidTo5%Charity
I use the Is Not Null in the CharityName, since many rows are empty.
This works great, but I also need a column for date.
When I add the date column, the Is Not Null does not work.
I have checked all settings and can find no reason, why this is happening.
What am I doing wrong?
Thanks for any help.
Roger
 
M

[MVP] S.Clark

XeniaEagle, huh? I'm a Beavercreek Beaver, class of '88. Go Beavers!

From your description, I can't grasp which field is the date field that you
need. Post your SQL Statement, and maybe your table structure, and we'll
see if anyone can help.
 
X

XeniaEagle

Hey We're neighbors!
Here is the SQL

SELECT Bingo.Date, Bingo.CharityName, Bingo.[PaidTo50%Charity],
Bingo.[PaidTo5%Charity]
FROM Bingo
GROUP BY Bingo.Date, Bingo.CharityName, Bingo.[PaidTo50%Charity],
Bingo.[PaidTo5%Charity]
HAVING (((Bingo.CharityName) Is Not Null))
ORDER BY Bingo.CharityName;

When I take the date out it works perfect, but I need the date
When the date is added, it picks up all records.
All I want is the records which have a CharityName
Thanks for any help
Roger
 
M

[MVP] S.Clark

Actually, I left the 'Creek back in '89, but the love for the area is still
there.

The nature of the GROUP BY is to allow an aggregation, such as a SUM or
COUNT, but can also be used to find unique occurance of values.

So, do you really need the GROUP BY, because I don't see a SUM?

XeniaEagle said:
Hey We're neighbors!
Here is the SQL

SELECT Bingo.Date, Bingo.CharityName, Bingo.[PaidTo50%Charity],
Bingo.[PaidTo5%Charity]
FROM Bingo
GROUP BY Bingo.Date, Bingo.CharityName, Bingo.[PaidTo50%Charity],
Bingo.[PaidTo5%Charity]
HAVING (((Bingo.CharityName) Is Not Null))
ORDER BY Bingo.CharityName;

When I take the date out it works perfect, but I need the date
When the date is added, it picks up all records.
All I want is the records which have a CharityName
Thanks for any help
Roger


[MVP] S.Clark said:
XeniaEagle, huh? I'm a Beavercreek Beaver, class of '88. Go Beavers!

From your description, I can't grasp which field is the date field that you
need. Post your SQL Statement, and maybe your table structure, and we'll
see if anyone can help.
Click to expand...
Click to expand...
 
Top