I have a query that currently looks like this:
SELECT district, account, name
FROM DNSData
WHERE district in ("Districtname",etc)

I have the following table:
Client     D1     D2       D3       D4              D5
A        Yes      Yes       No         No              No
B      No       No       Yes         No              No

hi i have my data organized in a table like this,
pID  itemType
and i might have records like this in the table
11    Chart

Re: a query in Access.  I want to exclude two descriptions in a field, i.e.,
I have a Division field and I want to exclude "void" and "voidbus".  Help!

I have data coming from an ODBC connection which comes in as text format in
the format ccyymmdd. I need to convert this to dd/mm/yyyy with a format of
date/time in a table outputting from a make table query.
I can easily get the form dd/mm/yyyy with some concatenation, but want to ...

The columns in a crosstab query are generated automatically, and sorted
alphabetically, even though the field's data type is Date/time.
How do I make the query sort the columns in date order?
Thanks.

I trying to retrieve values from a table to calculate the 14days average
value of a stock closing price. However, i encounter some problem as stated
beside the code as follows:
Function DaysAvgs()

I have created a query that reads an external dBASEIII file. The field I want
to sort on contains numeric values. However the dBASE file has the field
defined as "text".
My query returns a sort which is like the following"

I'm running a query and have the "date" field  criteria set to prompt for the
date...the criteria is [What Day?  Example 05/29/07].  I have thousands of
records and am keying an applicable date but nothing is being returned.  If I
delete the date criteria, the query runs ...

I'm sure this would be a common requirement
I have a table (imported from excel) that is a pricing grid for
blinds. The header row at the top is widths(mm) and the header row
down the left is heights(mm). The data is the price for each

Thanks to all in advance for reading and replying to this.  In a query
I need to make sure one of the fields follows a format of ##-
Anything    The first two digits can be any number 0-9 followed
directly by "-" which can be followed by anything for example:

I have a table that i would like to update with results of a seperate query
I  would like to update
table1.Title with query.title
table1.quantity with query.quantity

hi to all! good day :)
Please help me send out a report to email with specific page only. i cant do
it n the argument using macro.
i tried sending out to email  but i received all the reports.. i need only

Hello, and thanks in advance for your help.
I have a form that has a button. This button calls an update query. The
problem is that the update query runs on all records and not just the current
record. And I do not know how to tell the query to run only for the current

I have a table with account information. One of the fields is Account_Status,
there are 6 possible choices for account status going from 1 - 6. Wha I'd
like to do is run a qurey where the user can choose to return accounts with
status 4 or 6. Any help appreciated. I can use ...