If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
ACCESS ADDITION
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 |
#3
|
|||
|
|||
ACCESS ADDITION
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 |
#4
|
|||
|
|||
ACCESS ADDITION
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 |
Thread Tools | |
Display Modes | |
|
|