ACCESS ADDITION

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

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

base your report on a query. In the query, create an expression and sum the
fields you want...
SELECT HorseName, NumField1, NumField2,....NumField1 + NumField2 As
SumNumFields
FROM...


Then you can show/use the calculated control on your report.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/201005/1

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