I have a number of fields in my query that i would like to add up and put
that total in my report. My friend said i would first have to write IIF
statements in my query and then make a MAKE TABLE QUERY that would feed my
report. Im a little familiar with he suggested.
Example would be I have 10 horse that have an F field that has a value from
one to 1. The horse with #1 i would give 2 points too. The horse with #2 I
would give 1 point too. There are 20 plus fieds for each horse. What i would
like to do is get the fields total for each worse and export it into my
report.
Ive ask for help before on how to do something and i was lucky enough to get
one person to stick with me till we got it to work. It was quite flustrating
for him. He finally called me and we mission accomplish very quicky.
What would someone charge me to have a phone conversation to tell me what i
need to do. I know from my past experience unless someone calls me, Ill never
figure it out. Any suggestions or help would be appreciated.
Thanks
ed

>>There are 20 plus fieds for each horse.
Change your table/field structure to that of a relational database instead
of a spreadsheet.

--
Build a little, test a little.


"gambler" wrote:

> I have a number of fields in my query that i would like to add up and put
> that total in my report. My friend said i would first have to write IIF
> statements in my query and then make a MAKE TABLE QUERY that would feed my
> report. Im a little familiar with he suggested.
> Example would be I have 10 horse that have an F field that has a value from
> one to 1. The horse with #1 i would give 2 points too. The horse with #2 I
> would give 1 point too. There are 20 plus fieds for each horse. What i would
> like to do is get the fields total for each worse and export it into my
> report.
> Ive ask for help before on how to do something and i was lucky enough to get
> one person to stick with me till we got it to work. It was quite flustrating
> for him. He finally called me and we mission accomplish very quicky.
> What would someone charge me to have a phone conversation to tell me what i
> need to do. I know from my past experience unless someone calls me, Ill never
> figure it out. Any suggestions or help would be appreciated.
> Thanks
> ed

PIETER DO YOU HAVE TIME TO HELP ME. If so how do i contact you.
Thanks
ed

"gambler" wrote:

> I have a number of fields in my query that i would like to add up and put
> that total in my report. My friend said i would first have to write IIF
> statements in my query and then make a MAKE TABLE QUERY that would feed my
> report. Im a little familiar with he suggested.
> Example would be I have 10 horse that have an F field that has a value from
> one to 1. The horse with #1 i would give 2 points too. The horse with #2 I
> would give 1 point too. There are 20 plus fieds for each horse. What i would
> like to do is get the fields total for each worse and export it into my
> report.
> Ive ask for help before on how to do something and i was lucky enough to get
> one person to stick with me till we got it to work. It was quite flustrating
> for him. He finally called me and we mission accomplish very quicky.
> What would someone charge me to have a phone conversation to tell me what i
> need to do. I know from my past experience unless someone calls me, Ill never
> figure it out. Any suggestions or help would be appreciated.
> Thanks
> ed