Re: SQL statement inquiry **brain-blocked here** :o(

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

Can you post the SQL of the query that is not working for you? (HINT, Select View: SQL from the menu)


I would expect to see something like the following - which should give you the list you want

SELECT DISTINCT Store, Dept, UPC
FROM [YourTable]
WHERE Store = 'A'



'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================


Dan wrote:
Hello -

I'm totally brain-blocked here. I have a simple table that I'm trying
to execute a simple query from, yet I keep getting repeats and blanks.

My table is basically a column of UPC's, one of STORE's, and a third
for DEPARTMENT.
UPC STORE DEPT
012345 A 14
012345 C 32
987655 A 14
987655 B 17
875543 A 12
875543 B 9
875543 C 12
999988 B 9


What I would like to do is run a query and for "Store A" and have the
output list the UPC and DEPT for that particular store.

Thanks for any help! Happy New Year!
Dan
.

Relevant Pages

  • Re: Forcing index usage...
    ... I'm in a situation where oracle spatial doesn't use a domain index even if I use the index hint. ... But as soon as I add more predicates or nest the query into another one, ... Could you give us an example of the SQL ... Complete with execution plans. ...
    (comp.databases.oracle.server)
  • Re: Involved query / possible over Access assistance.
    ... Also, Standard SQL doesn't include a bit operator, but most SQL products ... read some database design books or articles on the WEB for info on ... However, I want to store ... > I want to then do a query for a given week. ...
    (microsoft.public.access.queries)
  • Re: Need help with hint syntax in SQL Server 2000
    ... the tables in the view but will an index hint propogate or will I have ... SQL 2008:http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx ... The query was a simple query against a view: ... When I coded the index hint the SQL Server plan showed it being used ...
    (comp.databases.ms-sqlserver)
  • RE: Running diferent query with one command
    ... I would create a table that would store this information ... You don't have to "know how to use SQL". ... Query result will look like this. ... Duane Hookom wrote: ...
    (microsoft.public.access.queries)
  • Re: how to access final SQL from parameterized ADO
    ... I want to be able to store the entire sql so ... the need for the original query values. ... Session or Application) and re-use them with the same sql statement (or ... Please reply to the newsgroup. ...
    (microsoft.public.data.ado)