Re: Adding a column in report


<hasanainf@xxxxxxxxx> wrote in message
news:1125462654.045117.251930@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> 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?


.

Relevant Pages

  • Adding a column in report
    ... My report displays as follows ... If the month of payment date is greater than the month of check out ... I will use the status field to group my results, grouping debit ... All the help is highly appreciated and thanking you all in advance. ...
    (comp.databases.ms-access)
  • 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)