How can I access only non empty data field in report

  • Thread starter Thread starter Mr Sajid Munir
  • Start date Start date
M

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
 
Just build a query with your data.

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

is not null
 
Back
Top