Duplicate data in access 2013 report

[aattas]

gentlemen,

I have unbound fields that i used as "=

.[column](3) " . i see the result in the form and they worked. But when i want to create a report from this unbound result as follows " Forms![main form]![field]. It doesnt show individual data instead it picked up the last saved and displayed the same data for all inputs. I dont know what to do. I am attaching snapshot of the report. You will see under the OPERATOR field , its repeating all the same one . also the FEE and TOTAL fields. Each of the line has a different OPERATOR Name and different FEES and TOTAL.
pls help.

 

[plog]

You really confused me with your unbound fields reference. Reports should be based on queries (or tables). Is the data showing on this report not entirely based on a table/query? Is it actually sucking in data from a form somewhere?

 

[aattas]

hi plog. thanks for the respone. the data was not based query but based on the data from a table that searched thru the columns as (2) or (3) are the columns number in a table.

 

[aattas]

hi again
I forgot to mention that I was performing the population of data from the table to the form

 

[plog]

Even more confused. I have no idea how a form fits into this. Can you post your database?

 

[JHB]

..
I have unbound fields that i used as "=

.[column](3) " . i see the result in the form and they worked. But when i want to create a report from this unbound result as follows " Forms![main form]![field]. It doesnt show individual data instead it picked up the last saved and displayed the same data for all inputs. ..

That is the way unbound fields works, it only shows one record, (one set of values)!!
You experience the same if you place an unbound control on a form.

 

[aattas]

gentlemn, thankyou, but i solved my problem.

Instead of copying from the form, i added the value with the population and it worked as a charm.