[Off Topic] Access Question

Yahoo Archive
1
DUH!!! I canÂ’t believe I forgot about that! It has been so long since I
had to do anything in access, that I forgot ½ of what learned.



Thank you so much.. You have saved me a lot of time!!!



Have a Nice Day,



Dina Hieber

Vamco International, Inc.

Phone (412) 963-7100

Fax; (412) 963-7160



www.vamcointernational.com

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Mark Wonsil
Sent: Thursday, June 21, 2007 1:16 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] [Off Topic] Access Question



> EXAMPLE.
>
> MODEL MATERIAL WIDTH ROLL DIA ROLL WIDTH
>
> Q 14 2.56
>
> In another table - I want a field to read Q142.56

You can define a new column and concatenate the fields:

newFiled = strModel & format(intMaterial) & format(sngWidth)

Use the Format function to change numeric/date fields to strings and then
concatenate them together using the "&" operator.

Mark W.





[Non-text portions of this message have been removed]
2
Hello Everyone!!



I finally got some time where I can do the "little things" that never get
done. And I hit a brick wall in access.



Currently our serial number book is a handwritten book. I am trying to set
up an access database for the new book and integrate s/n book with our
service database.



My problem is - the s/n book has 9 different fields which is the correct
way to do it. But Another section I need those 9 different fields to become
one field.



Does anyone know how to do this?



EXAMPLE.



MODEL MATERIAL WIDTH ROLL DIA ROLL WIDTH

Q 14 2.5
6



In another table - I want a field to read Q142.56



Have a Nice Day,



Dina Hieber

Vamco International, Inc.

Phone (412) 963-7100

Fax; (412) 963-7160



www.vamcointernational.com





[Non-text portions of this message have been removed]
3
> EXAMPLE.
>
> MODEL MATERIAL WIDTH ROLL DIA ROLL WIDTH
>
> Q 14 2.56
>
> In another table - I want a field to read Q142.56

You can define a new column and concatenate the fields:

newFiled = strModel & format(intMaterial) & format(sngWidth)

Use the Format function to change numeric/date fields to strings and then
concatenate them together using the "&" operator.

Mark W.