Hi marius
MS Access Professionals is small enough that you can get to know people and sort of keep up with what is going on ;) There are not very many posts here, but that is part of its charm ;)
I also post on UtterAccess and contribute to the UtterAccess wiki. I also search for information on UA, it is a great place with lots of charm too.
Just please, do not ever post the same question here and there. Many of us will see you do that and it will not be appreciated.
Welcome!
Warm Regards,
Crystal
Microsoft MVP
remote programming and training
Access Basics by Crystal
http://www.AccessMVP.com/strive4peace
Free 100-page book that covers essentials in Access
*
(: have an awesome day :)
*
________________________________
From: Duane
I'm a member at Utter Access but rarely visit it. This forum has great talent with quick responses. I wouldn't look much further. You can also post files to have someone review.
I would also caution against posting the same question in multiple forums. If you post here and seem to have stumped the experts, I expect either your question isn't clear or your request is off-the-wall.
Duane Hookom
MS Access MVP
--- In MS_Access_Professionals@yahoogroups.com, "marius" <marius@...> wrote:
>
> Tell m, please, wich is the most active one.
> Now i'm on romanian forum, but is very small, and i'm on utter access, and that forum is very nice.
>
> --- In MS_Access_Professionals@yahoogroups.com, "Duane" <duanehookom@> wrote:
> >
> > Marius,
> > Glad to hear your question was answered and you have a solution.
> >
> > "And I have a questions: you are on some access forums?"
> > Yes, I monitor and reply to questions (and ask sometimes) in about 5-6 different Access support forums.
> >
> > Duane Hookom
> > MS Access MVP
> >
> > --- In MS_Access_Professionals@yahoogroups.com, "marius" <marius@> wrote:
> > >
> > > Thanks a lot, this was the way to do what i wanted.
> > > I really thaks you.
> > > Together with "val" and "nz" function, I did a very complex query, and I rezolve all my problems.
> > >
> > > And I have a questions: you are on some access forums?
> > >
> > >
> > > best regards, marius
> > >
> > >
> > >
> > > --- In MS_Access_Professionals@yahoogroups.com, "Duane" <duanehookom@> wrote:
> > > >
> > > > Marius,
> > > >
> > > > Based on your example records, as I suggested, you can use a crosstab query with SQL like:
> > > >
> > > > TRANSFORM First(ThisTable.Input) AS FirstOfInput
> > > > SELECT ThisTable.ID
> > > > FROM ThisTable
> > > > GROUP BY ThisTable.ID
> > > > PIVOT "Input" & [Nr Crt];
> > > >
> > > > The results are (view fixed width):
> > > > ID Input1 Input2 Input3 Input4 Input5
> > > > == ====== ====== ====== ====== ======
> > > > xx 1000 2000 3000 4000 5000
> > > >
> > > > If your table or field names and/or your data is different from what you provided, you will need to change the SQL.
> > > >
> > > > Duane Hookom
> > > > MS Access MVP
> > > >
> > > > --- In MS_Access_Professionals@yahoogroups.com, "marius" <marius@> wrote:
> > > > >
> > > > > 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.
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>
------------------------------------
Yahoo! Groups Links
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar