I have created a database that will be used as a time tracking function.  I
have it set up so that people will click a button to clock in, which creates
a new record and then they click a different button to clock out that adds
another new record.  I want to get the overall time ...

I have the following simple query with the criteria that one field does not
equal another field. The main table has 20,644 records and I should be
getting 20,626 records in the design view yet nothing comes up.  Here is the
SQL statement:

I'm having difficulty writing a query and was hoping someone could help me
out.
I have a table 'orders' which contains numerous fields, of which 3 are of
particular interest to me 'order_status', 'clientid1' and 'clientid2'. I also

I have a table that has a numeric column "sales" that ranges from 1 to
1,000,000.  In a query, I am attempting to assign a banding marker to each
record.  I have 200 bands so an IIf statement won't work.  
So for instance, one of the 200 bands that is >=22 and less than 29 called

First some background, I have two tables called 2007 Grid and 2008 Grid, in
these tables I have a field called Census Rec'd.  
For my query, I need to create a field called Census Rec'd and I need this
field to do the following - If "Plan Year" ends in 2007 from "AFTAP Table"

I created a table that will allow the user to assign similar items to the
currently viewed item.  It works almost as planned.
For example: If a user adds a record that says"Item A" is similar to "Item
B", "B" will be displayed in lstSimilarItems on "A's" record.  

I have a column that is for Page Numbers, and this particular table contains
a letter in addition to the page number.   Here are examples:
1A
3A

Here is part of my query (a column from the query builder window)..
ChildsLocation: (SELECT "(" & IIf([HomeType] Like
"Resident*",IIf(IsNull([HomeName]),[HomeType],[HomeName]),[HomeType])
& ")" FROM ChildsLocationTable WHERE

I'm trying to execute an append query (qapdCopy&PasteProperties) with
visual basic, but I get an error.
Run-time error ''
Syntex error in INSERT INTO statement.

I'm joining two table in a query.  One field is text, and the other is a
memo field.  It won't let me run the query. How can I get around this?
Thanks for you help,
Joel

I want to be prompt to give a value for the Sum of CounOfX. For example
query should ask me to give a value and show me only the group sums equal or
more than that given value. I hope i could explain it.
SELECT qry_d2.Kunde, Sum(qry_d2.CountOfKunde) AS SummevonCountOfKunde

I have a TRANSFORM query
TRANSFORM Sum([dbo_SalesQuery].[aantbest]) AS SumOfaantbest
SELECT [dbo_SalesQuery].[cddeb], Sum([dbo_SalesQuery].[aantbest]) AS Totaal
FROM dbo_SalesQuery

Please help me to write an append query that will append records from one
table to multiple tables that have an inner join operation
Thank you

I would like some help please building a query that will return the
numbers only contained in a field:
Table "PurchaseOrder" has a "Memo" field that usually has the
following data: "Sales Order 7540:" or "Sales Order 34:".

I am trying to create a query to calculate the flow time for each order, but
not sure what the formula to use. The flow time is the difference between the
completed date and date received (Calculating exclude weekend and holiday).
The problem is there are several operations for ...