Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

microsoft access training course - null fields

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access training course - Null fields

microsoft access training course - Null fields

ResolvedVersion Standard

Karen has attended:
Access Intermediate course

Null fields

How can I show a number of fields which are not blank

RE: Null fields

Dear Karen

Can you please be more specific. I am not sure if you want extract info within the same field of group of fields!!

If it is a query then please try NOT NULL and see if that helps!!

RE: Null fields

Hi Karen:

Thus

<>""

Cheers

Access tip:

Dsum

You can create percentage values based on individual products / items by using a Dsum function (used with a grouped query)

[Each value column] / Dsum[field:total for the column needed to be calculated],[tablename]

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.17 secs.