replicating column data in each row

  • Thread starter Thread starter wehrd1
  • Start date Start date
W

wehrd1

I have a table that I use to reprint a 'form' (report). I
have added columns in my table for each row, and the added
columns should contain the same info. over & over. I
can't for the life of me remember what I did last year to
get it to work... It was something with "xxx" quotes
around my text, but I don't remember where I entered this
to get the data to fill 81,000 in my new column. Copy &
paste doesn't work in an access table, except one record
at a time.
Thank you
 
I have a table that I use to reprint a 'form' (report). I
have added columns in my table for each row, and the added
columns should contain the same info. over & over. I
can't for the life of me remember what I did last year to
get it to work... It was something with "xxx" quotes
around my text, but I don't remember where I entered this
to get the data to fill 81,000 in my new column. Copy &
paste doesn't work in an access table, except one record
at a time.
Thank you
Click to expand...

STOP.

You're using a relational database. USE IT RELATIONALLY!

If you're assuming that you must have a Table with all the fields that
you want in your report - *you don't*. You can, and should, base the
Report on a Query, not on the table.

If the extra field is the same for all records, you could simply put a
label on the report; or, you could create a Query based on the table,
include all the table fields you want to see, and then type

AdditionalField: "Repeated Data"

to create a new field named AdditionalField for which all records
contain the text "Repeated Data".
 
Back
Top