ODBC linked table

[Barbara]

Hello,

I have an ODBC linked table with 3 fields giving me a date: Year - Month -
Day.
I need one date field.
Can I setup a new field in my ODBC table concatenating those 3 fields? I did
it but the field is blank. I would need to give some instruction to update it
and I don't know how!
Perhaps there's a better way to do it!!

Plesase let me know if someone have a solution.
Thank you all.
Barbara

 

[Douglas J. Steele]

What's the DBMS? You might be able to create a view in it that concatenates
the three fields, and link to that view.

Alternatively, create a query in Access based on your linked table, do the
concatenation in the query and use the query rather than the table.

 

[Barbara]

Thank you Douglas,

It worked just fine. By the way, and sorry for the question..... but what's
DBMS???

Thanks again
Barbara

 

[Douglas J. Steele]

Data Base Management System. In other words, are you connecting to, say, SQL
Server or Oracle? (They both support views)

 

[Barbara]

None of those Douglas. I conect to an iSeries 515 (AS/400) directly via ODBC.