[MS_AccessPros] query field alocation.

 

I have this table, it has 5 records maximum.
I have id, nr crt and input. Nr crt is from 1 to 5, and just for this exemple, the input is from 1000 to 5000.
I need to make thru a query an artifice, so the result of that query to be some kind of concatenation between [nr crt] and [input], in this way: to[input1] i must have 1000, for input2] must have 2000...for [input5] i had to have 5000.
A simple concatenation i manage to make, but in the resulting field, the result must be only that one from [input], amean: 1000, 2000...5000.

Any ideea?
I don't know how to put a picture in here. Can anyone tell me how to put a picture here? It should be more easy to explain.

With consideration, MARIUS.

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 10
• New Links 2
• New Files 10

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___