Marius
If you want to post an image or any kind of file all you have to do is go to our Files Folder (see the frame on the left side of our pages).
One of the most used folders is the one named Files>2_AssistanceNeeded. If you want us to look at a sample database be sure to remove any sensitive data that should not be floating around the Internet. Compact it and then zip it so it takes up as little space in our directory as possible. Yahoo is a bit stingy when it comes to assigning space for groups.
And don't feel bad about cross-posting at other forums. People new to forums don't always understand that it leads to confusion.
I hope you will continue to be active here. We love helping those with database questions.
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile/Bill.Mosca
--- In MS_Access_Professionals@yahoogroups.com, "marius" <marius@...> wrote:
>
>
> 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.
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
Tidak ada komentar:
Posting Komentar