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.

 

[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.