Dates

[Guest]

I am trying to create a report that will look something like this:

Location1 Location2
(Yards) This Year|Last Year This Year|Last Year
Today
MTD
YTD

I am able to get by year and month but I have to create different reports to
display by month and year. Is there a way to combine them on one report.
Thanks for the help!!

 

[Duane Hookom]

You are expecting someone to put a fair amount of time into finding and
replying with a solution. However, you haven't provided a clue as to your
table or field names or sample records.

 

[Guest]

Ok Fair enough. I have a table called yards. In this table I have the
following fields: Date, Location 1 Yards, Location 2 Yards, Now what I am
looking to do is dislay on my report Yards Poured for loaction 1 by current
day, month to date, and year to date. I can do an individual report for month
and year to date but I would like them to all be on the same report. Date is
in a standard date format 03/01/2005, yards are displayed long integer 215,
210, 205.5.

 

[Duane Hookom]

How does This Year and Last Year figure in to this solution?

 

[Guest]

They want me to compare Month to Date this year with Month to date Last Year,
Year to Date this year and Year to Date last Year, This would be for my yards
poured field. I have been thinking which is never a good idea but is there a
way to take an unbound text box and have something like sum([Yards Poured]
between[Date]. Yes I know that is not a correct formula but as you can see I
am no programmer.

 

[Duane Hookom]

You could add a text box in your report footer with a control source like:
=Sum( Abs([DateField] Between #1/1/2004# and Date()) * [Location 1 Yards])

--
Duane Hookom
MS Access MVP
--

They want me to compare Month to Date this year with Month to date Last
Year,
Year to Date this year and Year to Date last Year, This would be for my
yards
poured field. I have been thinking which is never a good idea but is there
a
way to take an unbound text box and have something like sum([Yards Poured]
between[Date]. Yes I know that is not a correct formula but as you can see
I
am no programmer.

How does This Year and Last Year figure in to this solution?

 

[Guest]

That's the ticket!!! Thanks for weeding through my clutter!!!!

You could add a text box in your report footer with a control source like:
=Sum( Abs([DateField] Between #1/1/2004# and Date()) * [Location 1 Yards])

--
Duane Hookom
MS Access MVP
--

They want me to compare Month to Date this year with Month to date Last
Year,
Year to Date this year and Year to Date last Year, This would be for my
yards
poured field. I have been thinking which is never a good idea but is there
a
way to take an unbound text box and have something like sum([Yards Poured]
between[Date]. Yes I know that is not a correct formula but as you can see
I
am no programmer.

How does This Year and Last Year figure in to this solution?

--
Duane Hookom
MS Access MVP


Ok Fair enough. I have a table called yards. In this table I have the
following fields: Date, Location 1 Yards, Location 2 Yards, Now what I
am
looking to do is dislay on my report Yards Poured for loaction 1 by
current
day, month to date, and year to date. I can do an individual report for
month
and year to date but I would like them to all be on the same report.
Date
is
in a standard date format 03/01/2005, yards are displayed long integer
215,
210, 205.5.

:

You are expecting someone to put a fair amount of time into finding
and
replying with a solution. However, you haven't provided a clue as to
your
table or field names or sample records.

--
Duane Hookom
MS Access MVP


I am trying to create a report that will look something like this:

Location1 Location2
(Yards) This Year|Last Year This Year|Last Year
Today
MTD
YTD

I am able to get by year and month but I have to create different
reports
to
display by month and year. Is there a way to combine them on one
report.
Thanks for the help!!