Show only not empty fields

[SergioBS]

Hi Everybody!

well, Ive a small db where I store automatically the entry from a website
form
Each record has around 40 data fieds, but many of them are empty.
Since I've to display them on a website page, I'd like to show only fields
that are not empty.
just to be clear: I want not to show the empty fields, not the record with
that fields empty.
I presume that from a certain point of wiew it seems impossible since each
record could be difference and this break the integrity of the db, but
probably there is a solution...on the "show" side...

Thank you!

Sergio

 

[Allen Browne]

The solution is to store the data differently, so there are not lots of
empty fields.

Typically, people put an Access table together like a spreadsheet with lots
of columns, e.g.:
ClientName Week1 Week2 Week3 ...
or
Entity Type1 Type2 Type3 ...

Instead, you need 2 table: one for the client/entity info, and one for the
data that repeats in the other columns. The 2nd table has just these fields:
ClientID WeekNum Value
or
EntityID Type Value

The Table Analyzer in Access may be able to help you figure out how to do
this: Tools | Analyze | Table.

If you want to research this large topic, search for "normalization".