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
|
|||
|
|||
How do I get a total on a report
My report is based on Date fields, no numbers. How can I total one of the
fields? I'm guessing I'll need to use a Macro or VB. thanks, -- Bonni |
#2
|
|||
|
|||
How do I get a total on a report
What do you want a total of???
I don't know how to total dates, there must be some more info you can share. -- Jeff C Live Well .. Be Happy In All You Do "Bonni Wilbourne" wrote: My report is based on Date fields, no numbers. How can I total one of the fields? I'm guessing I'll need to use a Macro or VB. thanks, -- Bonni |
#3
|
|||
|
|||
How do I get a total on a report
Bonni Wilbourne wrote: My report is based on Date fields, no numbers. How can I total one of the fields? I'm guessing I'll need to use a Macro or VB. thanks, -- Bonni Create a new field and set it's control source to: =Sum(Fieldname) I think that should work. |
#4
|
|||
|
|||
How do I get a total on a report
The report contains a name, an action taken, contract number, transaction and
a date field. I would like to be able to total or the action. -- Bonni "Jeff C" wrote: What do you want a total of??? I don't know how to total dates, there must be some more info you can share. -- Jeff C Live Well .. Be Happy In All You Do "Bonni Wilbourne" wrote: My report is based on Date fields, no numbers. How can I total one of the fields? I'm guessing I'll need to use a Macro or VB. thanks, -- Bonni |
#5
|
|||
|
|||
How do I get a total on a report
Hi Bonnie
To add to Jeff C's post, it is a little confusing as to "what" you want the total of If you have field that contain 1 and 2 and 3 the "total" = 6 But if your have fields that contain a name, an action taken, contract number, transaction and a date field there is nothing really to "total". eg. Name John and Sally and Jim "total" = ???? I think that most people think of Total as another word forSum but if may be you are thinking of another calculation. You could do a Count of fields that have certain data or count IIF or other calculations but not really a total (sum). From again Jeff C's post can you give some more information about what you are trying to get - with an example of the type of "total" you need. -- Wayne Manchester, England. "Bonni Wilbourne" wrote: The report contains a name, an action taken, contract number, transaction and a date field. I would like to be able to total or the action. -- Bonni "Jeff C" wrote: What do you want a total of??? I don't know how to total dates, there must be some more info you can share. -- Jeff C Live Well .. Be Happy In All You Do "Bonni Wilbourne" wrote: My report is based on Date fields, no numbers. How can I total one of the fields? I'm guessing I'll need to use a Macro or VB. thanks, -- Bonni |
Thread Tools | |
Display Modes | |
|
|