I coded this query in SQL:
SELECT DOS, COUNT(CPT)
FROM (SELECT DISTINCT DOS, CPT FROM tblDOS)
GROUP BY DOS

I'm working with data that has a time stamp every time someone has a WorkCode
change or signs out.  Sometimes somebody will work in several different
departments in a single day.  An example of the data is below
PID   Name          WorkCode   Time                             ...

I have a query which sums the invoiced amounts on a purchase order.  If
there is no invoiced amounts, it leaves a blank field.  How do I write the
query so that the blank field is replaced with a zero (0)?
Thanks,

I am trying to update a field based on Lat/Lon 'decimal' numbers, but
whenever I up to another table I get just single whole digits.
This is a sample of the doner data: (tbl_School_Points)
coordinates

I'm kind of new to Access and use it only as point-and-click (I have no idea
about SQL!). I'm trying to create a query, but it isn't producing the right
results.
The data describes sample collections from another of locations, many dates

I have a table called MyCustomers.
For some reason, when I try to create Append query, it doesnt show on the
list of tables.
I know the the table is there and I can select it if I want to create a

Is there anything noticeable about this syntax that should give it reaon to
give the error can't find object?
SELECT [Ideas.*]
FROM [Res-project engineer]

I need your help in constructing a query that reads the data field in the
table, so it only returns the dates asked.
What i need now (and i hope to start gainning enough knowhow to do it miself)
it to bild a query (12 of them) for 1 month.

I am querying the results of a UNION query that joined 2 sets of data
(expenses and revenue).  I want to return all the rows from the UNION query,
but I only want  dollar amounts for those rows that contain 'expenses' (I
later want to do the same thing to deliver 'renenue' rows). ...

Hi Groupies
I have a union query that combines 2 yes/no fields. When I run the query, I
get -1 and 0 instead of Yes and No.
How can I force the formatting to Yes and No?

I am trying to take data from field [Market] and create two fields called
[PLAN_TYPE_NM] and [MARKET_NM].  
The data is text and looks like this:
Market

Can you not set an open criteria in a query for a field set to a General Date?
When I run my query with no criteria, entries are returned.
When I put [Enter Date] in the Criteria nothing is returned.  I have checked
the date to make sure it was just not my error, but the date is ...

I cannot select a column if it has a space.  
------------------------------------------------------------------------------------------
For example, i have a table:
Short name          Code                   Year_Produced

I have a columne (LastName) where there are hypehnated names.  When I use the
strconv function, only the first part of the name gets capitalized.  How do I
write a query or sql to initial capitalizede both parts of the name?  
example:  Smith-thomas vs Smith-Thomas.   Thank you in ...

I have a purchase order table, which shows duplicate purchase orders with a
status of Active (A), Closed (C) and Cancelled (X).  See example below
PO No.        Status            Amount
CIP23          A                  4,500