Hi Clives,
This is just an extract, a principle, an ideea.
My DB is very large, very complex, and it can't be uploaded here.
Of course that my table has not only 5 entries. It has hundreds of them.
I have an answer from somebody on o forum, and he create a vba code, wich is work, but is a very complicated way
best regards, marius.
--- In MS_Access_Professionals@yahoogroups.com, "Clive" <zctek@...> wrote:
>
> Hi Duane,
>
> There are only three filds; the 2nd filed is "nr crt".
> View it in 'Use Fixed Width Font'.
> Blanks in FieldNames are bad news.
>
> Hi Marius,
>
> It is unusual to have a table with just five
> records unless it is used as a source list for
> values in a combobox or a list.
>
> I suspect that your tables are not normalized.
> could you upload a zipped copy of your DB to the
> Group_Files 2_AssistanceNeeded folder but nothing
> confidential?
>
> Regards, Clive.
>
> --- In MS_Access_Professionals@yahoogroups.com, "marius" <marius@> wrote:
> >
> > I think, i need to create a flat table with vba code.
> > Unfortunately, I don't know how to do it.
> >
> >
> > --- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@> wrote:
> > >
> > >
> > > 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@
> > > 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]
> > >
> >
>
Tidak ada komentar:
Posting Komentar