Re: Permutations - 8 columns

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

sanshah01_at_yahoo.com
Date: 02/21/05 

Date: 20 Feb 2005 21:01:50 -0800

Tom,

You are 100% correct in your assumption. We are not allowed to query
the database directly and exact the information in a tabular form.

However there are standardised reports which we can use to extract the
data. The only problem is that the output is in a report format
(predefined presentation) and multiple reports need to be run to see
the whole picture.

The irony is that though we are allowed to see the information(whatever
we want) in a report format, we are not allowed to exact the info
through SQL in a database format inorder to analyse it in the way we
want and not in the rigid standarised reports already available.

Regards
Sandip.

Tim Williams wrote:
> I took the OP's explanation to mean that owing to the "financial"
> (sensitive?) nature of the data they were not permitted to make
> complete "copies" of the data by extracting it whole...
>
> Tim.
>
>
> "Tom Ogilvy" <twogilvy@msn.com> wrote in message
> news:eIKcyK5FFHA.548@TK2MSFTNGP14.phx.gbl...
> > >We are not allowed to extract the information directly from the
> > >database
> >>in a tabular form.
> >
> > I suspect if he could query the database, he wouldn't need the
> > combinations.
> >
> > Sounds like he is blindly querying the database with all possible
> > combinations to get back any possible results that may exists.
> >
> > Just my guess of course.
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> > "Tim Williams" <saxifrax@pacbell*dot*net> wrote in message
> > news:On92jq4FFHA.2568@TK2MSFTNGP10.phx.gbl...
> >> Since you're using a database, why not just let SQL do the work ?
> >>
> >> select t.Period, t.account, t.currency, t.code, t.country,[other
> >> columns here], sum(t.amount),average(t.amount)
> >> from DataTable t
> >> group by
> >> t.Period, t.account, t.currency, t.code, t.country,[other column
> >> here]
> >>
> >> Unless I misunderstand your explanation that should give you the
> >> desired result.
> >>
> >> Tim.
> >>
> >>
> >> <sanshah01@yahoo.com> wrote in message
> >> news:1108890725.056729.169580@g14g2000cwa.googlegroups.com...
> >> > Hi,
> >> >
> >> > I have gone through various posts in this group for the solution

> >> > of
> >> > a
> >> > permutation I require but could not find one.
> >> >
> >> > The data I have is as follows in eight columns
> >> >
> >> > Col A Col B Col C Col D Col E ............ etc
> >> > Period Account Currency Code Country ....... etc
> >> > Nov-04 99700 USD 1234 USA
> >> > Dec-04 51000 2270 EUR
> >> > 61000 2568 IND
> >> > 38000
> >> >
> >> > I need to have a macro which would give me a combination of data

> >> > in
> >> > various columns into a database format. There can be additions
to
> >> > the
> >> > information in some of the columns for eg. incase a new account
> >> > is
> >> > created.
> >> >
> >> > The output on another sheet needs to be as follows
> >> >
> >> > for eg.
> >> > Col A Col B Col C Col D Col E ............ etc
> >> > Period Account Currency Code Country ....... etc
> >> > Nov-04 99700 USD 1234 USA
> >> > Nov-04 99700 USD 1234 EUR
> >> > Nov-04 99700 USD 1234 IND
> >> > Nov-04 99700 USD 2270 USA
> >> >
> >> > Let me provide a background on why I am following this process
> >> > since
> >> > if
> >> > someone has a better suggestion for arrive at the end result, I
> >> > am
> >> > open
> >> > for it.
> >> >
> >> > We have a database where all the financial information is
stored.
> >> > We
> >> > are not allowed to extract the information directly from the
> >> > database
> >> > in a tabular form. However using Excel retrieve I am allowed to
> >> > extract
> >> > the information based on various paramaters and unique variables

> >> > of
> >> > each parameter is being listed by me as shown in the first
table.
> >> >
> >> > After having a permutation of various cols and parameters, I
will
> >> > be
> >> > adding an amount column which would provide the information
> >> > retrieved
> >> > based on the unique combination of 8 columns / 8 parameters.
> >> >
> >> > Anyone's help is highly appreciated.
> >> >
> >> > Regards
> >> > Sandip.
> >> >
> >>
> >>
> >
> >

Relevant Pages

  • Re: Newbie? Do I use Report or Query
    ... Makes reading your database easier! ... Table JobDetails ... Reports are the counterpart of Forms. ... If based on a query, ...
    (microsoft.public.access.gettingstarted)
  • Re: running report cause fatal error- on Win98, not XP
    ... In the final query that the report ... only the more complex reports cause the crash- the others do ... Then compact the database: ... Still in the code window, choose Compile from the Debug menu. ...
    (microsoft.public.access.reports)
  • Re: [PHP] Re: find (matching) person in other table
    ... than, say, 25 or 50, re-run the query and change the letters matched to 4, ... Well, see, if the match isn't exact, it won't return anything. ... Look at the Levinshtein PHP ... There's a lot of unnecessary work you're making PHP and your database do. ...
    (php.general)
  • Re: Take database, copy & edit, have reports reflect changes
    ... >I've tried two different things with the database. ... but the reports wouldn't show my reflections. ... this will be a query selecting *some* fields (not the newly added ... and a Query Design window will ...
    (microsoft.public.access.gettingstarted)
  • Re: SYSTEMS ENGINEER/ VAX-VMS/ CAREER POSITION
    ... System Administration and database admin from NIIT, ... salary details and generate reports and enclosures,and calculates ... Responsibilities: ... Write New programs from user requirements, Programming Changes ...
    (comp.os.vms)