How can I access only non empty data field in report

[Mr Sajid Munir]

please here is a table

Example
ID Field Name Marks
1 Math 20
2 English 30
3 Phy empty
4 Chem 10
5 Bio emty

the empty fields must not be shown in reports
please design a query and write code

 

[Albert D. Kallal]

Just build a query with your data.

in the "marks" field, for the condition, just type in:

is not null