Reporting different data in the same record

J

JenISCM

I have a report where I need to report data for the same record in two ways.

I can have a Contract Signed date and a Cancelled date for the same record.

I need to create a report to compare this data monthly – totaling all the
Contract Signed in that month and all the Cancelled items in that month.
(These date can occur in the same OR separate months.)

I also need to be able to run this report for specified time periods. (Ex:
Jan – Jun, or just the month of Dec, etc.)

Any assistance would be GREATLY appreciated.
 
J

John W. Vinson

I have a report where I need to report data for the same record in two ways.

I can have a Contract Signed date and a Cancelled date for the same record.

I need to create a report to compare this data monthly – totaling all the
Contract Signed in that month and all the Cancelled items in that month.
(These date can occur in the same OR separate months.)

I also need to be able to run this report for specified time periods. (Ex:
Jan – Jun, or just the month of Dec, etc.)

Any assistance would be GREATLY appreciated.
Click to expand...

A criterion of
= DateSerial([Enter year:], [Enter month number:], 1) AND < DateSerial([Enter year:], [Enter month number:] + 1, 1)
Click to expand...

on both the Contract Signed and the Cancelled field's Criteria line will work.
Put the criterion on *two separate rows* in the query grid so that it will use
OR logic.

It's not quite clear what you mean by "totalling" - what are you totalling?

John W. Vinson [MVP]
 
J

JenISCM

That gave me almost the data I need.

It showed me all the Contract Cancel and all the Contract Signed records in
December. Here is the problem. The Contract Cancelled items have Contract
Signed dates in months other than December. Thus those results show in
months other than Dec on my report.

I think I may have a resolution but maybe you could assist on this.

I have created two separate queries - one for Contract Signed and one for
Cancelled with Between paramters. The only problem and they have to enter
two begin dates and two end dates.

Is there a way to have a SINGLE entry for both queries for the Month Year
like you suggested for both queries. Or link the between parameter form one
to the other so that the report user on has to make one entry OR - if you
have a better solution.

Totalling clarification - From the final resulting data I crated cross tab
queries to total counts and amounts for each Signed and Cancelled record.


--
JenISCM


John W. Vinson said:
I have a report where I need to report data for the same record in two ways.

I can have a Contract Signed date and a Cancelled date for the same record.

I need to create a report to compare this data monthly – totaling all the
Contract Signed in that month and all the Cancelled items in that month.
(These date can occur in the same OR separate months.)

I also need to be able to run this report for specified time periods. (Ex:
Jan – Jun, or just the month of Dec, etc.)

Any assistance would be GREATLY appreciated.
Click to expand...

A criterion of
= DateSerial([Enter year:], [Enter month number:], 1) AND < DateSerial([Enter year:], [Enter month number:] + 1, 1)
Click to expand...

on both the Contract Signed and the Cancelled field's Criteria line will work.
Put the criterion on *two separate rows* in the query grid so that it will use
OR logic.

It's not quite clear what you mean by "totalling" - what are you totalling?

John W. Vinson [MVP]
Click to expand...
 
K

Ken Sheridan

As the dates are in separate columns in the table to group them by month
you'll need to get the year and month for each into the same columns in the
query on which the report is based so you can group by them. You can do this
with a union query, e.g.

SELECT [Contract], [Contract Signed], [Cancelled], [Contact Amount],
YEAR([Contact Signed]) AS TransactionYear,
MONTH([Contact Signed]) AS TransactionMonth
WHERE [Cancelled] IS NULL
UNION ALL
SELECT [Contract], [Contract Signed], [Cancelled], [Contact Amount],
YEAR([Cancelled]), MONTH([Cancelled])
WHERE [Cancelled] IS NOT NULL;

Group the report on TransactionYear and TransactionMonth columns and give
the latter group a group footer.

In the group footer add two text boxes for the two totals. If by
'totalling' you mean counting the instances of contracts signed and cancelled
per month then for signed contracts you'd use an expression like this for the
ControlSource of the text box:

=Sum(IIf(IsNull([Cancelled]) Or Format([Cancelled],"yyyymm") =
Format([Contract Signed],"yyyymm"), 1, 0))

and for the cancelled contracts:

=Sum(IIf(Not IsNull([Cancelled]), 1, 0))

If by totalling you mean summing some other column, e.g. Contact Amount,
then substitute the name of the column for the 1 constants in the above
expressions.

To open the report for a month or range of months create a dialogue form
with text boxes YearStart, MonthStart and YearEnd and Month end in which the
parameters can be entered as numbers. Add a button to the form with code to
open the report like this:

Const conREPORT = "YourReportNameGoesHere"
Dim strCtriteria As String
Dim dtmStart as Date, dtmEnd As Date

dtmStart = DateSerial(Me.YearStart, Me.MonthStart, 1)
dtmEnd = DateSerial(Me.YearEnd, Me.MonthEnd + 1, 0)

strCriteria = _
"[Contract Date] Between #" & _
"Format(dtmStart,"mm/dd/yyyy") & "# And " & _
"Format(dtmEnd,"mm/dd/yyyy") & "# Or " & _
"[Cancelled] Between #" & _
"Format(dtmStart,"mm/dd/yyyy") & "# And " & _
"Format(dtmEnd,"mm/dd/yyyy") & "#"

DoCmd.OpenReporst conREPORT, _
View:=acViewPreview, _
WhereCondition:=strCriteria

Ken Sheridan
Stafford, England
 
J

John W. Vinson

Is there a way to have a SINGLE entry for both queries for the Month Year
like you suggested for both queries. Or link the between parameter form one
to the other so that the report user on has to make one entry OR - if you
have a better solution.
Click to expand...

Ken's UNION query suggestion is your best bet. Sorry about misinterpreting the
requirement!

John W. Vinson [MVP]
 
J

JenISCM

I am just an intermediate Access user with little SQL knowledge, but the
UNION query sounds like the answer to numerous issues I have with trying to
filter based on varied dates, so I tried to recreate using my data (note: I
have multiple tables so I specified the from)

SELECT [CONTRACTSIGNED], [CONTRACTCX]
FROM [CCLIENT]
YEAR ([CONTRACTSIGNED]) AS TransactionYear
MONTH ([CONTRACTSIGNED]) AS TrasnactionMonth
WHERE [CONTRACTCX] IS NULL
UNION ALL
SELECT [CONTRACTSIGNED], [CONTRACTCX]
FROM [CCLIENT]
Year ([CONTRACTCX]), MONTH ([CONTRACTCX])
WHERE [CONTRACTCX] IS NOT NULL;

I keep getting a syntax error - what is wrong with my formula???

OR I tried:

And I get a syntax error that formua contains a reserved word:
SELECT [CONTRACTSIGNED], [CONTRACTCX],
YEAR ([CONTRACTSIGNED]) AS TransactionYear
MONTH ([CONTRACTSIGNED]) AS TrasnactionMonth
WHERE [CONTRACTCX] IS NULL
UNION ALL
SELECT [CONTRACTSIGNED], [CONTRACTCX]
Year ([CONTRACTCX]), MONTH ([CONTRACTCX])
WHERE [CONTRACTCX] IS NOT NULL;

HELP!!!

--
JenISCM


Ken Sheridan said:
As the dates are in separate columns in the table to group them by month
you'll need to get the year and month for each into the same columns in the
query on which the report is based so you can group by them. You can do this
with a union query, e.g.

SELECT [Contract], [Contract Signed], [Cancelled], [Contact Amount],
YEAR([Contact Signed]) AS TransactionYear,
MONTH([Contact Signed]) AS TransactionMonth
WHERE [Cancelled] IS NULL
UNION ALL
SELECT [Contract], [Contract Signed], [Cancelled], [Contact Amount],
YEAR([Cancelled]), MONTH([Cancelled])
WHERE [Cancelled] IS NOT NULL;

Group the report on TransactionYear and TransactionMonth columns and give
the latter group a group footer.

In the group footer add two text boxes for the two totals. If by
'totalling' you mean counting the instances of contracts signed and cancelled
per month then for signed contracts you'd use an expression like this for the
ControlSource of the text box:

=Sum(IIf(IsNull([Cancelled]) Or Format([Cancelled],"yyyymm") =
Format([Contract Signed],"yyyymm"), 1, 0))

and for the cancelled contracts:

=Sum(IIf(Not IsNull([Cancelled]), 1, 0))

If by totalling you mean summing some other column, e.g. Contact Amount,
then substitute the name of the column for the 1 constants in the above
expressions.

To open the report for a month or range of months create a dialogue form
with text boxes YearStart, MonthStart and YearEnd and Month end in which the
parameters can be entered as numbers. Add a button to the form with code to
open the report like this:

Const conREPORT = "YourReportNameGoesHere"
Dim strCtriteria As String
Dim dtmStart as Date, dtmEnd As Date

dtmStart = DateSerial(Me.YearStart, Me.MonthStart, 1)
dtmEnd = DateSerial(Me.YearEnd, Me.MonthEnd + 1, 0)

strCriteria = _
"[Contract Date] Between #" & _
"Format(dtmStart,"mm/dd/yyyy") & "# And " & _
"Format(dtmEnd,"mm/dd/yyyy") & "# Or " & _
"[Cancelled] Between #" & _
"Format(dtmStart,"mm/dd/yyyy") & "# And " & _
"Format(dtmEnd,"mm/dd/yyyy") & "#"

DoCmd.OpenReporst conREPORT, _
View:=acViewPreview, _
WhereCondition:=strCriteria

Ken Sheridan
Stafford, England

JenISCM said:
I have a report where I need to report data for the same record in two ways.

I can have a Contract Signed date and a Cancelled date for the same record.

I need to create a report to compare this data monthly – totaling all the
Contract Signed in that month and all the Cancelled items in that month.
(These date can occur in the same OR separate months.)

I also need to be able to run this report for specified time periods. (Ex:
Jan – Jun, or just the month of Dec, etc.)

Any assistance would be GREATLY appreciated.
Click to expand...
Click to expand...
 
D

Douglas J. Steele

Your function calls need to go before the FROM keyword:

SELECT [CONTRACTSIGNED], [CONTRACTCX],
YEAR ([CONTRACTSIGNED]) AS TransactionYear
MONTH ([CONTRACTSIGNED]) AS TrasnactionMonth
FROM [CCLIENT]
WHERE [CONTRACTCX] IS NULL
UNION ALL
SELECT [CONTRACTSIGNED], [CONTRACTCX],
Year ([CONTRACTCX]), MONTH ([CONTRACTCX])
FROM [CCLIENT]
WHERE [CONTRACTCX] IS NOT NULL;


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


JenISCM said:
I am just an intermediate Access user with little SQL knowledge, but the
UNION query sounds like the answer to numerous issues I have with trying
to
filter based on varied dates, so I tried to recreate using my data (note:
I
have multiple tables so I specified the from)

SELECT [CONTRACTSIGNED], [CONTRACTCX]
FROM [CCLIENT]
YEAR ([CONTRACTSIGNED]) AS TransactionYear
MONTH ([CONTRACTSIGNED]) AS TrasnactionMonth
WHERE [CONTRACTCX] IS NULL
UNION ALL
SELECT [CONTRACTSIGNED], [CONTRACTCX]
FROM [CCLIENT]
Year ([CONTRACTCX]), MONTH ([CONTRACTCX])
WHERE [CONTRACTCX] IS NOT NULL;

I keep getting a syntax error - what is wrong with my formula???

OR I tried:

And I get a syntax error that formua contains a reserved word:
SELECT [CONTRACTSIGNED], [CONTRACTCX],
YEAR ([CONTRACTSIGNED]) AS TransactionYear
MONTH ([CONTRACTSIGNED]) AS TrasnactionMonth
WHERE [CONTRACTCX] IS NULL
UNION ALL
SELECT [CONTRACTSIGNED], [CONTRACTCX]
Year ([CONTRACTCX]), MONTH ([CONTRACTCX])
WHERE [CONTRACTCX] IS NOT NULL;

HELP!!!

--
JenISCM


Ken Sheridan said:
As the dates are in separate columns in the table to group them by month
you'll need to get the year and month for each into the same columns in
the
query on which the report is based so you can group by them. You can do
this
with a union query, e.g.

SELECT [Contract], [Contract Signed], [Cancelled], [Contact Amount],
YEAR([Contact Signed]) AS TransactionYear,
MONTH([Contact Signed]) AS TransactionMonth
WHERE [Cancelled] IS NULL
UNION ALL
SELECT [Contract], [Contract Signed], [Cancelled], [Contact Amount],
YEAR([Cancelled]), MONTH([Cancelled])
WHERE [Cancelled] IS NOT NULL;

Group the report on TransactionYear and TransactionMonth columns and give
the latter group a group footer.

In the group footer add two text boxes for the two totals. If by
'totalling' you mean counting the instances of contracts signed and
cancelled
per month then for signed contracts you'd use an expression like this for
the
ControlSource of the text box:

=Sum(IIf(IsNull([Cancelled]) Or Format([Cancelled],"yyyymm") =
Format([Contract Signed],"yyyymm"), 1, 0))

and for the cancelled contracts:

=Sum(IIf(Not IsNull([Cancelled]), 1, 0))

If by totalling you mean summing some other column, e.g. Contact Amount,
then substitute the name of the column for the 1 constants in the above
expressions.

To open the report for a month or range of months create a dialogue form
with text boxes YearStart, MonthStart and YearEnd and Month end in which
the
parameters can be entered as numbers. Add a button to the form with code
to
open the report like this:

Const conREPORT = "YourReportNameGoesHere"
Dim strCtriteria As String
Dim dtmStart as Date, dtmEnd As Date

dtmStart = DateSerial(Me.YearStart, Me.MonthStart, 1)
dtmEnd = DateSerial(Me.YearEnd, Me.MonthEnd + 1, 0)

strCriteria = _
"[Contract Date] Between #" & _
"Format(dtmStart,"mm/dd/yyyy") & "# And " & _
"Format(dtmEnd,"mm/dd/yyyy") & "# Or " & _
"[Cancelled] Between #" & _
"Format(dtmStart,"mm/dd/yyyy") & "# And " & _
"Format(dtmEnd,"mm/dd/yyyy") & "#"

DoCmd.OpenReporst conREPORT, _
View:=acViewPreview, _
WhereCondition:=strCriteria

Ken Sheridan
Stafford, England

JenISCM said:
I have a report where I need to report data for the same record in two
ways.

I can have a Contract Signed date and a Cancelled date for the same
record.

I need to create a report to compare this data monthly - totaling all
the
Contract Signed in that month and all the Cancelled items in that
month.
(These date can occur in the same OR separate months.)

I also need to be able to run this report for specified time periods.
(Ex:
Jan - Jun, or just the month of Dec, etc.)

Any assistance would be GREATLY appreciated.
Click to expand...
Click to expand...
Click to expand...
 
J

JenISCM

I copied exactly and still get this error:
"The Select statement includes a reserved word or an argument that is
misspelled or missing, or the punctuation is incorrect."
--
JenISCM


Douglas J. Steele said:
Your function calls need to go before the FROM keyword:

SELECT [CONTRACTSIGNED], [CONTRACTCX],
YEAR ([CONTRACTSIGNED]) AS TransactionYear
MONTH ([CONTRACTSIGNED]) AS TrasnactionMonth
FROM [CCLIENT]
WHERE [CONTRACTCX] IS NULL
UNION ALL
SELECT [CONTRACTSIGNED], [CONTRACTCX],
Year ([CONTRACTCX]), MONTH ([CONTRACTCX])
FROM [CCLIENT]
WHERE [CONTRACTCX] IS NOT NULL;


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


JenISCM said:
I am just an intermediate Access user with little SQL knowledge, but the
UNION query sounds like the answer to numerous issues I have with trying
to
filter based on varied dates, so I tried to recreate using my data (note:
I
have multiple tables so I specified the from)

SELECT [CONTRACTSIGNED], [CONTRACTCX]
FROM [CCLIENT]
YEAR ([CONTRACTSIGNED]) AS TransactionYear
MONTH ([CONTRACTSIGNED]) AS TrasnactionMonth
WHERE [CONTRACTCX] IS NULL
UNION ALL
SELECT [CONTRACTSIGNED], [CONTRACTCX]
FROM [CCLIENT]
Year ([CONTRACTCX]), MONTH ([CONTRACTCX])
WHERE [CONTRACTCX] IS NOT NULL;

I keep getting a syntax error - what is wrong with my formula???

OR I tried:

And I get a syntax error that formua contains a reserved word:
SELECT [CONTRACTSIGNED], [CONTRACTCX],
YEAR ([CONTRACTSIGNED]) AS TransactionYear
MONTH ([CONTRACTSIGNED]) AS TrasnactionMonth
WHERE [CONTRACTCX] IS NULL
UNION ALL
SELECT [CONTRACTSIGNED], [CONTRACTCX]
Year ([CONTRACTCX]), MONTH ([CONTRACTCX])
WHERE [CONTRACTCX] IS NOT NULL;

HELP!!!

--
JenISCM


Ken Sheridan said:
As the dates are in separate columns in the table to group them by month
you'll need to get the year and month for each into the same columns in
the
query on which the report is based so you can group by them. You can do
this
with a union query, e.g.

SELECT [Contract], [Contract Signed], [Cancelled], [Contact Amount],
YEAR([Contact Signed]) AS TransactionYear,
MONTH([Contact Signed]) AS TransactionMonth
WHERE [Cancelled] IS NULL
UNION ALL
SELECT [Contract], [Contract Signed], [Cancelled], [Contact Amount],
YEAR([Cancelled]), MONTH([Cancelled])
WHERE [Cancelled] IS NOT NULL;

Group the report on TransactionYear and TransactionMonth columns and give
the latter group a group footer.

In the group footer add two text boxes for the two totals. If by
'totalling' you mean counting the instances of contracts signed and
cancelled
per month then for signed contracts you'd use an expression like this for
the
ControlSource of the text box:

=Sum(IIf(IsNull([Cancelled]) Or Format([Cancelled],"yyyymm") =
Format([Contract Signed],"yyyymm"), 1, 0))

and for the cancelled contracts:

=Sum(IIf(Not IsNull([Cancelled]), 1, 0))

If by totalling you mean summing some other column, e.g. Contact Amount,
then substitute the name of the column for the 1 constants in the above
expressions.

To open the report for a month or range of months create a dialogue form
with text boxes YearStart, MonthStart and YearEnd and Month end in which
the
parameters can be entered as numbers. Add a button to the form with code
to
open the report like this:

Const conREPORT = "YourReportNameGoesHere"
Dim strCtriteria As String
Dim dtmStart as Date, dtmEnd As Date

dtmStart = DateSerial(Me.YearStart, Me.MonthStart, 1)
dtmEnd = DateSerial(Me.YearEnd, Me.MonthEnd + 1, 0)

strCriteria = _
"[Contract Date] Between #" & _
"Format(dtmStart,"mm/dd/yyyy") & "# And " & _
"Format(dtmEnd,"mm/dd/yyyy") & "# Or " & _
"[Cancelled] Between #" & _
"Format(dtmStart,"mm/dd/yyyy") & "# And " & _
"Format(dtmEnd,"mm/dd/yyyy") & "#"

DoCmd.OpenReporst conREPORT, _
View:=acViewPreview, _
WhereCondition:=strCriteria

Ken Sheridan
Stafford, England

:

I have a report where I need to report data for the same record in two
ways.

I can have a Contract Signed date and a Cancelled date for the same
record.

I need to create a report to compare this data monthly - totaling all
the
Contract Signed in that month and all the Cancelled items in that
month.
(These date can occur in the same OR separate months.)

I also need to be able to run this report for specified time periods.
(Ex:
Jan - Jun, or just the month of Dec, etc.)

Any assistance would be GREATLY appreciated.
Click to expand...
Click to expand...
Click to expand...
 
D

Douglas J. Steele

Sorry, I didn't notice there was no comma after TransactionYear (the perils
of copy-and-paste!)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


JenISCM said:
I copied exactly and still get this error:
"The Select statement includes a reserved word or an argument that is
misspelled or missing, or the punctuation is incorrect."
--
JenISCM


Douglas J. Steele said:
Your function calls need to go before the FROM keyword:

SELECT [CONTRACTSIGNED], [CONTRACTCX],
YEAR ([CONTRACTSIGNED]) AS TransactionYear
MONTH ([CONTRACTSIGNED]) AS TrasnactionMonth
FROM [CCLIENT]
WHERE [CONTRACTCX] IS NULL
UNION ALL
SELECT [CONTRACTSIGNED], [CONTRACTCX],
Year ([CONTRACTCX]), MONTH ([CONTRACTCX])
FROM [CCLIENT]
WHERE [CONTRACTCX] IS NOT NULL;


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


JenISCM said:
I am just an intermediate Access user with little SQL knowledge, but the
UNION query sounds like the answer to numerous issues I have with
trying
to
filter based on varied dates, so I tried to recreate using my data
(note:
I
have multiple tables so I specified the from)

SELECT [CONTRACTSIGNED], [CONTRACTCX]
FROM [CCLIENT]
YEAR ([CONTRACTSIGNED]) AS TransactionYear
MONTH ([CONTRACTSIGNED]) AS TrasnactionMonth
WHERE [CONTRACTCX] IS NULL
UNION ALL
SELECT [CONTRACTSIGNED], [CONTRACTCX]
FROM [CCLIENT]
Year ([CONTRACTCX]), MONTH ([CONTRACTCX])
WHERE [CONTRACTCX] IS NOT NULL;

I keep getting a syntax error - what is wrong with my formula???

OR I tried:

And I get a syntax error that formua contains a reserved word:
SELECT [CONTRACTSIGNED], [CONTRACTCX],
YEAR ([CONTRACTSIGNED]) AS TransactionYear
MONTH ([CONTRACTSIGNED]) AS TrasnactionMonth
WHERE [CONTRACTCX] IS NULL
UNION ALL
SELECT [CONTRACTSIGNED], [CONTRACTCX]
Year ([CONTRACTCX]), MONTH ([CONTRACTCX])
WHERE [CONTRACTCX] IS NOT NULL;

HELP!!!

--
JenISCM


:

As the dates are in separate columns in the table to group them by
month
you'll need to get the year and month for each into the same columns
in
the
query on which the report is based so you can group by them. You can
do
this
with a union query, e.g.

SELECT [Contract], [Contract Signed], [Cancelled], [Contact Amount],
YEAR([Contact Signed]) AS TransactionYear,
MONTH([Contact Signed]) AS TransactionMonth
WHERE [Cancelled] IS NULL
UNION ALL
SELECT [Contract], [Contract Signed], [Cancelled], [Contact Amount],
YEAR([Cancelled]), MONTH([Cancelled])
WHERE [Cancelled] IS NOT NULL;

Group the report on TransactionYear and TransactionMonth columns and
give
the latter group a group footer.

In the group footer add two text boxes for the two totals. If by
'totalling' you mean counting the instances of contracts signed and
cancelled
per month then for signed contracts you'd use an expression like this
for
the
ControlSource of the text box:

=Sum(IIf(IsNull([Cancelled]) Or Format([Cancelled],"yyyymm") =
Format([Contract Signed],"yyyymm"), 1, 0))

and for the cancelled contracts:

=Sum(IIf(Not IsNull([Cancelled]), 1, 0))

If by totalling you mean summing some other column, e.g. Contact
Amount,
then substitute the name of the column for the 1 constants in the
above
expressions.

To open the report for a month or range of months create a dialogue
form
with text boxes YearStart, MonthStart and YearEnd and Month end in
which
the
parameters can be entered as numbers. Add a button to the form with
code
to
open the report like this:

Const conREPORT = "YourReportNameGoesHere"
Dim strCtriteria As String
Dim dtmStart as Date, dtmEnd As Date

dtmStart = DateSerial(Me.YearStart, Me.MonthStart, 1)
dtmEnd = DateSerial(Me.YearEnd, Me.MonthEnd + 1, 0)

strCriteria = _
"[Contract Date] Between #" & _
"Format(dtmStart,"mm/dd/yyyy") & "# And " & _
"Format(dtmEnd,"mm/dd/yyyy") & "# Or " & _
"[Cancelled] Between #" & _
"Format(dtmStart,"mm/dd/yyyy") & "# And " & _
"Format(dtmEnd,"mm/dd/yyyy") & "#"

DoCmd.OpenReporst conREPORT, _
View:=acViewPreview, _
WhereCondition:=strCriteria

Ken Sheridan
Stafford, England

:

I have a report where I need to report data for the same record in
two
ways.

I can have a Contract Signed date and a Cancelled date for the same
record.

I need to create a report to compare this data monthly - totaling
all
the
Contract Signed in that month and all the Cancelled items in that
month.
(These date can occur in the same OR separate months.)

I also need to be able to run this report for specified time
periods.
(Ex:
Jan - Jun, or just the month of Dec, etc.)

Any assistance would be GREATLY appreciated.
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding months to a date 5
setting up reoccuring records 3
Can access work with multiple FX rates? 1
parsing from a txt file into a table 2
Caluculate totals 1
sort in report 14
Help with year to month converson 6
Importing Data from Excel when data not in same format 4

Top