Auto fill field from other fields

[David H]

How do I fill a field with the contents of other fields in the same record,
including dashes, spaces, text etc., like the concatenate function in Excel.

David H

 

[Joseph Meehan]

How do I fill a field with the contents of other fields in the same
record, including dashes, spaces, text etc., like the concatenate
function in Excel.

David H

You can use a update query.

I really wonder why you need to. It sure sounds like you have a bad
table design.

 

[David H]

Can this not be done dynamically at the point of entry?

The table is required for import to other software which generates web pages
from each record. The individual field are required for the individual web
pages and the and the two concatenated fields are required for
1. An index web page made up of 5 fields (at the point of input I do not
want differneces in spelling, typos etc.
e.g. =[ArtistSurname] & ", " & [ArtistForename] & " - " & [PaintingName] &
" - " & [PaintingMedium] & " - " & [PaintingSize]


2. A field linking to an image which is user unfriendly when keing a large
number of records.
e.g.
="<img src=" & "'" & [PaintingName] & ".jpg'>"

David H

 

[Joseph Meehan]

Can this not be done dynamically at the point of entry?

Sure. Just add a little code to update the second filed on some
appropriate event, like on update of the first filed.

The table is required for import to other software which generates
web pages from each record. The individual field are required for
the individual web pages and the and the two concatenated fields are
required for

I'll take you word for that, I have never worked with a web application
of Access.

1. An index web page made up of 5 fields (at the point of input I do
not want differneces in spelling, typos etc.
e.g. =[ArtistSurname] & ", " & [ArtistForename] & " - " &
[PaintingName] & " - " & [PaintingMedium] & " - " & [PaintingSize]


2. A field linking to an image which is user unfriendly when keing a
large number of records.
e.g.
="<img src=" & "'" & [PaintingName] & ".jpg'>"

David H

 

[David H]

Can this not be done dynamically at the point of entry?

Sure. Just add a little code to update the second filed on some
appropriate event, like on update of the first filed.
Wfat is the code for this?

The table is required for import to other software which generates
web pages from each record. The individual field are required for
the individual web pages and the and the two concatenated fields are
required for

I'll take you word for that, I have never worked with a web application
of Access.

1. An index web page made up of 5 fields (at the point of input I do
not want differneces in spelling, typos etc.
e.g. =[ArtistSurname] & ", " & [ArtistForename] & " - " &
[PaintingName] & " - " & [PaintingMedium] & " - " & [PaintingSize]


2. A field linking to an image which is user unfriendly when keing a
large number of records.
e.g.
="<img src=" & "'" & [PaintingName] & ".jpg'>"

David H

Thanks for your help
David H

 

[Steve Schapel]

David,

If the concatenated value is required for the purpose of export to
another application, probably the easiest is to export form a query
which uses a calculated field exactly as you have described...
FieldForExport: [ArtistSurname] & ", " & [ArtistForename] & " - " &
[PaintingName] & " - " & [PaintingMedium] & " - " & [PaintingSize]

If, however, you really need this value in a table, for some reason that
you haven't told us about yet, then you could do this using an Update
Query to set the value of the FieldForExport to the concatenated string.