The new forums will be named Coin Return (based on the most recent vote)! You can check on the status and timeline of the transition to the new forums here.
The Guiding Principles and New Rules document is now in effect.

MS Query is the fucking devil

DeebaserDeebaser on my way to work in a suit and a tieAhhhh...come on fucking guyRegistered User regular
edited May 2010 in Help / Advice Forum
I'm trying to create some .dqy one click files out of some existing report, but I'm running into a problem.

Most of the reports I want to have available as one clicks are monthly/weekly/quarterly. In MS Query I don't seem to be able to declare variables.

The SQL cannot be represented graphically so I can't use parameters...

Is there any basic code that I can use to set shit for quarterly reports? I'm nerd raging too hard to figure out a simple code solution.

Deebaser on

Posts

  • mspencermspencer PAX [ENFORCER] Council Bluffs, IARegistered User regular
    edited May 2010
    I don't know about basic code, but I can write a query for you.

    What tables are you pulling the data from, and what fields do those tables have? And can you describe the fields (data type, and what things they represent)?

    mspencer on
    MEMBER OF THE PARANOIA GM GUILD
    XBL Michael Spencer || Wii 6007 6812 1605 7315 || PSN MichaelSpencerJr || Steam Michael_Spencer || Ham NOØK
    QRZ || My last known GPS coordinates: FindU or APRS.fi (Car antenna feed line busted -- no ham radio for me X__X )
Sign In or Register to comment.