Printing only filled records.

[habiler]

Hello everybody,

I have record in wich I would print the records whose fields A is filled but not field B or Field C is filled and not field D.

See appendices.

Congretulations

 

[habiler]

I do not know how to start. I'm new in reports. Maybe with if ... then .Visible.

I m sorry for my english but my mothertong is French

Habiler

 

[JHB]

Try it now.

 

[habiler]

Thank you for your attention.
without wishing to be difficult, would it not be possible to print only this:

34 Congé parental Datenv_2 : 07/09/2014
37 Mutation (tempor) Datenv_3 : 30/09/2014

Thanks

Habiler.

 

[JHB]

Yes, but not in the way you've set in up, both report and data.

This article explains database normalization terminology for beginners and how you've to organize the data in a database, because what you've done, is how you would do it in Excel and that is quiet different in a database.
http://support.microsoft.com/kb/283878

 

[habiler]

Thank you for your patience.

I read the document optimization, but I really do not see how to solve my problem. I do not know which fields I need to put in another table. I block.

 

[JHB]

The fields Datenv_1 to Datenv_3 and Datert_1 to Datert_3 should be taken out of the table Dossier and into a new table, with 3 fields.
I've made temporary solution until you get a grip on your data and tables.