Need Pivot report to give total of entries made from noon to noon

[Guest]

I have created a cash log. Entries will be made throughout the day. I have
added a time field with the Now() function. I previously created a pivot
report using the date and location simply giving a total of cash collected
for each date. Now, instead, I need the total of cash collected from 12:01pm
one day to 12:00pm the next day. What is the best way to do this? Thanks!

 

[Duane Hookom]

Add or subtract 1/2 day to your field.

 

[Guest]

Thanks Duane! I'm quite new to figuring out Access. Can you be a bit more
specific please?

Thanks for your help!

 

[Duane Hookom]

To calculate the date to assign your transaction, create a column in a query
like:
TransDate: DateValue([DateField]-.5)

 

[Guest]

I already have a date and time field which both use the Now() Function, which
is what I need. I now want to figure out how to get a total of an Amount Paid
field. The total will be of all entries made from 12:01pm the first day to
12:00pm the next day. I want this to be figured automatically and displayed
in a report. I have a Pivot view report which works to give daily totals but
now I no longer need the totals for each day at the end of the day. Now I
need noon to noon totals. I don't know if I would create the Pivot Report
differently or how I can do this.

To calculate the date to assign your transaction, create a column in a query
like:
TransDate: DateValue([DateField]-.5)

--
Duane Hookom
MS Access MVP
--

Thanks Duane! I'm quite new to figuring out Access. Can you be a bit more
specific please?

Thanks for your help!

 

[Duane Hookom]

What don't you understand about converting/displaying your nameless "date
and time field" as a transaction date value?

--
Duane Hookom
MS Access MVP

I already have a date and time field which both use the Now() Function,
which
is what I need. I now want to figure out how to get a total of an Amount
Paid
field. The total will be of all entries made from 12:01pm the first day to
12:00pm the next day. I want this to be figured automatically and
displayed
in a report. I have a Pivot view report which works to give daily totals
but
now I no longer need the totals for each day at the end of the day. Now I
need noon to noon totals. I don't know if I would create the Pivot Report
differently or how I can do this.

To calculate the date to assign your transaction, create a column in a
query
like:
TransDate: DateValue([DateField]-.5)

--
Duane Hookom
MS Access MVP
--

Thanks Duane! I'm quite new to figuring out Access. Can you be a bit
more
specific please?

Thanks for your help!

:

Add or subtract 1/2 day to your field.

--
Duane Hookom
MS Access MVP


I have created a cash log. Entries will be made throughout the day. I
have
added a time field with the Now() function. I previously created a
pivot
report using the date and location simply giving a total of cash
collected
for each date. Now, instead, I need the total of cash collected from
12:01pm
one day to 12:00pm the next day. What is the best way to do this?
Thanks!

 

[Guest]

I don't understand how it helps me. What does it do? And how does that get me
closer to what I'm trying to do?

What don't you understand about converting/displaying your nameless "date
and time field" as a transaction date value?

--
Duane Hookom
MS Access MVP

I already have a date and time field which both use the Now() Function,
which
is what I need. I now want to figure out how to get a total of an Amount
Paid
field. The total will be of all entries made from 12:01pm the first day to
12:00pm the next day. I want this to be figured automatically and
displayed
in a report. I have a Pivot view report which works to give daily totals
but
now I no longer need the totals for each day at the end of the day. Now I
need noon to noon totals. I don't know if I would create the Pivot Report
differently or how I can do this.

To calculate the date to assign your transaction, create a column in a
query
like:
TransDate: DateValue([DateField]-.5)

--
Duane Hookom
MS Access MVP
--

Thanks Duane! I'm quite new to figuring out Access. Can you be a bit
more
specific please?

Thanks for your help!

:

Add or subtract 1/2 day to your field.

--
Duane Hookom
MS Access MVP


I have created a cash log. Entries will be made throughout the day. I
have
added a time field with the Now() function. I previously created a
pivot
report using the date and location simply giving a total of cash
collected
for each date. Now, instead, I need the total of cash collected from
12:01pm
one day to 12:00pm the next day. What is the best way to do this?
Thanks!

 

[Guest]

As you can tell, when I say I am just figuring Access out there is a lot I
don't know. If I can understand the right direction to go on this I'll try to
learn more and figure that out before I ask more questions.

So far I have not created any queries. I have a Pivot Report which is really
all I need. The rows are dilineated by the Date/Time field and the Columns by
the Amount Paid (atlest that is how I have them set up right now). Is it
possible to create a Total in the report using Sum with a Between....And
expression? The expression would involve something like, SUM(BETWEEN the
relative date and time of 12:01pm AND the next consecutive date and time of
12:00pm).

Is that possible?

I really appreciate your help.

I don't understand how it helps me. What does it do? And how does that get me
closer to what I'm trying to do?

What don't you understand about converting/displaying your nameless "date
and time field" as a transaction date value?

--
Duane Hookom
MS Access MVP

I already have a date and time field which both use the Now() Function,
which
is what I need. I now want to figure out how to get a total of an Amount
Paid
field. The total will be of all entries made from 12:01pm the first day to
12:00pm the next day. I want this to be figured automatically and
displayed
in a report. I have a Pivot view report which works to give daily totals
but
now I no longer need the totals for each day at the end of the day. Now I
need noon to noon totals. I don't know if I would create the Pivot Report
differently or how I can do this.

:

To calculate the date to assign your transaction, create a column in a
query
like:
TransDate: DateValue([DateField]-.5)

--
Duane Hookom
MS Access MVP
--

Thanks Duane! I'm quite new to figuring out Access. Can you be a bit
more
specific please?

Thanks for your help!

:

Add or subtract 1/2 day to your field.

--
Duane Hookom
MS Access MVP


I have created a cash log. Entries will be made throughout the day. I
have
added a time field with the Now() function. I previously created a
pivot
report using the date and location simply giving a total of cash
collected
for each date. Now, instead, I need the total of cash collected from
12:01pm
one day to 12:00pm the next day. What is the best way to do this?
Thanks!

 

[Duane Hookom]

I have worked in Access for about 10 years and have never created a pivot
table or pivot report.

Read about and play with queries. You can use a query almost any place you
would use a table for (including pivot stuff). In a query, you can create a
calculated column such as:
TotalPrice: [UnitPrice] * [Quantity]
or
NextWeek: DateAdd("ww",1,[DateField])
or
TransDate: DateValue([DateField]-.5)
In each case, you are creating a column/field in the query that displays a
calculated value based on other fields in the table.

--
Duane Hookom
MS Access MVP

As you can tell, when I say I am just figuring Access out there is a lot
I
don't know. If I can understand the right direction to go on this I'll try
to
learn more and figure that out before I ask more questions.

So far I have not created any queries. I have a Pivot Report which is
really
all I need. The rows are dilineated by the Date/Time field and the Columns
by
the Amount Paid (atlest that is how I have them set up right now). Is it
possible to create a Total in the report using Sum with a Between....And
expression? The expression would involve something like, SUM(BETWEEN the
relative date and time of 12:01pm AND the next consecutive date and time
of
12:00pm).

Is that possible?

I really appreciate your help.

I don't understand how it helps me. What does it do? And how does that
get me
closer to what I'm trying to do?

What don't you understand about converting/displaying your nameless
"date
and time field" as a transaction date value?

--
Duane Hookom
MS Access MVP


I already have a date and time field which both use the Now()
Function,
which
is what I need. I now want to figure out how to get a total of an
Amount
Paid
field. The total will be of all entries made from 12:01pm the first
day to
12:00pm the next day. I want this to be figured automatically and
displayed
in a report. I have a Pivot view report which works to give daily
totals
but
now I no longer need the totals for each day at the end of the day.
Now I
need noon to noon totals. I don't know if I would create the Pivot
Report
differently or how I can do this.

:

To calculate the date to assign your transaction, create a column in
a
query
like:
TransDate: DateValue([DateField]-.5)

--
Duane Hookom
MS Access MVP
--

Thanks Duane! I'm quite new to figuring out Access. Can you be a
bit
more
specific please?

Thanks for your help!

:

Add or subtract 1/2 day to your field.

--
Duane Hookom
MS Access MVP


message
I have created a cash log. Entries will be made throughout the
day. I
have
added a time field with the Now() function. I previously
created a
pivot
report using the date and location simply giving a total of
cash
collected
for each date. Now, instead, I need the total of cash collected
from
12:01pm
one day to 12:00pm the next day. What is the best way to do
this?
Thanks!