Prev: Left Join query not working in Access 2010
Next: cdo or objmessage??
From: gambler on 6 May 2010 15:00
Im in a handicapping contest tommorrow and have to use most of my time
preparing for it. If i can ill try to post. So dont think i gave up. Without
you im done. Im not familiar with using access vertically. The only way i
know how to use it is horizontally. What you said make a lot of sense, I just
dont know how to do it that way. If i use an access query vertically all i
would get is 20-30 OR STATEMENTS. Im going to try and come up with a better
description of what Im doing. When I have trouble with my program i usually
send the WEB MASTER a copy of what Im doing snd he tries to figure it out.
His strong suit isnt access, so he cant help. I know you dont want to give
out your email address or any phone number or even call me. I UNDERSTAND WAY.
Is there a way i could send my program to this location for you to see what i
have? I know once you see it or i can explain it more clearly you will have a
solution. ALSO MY POST IS BECOMING SEVERAL DAYS OLD. iF FOR SOME REASON ITS
GET TAKEN OFF THE BOARD FOR BEING OLD WHAT IS THE BEST WAY TO REPOST SO THAT
I WILL BE ABLE TO STAY IN TOUGH WITH YOU? I know you dont read every post.
I'll try harder in my next post to explain myself better. Please dont give up
on me Im doing my best to explain myself.
Once again thants for all the help
ed

"John W. Vinson" wrote:

> On Wed, 5 May 2010 11:17:01 -0700, gambler <gambler(a)discussions.microsoft.com>
> wrote:
>
> >I understand why you cant accept me as a client. There are only so many hours
> >in a day. As one gets older he tries to enjoy more of them.
>
> I'm 64 myself so I know just what you mean... that's one reason I'm declining
> the proposal!
>
> >I just appreciate
> >what time you give. Ill do my best when i try and explain what im doing.
> >Please dont get to flustrated with me as im not that good with access. Most
> >of my success is trial and error. Many times i dont know what ive done, but
> >it works.
> >I have a 6 tables like you described above. I joint whatever tables im going
> >to use in a query by connecting lines between the following fields. [ track,
> >date, race , program] This allows the table data to be applied to each horse.
> >I then make up a report to read this data.
> >In the query im writing now, Im giving 20-30 data fields a 1 or 2.
>
> What is this table? What are these fields?
>
> > I hope to
> >apply the 1 or 2 to the data by using IIF statements. My data starts out with
> >trk, date, race, program #, horse name and the 20-30 fields of IFF
> >statements.
>
> That's where I think you're going wrong. If you have 20 or 30 different
> values, all of which pertain to a given (track, date, race, program, horse)
> then you should have - I think, not knowing what the data is!!! - 20 or 30
> RECORDS (not fields), in a table with fields for the identifying information
> (track, date, race, program, horse), a field to identify the kind of value
> (perhaps what you're now using as your fieldname), and the value. You could
> then do a totals query *summing down the list* rather than across. That's how
> relational tables work best.
>
> >These will go from left to right across my sheet. At the end of
> >my last field i hope to be able to sum all the 20-30 fields.
>
> Don't confuse data PRESENTATION with data STORAGE. You may visualize the
> values going across, or even present them that way (say with a crosstab
> query), but based on my (incomplete!) understanding of what you're trying to
> do, you should not store them that way.
>
> > This last field
> >i will put in my report. Have i made myself clear? If not ill try again.
> >Sure appreciate help
> >ed
>
> If you could clarify what these fields mean it might help come up with a more
> properly normalized solution.
> --
>
> John W. Vinson [MVP]
> .
>
First  |  Prev  | 
Pages: 1 2 3 4
Prev: Left Join query not working in Access 2010
Next: cdo or objmessage??