RE: Extract certain Columns for Report

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

Can you tell us anything about your fields? It isn't clear what you are
attempting to do. You may have been working on this for weeks but we don't
have a clue what you actually have and need.

--
Duane Hookom
Microsoft Access MVP


"phuser" wrote:

I have a linked table in Access that is a chart of Accounts View, I have
created a query that calculates everything in regards to departments and
such but because the column headings are what I need to filter for reports
(grab 3 columns associated to November or the 3 columns associated to
December....) is what is needed, I just dont know what to do, I tried sql
case and failed horribly with syntax errors so I hoping posting in the
reports ng will bring some resolve, been working on this thing for weeks. A
macro, a query, vba..... Any suggestions would be greatly appreciated.

Desperatly seeking solution.........




.

Relevant Pages

  • Re: Permutations - 8 columns
    ... In that case I might still suggest SQL, but in your case use the Excel ... SQL driver and run the query on your extracted data. ... Dim rs As ADODB.Recordset ... > and multiple reports need to be run to see ...
    (microsoft.public.excel.programming)
  • Re: querydef and the DoCmd.OutputTo method
    ... Re-writing the SQL property of the QueryDef is probably the easiest way. ... the ORDER BY clause), so it builds the WHERE clause and patches them ... I have several reports that are based upon a couple of large tables. ... contains all the query defs and this is a big query. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Form --> Query
    ... > in an SQL query with VBA code. ... > experience) with using VBA code. ... >>>>> I need to run similar reports from each. ...
    (microsoft.public.access.forms)
  • Re: Data Type Mismatch In Criteria expression error when make-table query runs [1/1]
    ... It seems you are using html e-mail format. ... Without being able to see your SQL it is not possible to be more specific. ... selection) for the actual reports. ... the sql of the query is attached. ...
    (microsoft.public.access.queries)
  • Re: Syntax error in INSERT INTO Statement
    ... I dont know what was wrong in my code ... running the query ... >keep a QueryDef set up as an SPT and stuff it w/ an SQL ... >> OrderHeaderId, OrderDetailId, CreatedDate, CreatedBy)" ...
    (microsoft.public.access.queries)