RE: [MS_AccessPros] Re: query field alocation.

I'm confused since you have 4 field headings/names with only 3 columns of values. This looks like a typical crosstab query with ID possibly as the Row Heading, "Input" & nr as the Column heading, and someother field as Value. Duane HookomMS Access MVP
To: MS_Access_Professionals@yahoogroups.com
From: marius@proteusgrup.ro
Date: Sun, 29 Jan 2012 21:51:32 +0000
Subject: [MS_AccessPros] Re: query field alocation.

Hi Clive,

Unfortunately, I need something else.

I have this field:

id nr crt input

xx 1 1000

xx 2 2000

xx 3 3000

xx 4 4000

xx 5 5000

and I need sometrhing like this:

input1 input2 input3 input4 input5

1000 2000 3000 4000 5000

amean, I need to make one row whith elements from the table one after another, in fuction of nr crt.

This is a transformation of a table to a table with one row.

I have to make many calculation with those numbers only in this way.

Consideration, marius.

--- In MS_Access_Professionals@yahoogroups.com, "Clive" <zctek@...> wrote:

>

> 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.

> >

>

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/