I want a duplicate value one time from a field (save)

[Matin_Murad]

I want to show the value of (c11 , a11 , b11) only inside the (save) field
----------------
I do not want from the table properties Yes (redundancy is not acceptable)

 

[theDBguy]

Hi. Here's a screenshot of your form, but I don't understand what you want. Can you please explain? Thanks.

 

[Matin_Murad]

Inside the field (save) the value (a11,b11,c11) has been repeated many times. I want to show one time for each value inside the field (save)

 

[theDBguy]

Inside the field (save) the value (a11,b11,c11) has been repeated many times. I want to show one time for each value inside the field (save)

Okay, well, you're seeing those values because your form is displaying your table. If you only want the single values, then you could either use unbound controls or use a subform based on a DISTINCT query.

 

[Pat Hartman]

We still don't understand. The form is showing what is in the table. Is the table wrong?

 

[theDBguy]

Okay, well, you're seeing those values because your form is displaying your table. If you only want the single values, then you could either use unbound controls or use a subform based on a DISTINCT query.

Here's an example of what I meant. Not sure if it will work for you.