Is it possible to format 2 fields to 1???

  • Thread starter Thread starter Earl.AKA J.Alladien in access forum!!
  • Start date Start date
E

Earl.AKA J.Alladien in access forum!!

Hello All,

I have following fields:

KODE MONTH
2368 JUL-2008 and I want to format both fields to 1(one) so out come
must be :

ID
2368-JUL-2008

Is this possible??

Earl
 
in a query put NewFieldName:[kode] & "-" & [Month] - this doesn't store the
information together (which you probably shouldn't do anyway), but it does
display them together as a field that you can use.
 
If it's a primary key that you want, you can do that using both fields
together as a unique index. In design view, highlight both fields, right
click, select primary key. If you want a unique index (but not primary key),
you can select indexes from the view menu. Give the index a name, select the
first field, in the next line under that field select the second field, but
leave the index name blank on that line. Set any properties you want on the
line that has the index name on it.
 
Thanks Suzy,

Youre right , I just explained it wrong but the problem was solved!!!

SuzyQ said:
in a query put NewFieldName:[kode] & "-" & [Month] - this doesn't store the
information together (which you probably shouldn't do anyway), but it does
display them together as a field that you can use.

Earl.AKA J.Alladien in access forum!! said:
Hello All,

I have following fields:

KODE MONTH
2368 JUL-2008 and I want to format both fields to 1(one) so out come
must be :

ID
2368-JUL-2008

Is this possible??

Earl
Click to expand...
Click to expand...
 
Back
Top