Re: Help!! Combine two identical columns in a table.

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi,
i think you can first make a union query in order to put 2 columns in one,
and then use a cross-tab query with fixed columns

--
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com


"AccessFitz" <AccessFitz@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5745B328-5B57-4996-868F-D63AAD543548@xxxxxxxxxxxxxxxx
> Hi,
>
> I have two combo boxes in a table. Method of Payments and Method of
> Payments #2. These combo boxes have the following options "Check",
> "Wire",
> "Adjustment", and "CC."
>
> Example: 1. Method of Payment = Check and Method of Payment #2 =
> Adjustment.
> 2. Method of Payment = Adjustment.
>
> Is it possible on a form or report to pull identical payments in the same
> column? So if I had a column called Adjustments in the form or report,
> that
> the Method of Payment Amount and Method of Payment #2 Amount would pull
> under
> one column?
>
> I hope that makes sense.
>
> Thanks
> AccessFitz


.

Relevant Pages

  • Re: Help!! Combine two identical columns in a table.
    ... "Alex Dybenko" wrote: ... > i think you can first make a union query in order to put 2 columns in one, ... >> Is it possible on a form or report to pull identical payments in the same ... >> the Method of Payment Amount and Method of Payment #2 Amount would pull ...
    (microsoft.public.access.modulesdaovba)
  • Help!! Combine two identical columns in a table.
    ... Is it possible on a form or report to pull identical payments in the same ... the Method of Payment Amount and Method of Payment #2 Amount would pull under ...
    (microsoft.public.access.modulesdaovba)
  • How to choose later of two or more records
    ... One piece deals with payments by cash and checks, one deals with payments by credit card and wire transfer, all per invoice. ... There does come situations where a single invoice will be payed partially in each category, with DateReceived and a few other details being different for each record. ... I can do it by running a totals query on my union query with MAX, then another query that looks for the record in my union query matching that invoice and that MAXbut that means I am effectively running 4 queries to get my information. ...
    (microsoft.public.access.queries)
  • Re: Amortization Calculation in Excel worksheet
    ... amount, the interest rate, the number of payments per ... & the scheduled payment amount. ... the template will not work unless I enter the loan period ... There is no determined loan period for these ...
    (microsoft.public.excel.worksheet.functions)
  • Re: amortization math
    ... at the initial principal I borrowed, the number of payments I ... the principal, payment amount, number of payments per year, ... It is the nominal annual rate. ... Calculate the periodic rate (probably ...
    (sci.econ)