Adding a column in report

[hasanainf]

Hi,

Need help on this report

My report displays as follows

Receipt Number Checkout Date Payment Date
13580 30-06-2005 02-07-2005
13581 01-07-2005 02-07-2005

I want my report to show as follows

Receipt Number Checkout Date Payment Date Status
13580 30-06-2005 02-07-2005 Debit
13581 01-07-2005 02-07-2005 Cash

Note: An additional column has been added to indicate the status, also
note that I am using a british date.

If the month of payment date is greater than the month of check out
date than status field should show Debit and if the month of payment
date is the same as checkout date than the status field should show
cash.

I don't know if this is done in report using VBA or underlying query.
I will use the status field to group my results, grouping debit
separately and cash separetly.

All the help is highly appreciated and thanking you all in advance.

[Randy Harris]

<ha*******@yahoo.com> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...

Hi,

Need help on this report

My report displays as follows

Receipt Number Checkout Date Payment Date
13580 30-06-2005 02-07-2005
13581 01-07-2005 02-07-2005

I want my report to show as follows

Receipt Number Checkout Date Payment Date Status
13580 30-06-2005 02-07-2005 Debit
13581 01-07-2005 02-07-2005 Cash

Note: An additional column has been added to indicate the status, also
note that I am using a british date.

If the month of payment date is greater than the month of check out
date than status field should show Debit and if the month of payment
date is the same as checkout date than the status field should show
cash.

I don't know if this is done in report using VBA or underlying query.
I will use the status field to group my results, grouping debit
separately and cash separetly.

All the help is highly appreciated and thanking you all in advance.

Are CheckoutDate and PaymentDate stored as dates?

[pietlinden]

Status:
=IIF(Month([Payment Date])>Month([Checkout Date]), "Debit","Cash")

You could just create an unbound calculated control and put the formula
in the rowsource...

[MacDermott]

This might need some modification do deal with year end...

<pi********@hotmail.com> wrote in message
news:11*********************@g47g2000cwa.googlegro ups.com...

Status:
=IIF(Month([Payment Date])>Month([Checkout Date]), "Debit","Cash")

You could just create an unbound calculated control and put the formula
in the rowsource...

[hasanainf]

Yes, CheckoutDate and PaymentDate are stored as dates

[hasanainf]

Thanks pietlin, that worked fine