Adding a column in report

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.

.

Relevant Pages

  • Re: Ledger for Individual Customers
    ... The form will have 2 unbound text boxes, and a command button that opens the report. ... The report that lists any orders and any payments in that period, based only on the OrderDate and PaymentDate, regardless of whether the payment is for an order in that period or not. ... Life time transcations of a particular customer (right from day one the ... > Ship Address ...
    (microsoft.public.access.reports)
  • Re: Report based on calculations of 2 records
    ... Is there no other way to generate the report from my existing records? ... When a customer makes a payment, ... PayFrom and PayTo on reports. ...
    (microsoft.public.access.reports)
  • Re: Subreport not displaying all info
    ... If the subreport is in the report footer and is linked on the Paymentdate ... If you want to show a range of payment dates in the subreport, ...
    (microsoft.public.access.reports)
  • Re: Subreport not displaying all info
    ... same information for the same time-frame as the main report. ... the subreport will only contain records from the last ... If you want to show a range of payment dates in the subreport, ... If I change the link to reflect customer number, ...
    (microsoft.public.access.reports)
  • Re: Ordering dates in a report
    ... Put the IIf statement in the underlying query, ... Doug Steele, Microsoft Access MVP ... payment dates, please let me know. ... and generate the report, I simple enter the month number (1 for Jan, 2 ...
    (microsoft.public.access.gettingstarted)