Re: Is this possible

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

From: Veign (NOSPAMinveign_at_veign.com)
Date: 12/01/04 

Date: Wed, 1 Dec 2004 14:14:24 -0500

Adding to the other post.

When you are unsure of a more complex SQL statement try opening Access and
use the Query creator to get you started. Not always the best SQL but lets
you know if it can be accomplished (in Access at least).

Also, you should look into Normalizing a database (search Google) as a truly
normalized database would allow most required data to be retrieved with SQL
statements. 

-- 
Chris Hanscom - Microsoft MVP (VB)
Veign's Resource Center
http://www.veign.com/vrc_main.asp
--
"Jeff Thur" <anonymous@discussions.microsoft.com> wrote in message
news:042301c4d7d3$b91970a0$a301280a@phx.gbl...
> I'm not sure how to do this, or if this is even possible.
>
> I need to create a Tabulations application that can do
> the following:
>
> Need to get the number of records that meet the criteria
> that a user enters from an input screen. Multiple States
> from a field, Multiple Zip Codes From another field,
> Multiple Codes from another field, Multiple Dates from
> another field, then only those that will have or not have
> email addresses, fax numbers and phone numbers.
> I don't think that this can be done with SQL Statements.
> Is there anyway? If so how can this be achieved?

Relevant Pages

  • Re: HELP WITH UPDATE QUERY
    ... each selected items in the list, and, in the example, make an SQL statement ... the user wants to select MULTIPLE items from this list ... query named qrProd and the list box is from that same query, ... I ASSUMED the control name was. ...
    (microsoft.public.access.queries)
  • Re: Idea of SQL integration
    ... this issues like compiler directive e.g. ASM. ... is no general solution for multiple DB vendors (sas for multiple ... It gets a SQL statement and another parameter: Open, Execute, ExecuteAndFree. ...
    (borland.public.delphi.non-technical)
  • Re: Conditional test to combine multiple records
    ... >> current sql statement. ... (or just switch to the query grid and do the ... >>> one record becaue I count the total number of shipped orders in another ... >>> over the course of multiple dates. ...
    (microsoft.public.access.queries)
  • Re: confusing transactions with sqldmo
    ... > Like I said, when running from many different Query Analyzer windows, ... I don't think just because you are running multiple threads you can run ... one SQL statement per connection unless ... one SQL statement per connection. ...
    (microsoft.public.sqlserver.programming)