only show when not null

[swarv]

I have this code in a query:

SELECT absent.name, absent.fullname, absent.Days, tbl_users.bradfordscore
FROM absent, tbl_users
WHERE (((tbl_users.Team)="IT") AND ((tbl_users.user_id)=[absent].[name]));

and it gives this as the result:

name ...fullname ......days bradfordscore
jo.......................... .........8
jo........ jo owen........ 8 .....8
martin.................... ..........3
martin . martin storey...3..... 3


Now I would like it to only display the 2nd and 4th line. i.e. where there isn't a fullname I dont want it to display the record.

Any ideas?

thanks

Martin

 

[boblarson]

Change this:
WHERE (((tbl_users.Team)="IT") AND ((tbl_users.user_id)=[absent].[name]));

to this

WHERE (((tbl_users.Team)="IT") AND ((tbl_users.user_id)=[absent].[name]) AND ((fullname) Is Not Null));

 

[swarv]

excellent thanks, I did try something similar but forgot to move brackets around.

thanks

 

[boblarson]

but forgot to move brackets around.

I do agree - the brackets are a pain in the butt to try to get right for Access to like it. Normally to keep from having to worry about it I use the QBE grid whenever possible so I don't have to try to manually figure it out.