|
| 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
December 29th, 2006, 07:55 PM
posted to microsoft.public.access.forms
|
|||
|
|||
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
December 29th, 2006, 08:00 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
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
December 29th, 2006, 08:00 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
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
December 29th, 2006, 08:07 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
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
December 30th, 2006, 09:01 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
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 | |
|
|
Linear Mode
