By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,825 Members | 1,026 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,825 IT Pros & Developers. It's quick & easy.

Adding a column in report

P: n/a
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.

Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a

<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?
Nov 13 '05 #2

P: n/a
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...

Nov 13 '05 #3

P: n/a
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...

Nov 13 '05 #4

P: n/a
Yes, CheckoutDate and PaymentDate are stored as dates

Nov 13 '05 #5

P: n/a
Thanks pietlin, that worked fine

Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.