Impossible query?

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

From: Mark (memiller_at_westernsurety.com)
Date: 09/18/04

  • Next message: Adam Machanic: "Re: Impossible query?" 
    Date: 17 Sep 2004 17:15:03 -0700

    I am setting up a United Way fund-raising raffle where my co-workers
    will sign-up via webpage, results stored in a SQL table. What I want
    to do is base the number of chances on the amount given. Example,
    someone who gives $1 to $25 gets one chance, $25 to $50 gets two
    chances, and so on.

    Now for the problem: I need to create a report (query) that will list
    the employee's name as many times has he/she has chances in order to
    create the "tickets". We use Crystal Reports if anyone has an idea
    that would involve the report generator.

    - Mark

  • Next message: Adam Machanic: "Re: Impossible query?"

    Relevant Pages

    • Re: Populating a list -- table structure?
      ... I had made a report already and figured out about adding the ... your responce below, but thanks to your help with SQL, I was able to get the ... It takes a summary from a select query and gives the ... KitID, long integer ...
      (microsoft.public.access.forms)
    • Re: SCAN.EXE - McAfee AntiVirus Software
      ... > | of network computers and have only report summaries sent to be via ... > | Virus Scan Report File ... > | application RemoteProcessLaunch. ...
      (microsoft.public.security.virus)
    • Re: Populating a list -- table structure?
      ... I don't mean to skip your responce below, but thanks to your help with SQL, I was able to get the query to pull the info the way I needed. ... I have one report complete, ... Queries (just shows the QBE grid for convenience -- ...
      (microsoft.public.access.forms)
    • Re: Populating a list -- learning Access
      ... It is kinda funny -- I started using databases in the early 80's with dBase and, for years, never knew that I knew SQL! ... If you are on a form or report, the most important property is the NAME, because that is how you refer to it in code. ... I don't mean to skip your responce below, but thanks to your help with SQL, I was able to get the query to pull the info the way I needed. ... Queries (just shows the QBE grid for convenience -- ...
      (microsoft.public.access.forms)
    • Re: Problems adding "All" to combo box
      ... SQL for each combo box is in a previous post). ... You have a report defined that is named AI Thru Hole Work Log_Operator ... of the report or form you want to filter ...
      (microsoft.public.access.formscoding)