Query question - how to display an expression field if certain criteria is met?

[mike60smart]

Hi

I would recommend that you change your table structure so that you have a table for the Person (tblPersons)

Then a separate table for the related tasks (tblPersonTasks)

 

[isladogs]

Hi

I would recommend that you change your table structure so that you have a table for the Person (tblPersons)

Then a separate table for the related tasks (tblPersonTasks)

Hi Mike
See post #18

 

[mike60smart]

Hi Colin

My apologies for not reading the whole thread.

 

[isladogs]

No problem - I often do the same thing myself