Using Expressions

[Stephen111]

Hello I have 2 tables that I'm making a query with..

I am linking these tables by a field called GradeID however in one o
the

tables the field Type is a NUmber and in the other is TEXT reason fo
this one being TEXT is because I use comma's in it.

Example... Table that is text 1,2

8,

Table that is number



now i have another field Called GradePrefix which is a 2 letter TEX
fiel
that I am merging with a field called PartNumber
here is the expression i'm usin

Expr1: [ProductGrade]![PartPrefix]+[Parts]![PartNo

The only ones showing results right now are the single digit numbers
What I need to know is how would I get it to show both of the entrie
with the comma seperating them?

if anyone can help.. i would appreciate it

thanks in advanc

 

[Larry Linson]

Access does not have "multivalue fields" as do some desktop databases, which
allow multiple values in a single field. A text value of "1,2" is perfectly
valid as a text field. I am wondering if you expect something more of those
fields.

You need to be precise in describing the Fields and how you expect to use
them -- perhaps if you clarify, someone can offer useful suggestions.

Larry Linson
Microsoft Access MVP