concatinate fields

[Jen0dorf]

Hi

apologies if this is a double post , thought I had submitted it but can't see it in the forum.

I have two fields I am trying to concatinate



1. dateofdeath which is format text dd-mmm

2. Yearofdeath which has two formats one yyyy/yy ( 1856/57) and the second is just yyyy

I need to create a third field by concatination format dd-mm-yyyy BUT whilst using the format yyyy is not a problem the format yyyy/yy presents a difficulty. I need to use the first 2 and last 2 characters ie end up with the year as 1857 ( in the example above)

Can this be done?

thanks

Ian

[June7]

Use string manipulation functions.

dateofdeath & "-" & Left(Yearofdeath,2) & Right(Yearofdeath,2)

[Jen0dorf]

Use string manipulation functions.

dateofdeath & "-" & Left(Yearofdeath,2) & Right(Yearofdeath,2)

THanks I'll try it later


Ian

[Jen0dorf]

Hi

many thanks that worked perfectly - something else to read up on "string Manipulation Functions" ;-)

Just an additional question if I may. A search on google brings up several pages suggesting that using a calculated field in a table is a bad idea so which is better table level or form level or is it as I suspect dependent on other things such as how you are going to use the form?

In my case it is simple used for data display so I have used it in the table.

thanks Ian -so much to learn and so little time

[JoeM]

The best place for calculations is actually a query. Ther query is based off of your table. You can then base your form off of the query instead of the table, so it will have all those calculations available to you.

[Jen0dorf]

THanks for the info

Ian

[June7]

Although I have not used, as far as I can see nothing really wrong with Calculated field in table for simple calcs, unless there is a chance of migrating to another platform like MySQL or SQLServer, then they will be an issue as would multi-value and Attachment fields.