Hi Marius,
When you view this message, click on 'Show Message Info' at the top
right-hand side and select 'Use Fixed Width Font. It will show the
message as formatted.
You can show your table contents something like this,
ID NR_CRT Input
1 abc 1000
2 def 2000
3 ghi 3000
4 jkl 4000
5 mno 5000
Is this what you want from the query? Please correct it if
necessary.
Required Query Output
ID Result
1 abc1000
2 def2000
3 ghi3000
4 jkl4000
5 mno5000
Regards, Clive.
--- In MS_Access_Professionals@yahoogroups.com, "marius" <marius@...> wrote:
>
> 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.
>
Tidak ada komentar:
Posting Komentar