you're welcome, Marius ;) glad you got then answer :)
if you want to post a file, compact/repair and ZIP it if it is a database, and go to this link:
http://tech.groups.yahoo.com/group/MS_Access_Professionals/files/2_AssistanceNeeded/
click:
Add File
in the upper right :)
Warm Regards,
Crystal
*
(: have an awesome day :)
*
________________________________
From: marius
Unfortunately, I did post the same problem here and there.
I didn't know that will not be appreciated.
I'm sorry, and I'll never do this again.
Sorry again.
I think I did not understand how exact;y work this groups, because i don't know how to put an image, an exemple, any thing wich can help to better understanding of my problems, and that's why I preffer to post on forums.
But, here is where I found the answer for my problem and I thank you very much.
Best regards. Marius.
--- In MS_Access_Professionals@yahoogroups.com, Crystal <strive4peace2008@...> wrote:
>
> 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.
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar