 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / January 2008ODBC linked table
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 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.  SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) > Hello, > [quoted text clipped - 11 lines] > Thank you all. > Barbara Thank you Douglas, It worked just fine. By the way, and sorry for the question..... but what's DBMS??? Thanks again Barbara > What's the DBMS? You might be able to create a view in it that concatenates > the three fields, and link to that view. [quoted text clipped - 17 lines] > > Thank you all. > > Barbara Data Base Management System. In other words, are you connecting to, say, SQL Server or Oracle? (They both support views) SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) > Thank you Douglas, > [quoted text clipped - 31 lines] >> > Thank you all. >> > Barbara None of those Douglas. I conect to an iSeries 515 (AS/400) directly via ODBC. > Data Base Management System. In other words, are you connecting to, say, SQL > Server or Oracle? (They both support views) [quoted text clipped - 34 lines] > >> > Thank you all. > >> > Barbara |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.