I have a main table. From this main table I have created a query (qryexclude)
with a list of names and name id's that I don't want from the main table.
How do I create A new query to search the main table but not include names
that match my qryexclude?

I have created  a join between two tables: tableA and tableB. Both the tables
are identical in structure. Table a lists the data for January and table B
lists the data for the whole year (previous). The tables are joined on loan#
and Order#. There is a possibility that TableB has ...

Here is the scenario. I have a list of numbers and due dates. I need to
create a query and an IIF statement. The IIF statement has to say:
iif([number list]=**-****1, "12/31/2006")
number list    

Hello~
I am looking for some assistance in building a query or designing a module.
I would like to calcuate the number of shifts between a date/time stored in
a table and the current date/time.  It would also be helpful if the formula

Sorry if this is answered elsewhere, but I couldn't figure out a search
phrase that gave me an answer.
The database has a field containing strings.
I want to create a query using>  LIKE "*this*"  <where "this" is a prompted

Hello -
I have a query in which the table I am pulling in has a field that describes
the time in a large amount of seconds.
For Example, 1143417600 = 12:00 AM 3/27/2006

Hello people, is there any way to cause the Ccur() function to round to two
decimal places??
As I have a query that has the InvoiceTotal expression,
InvoiceTotal: CCur([TotalNett]*([VatValue]/100+1))

I have set up an Access database for c.v's which works well, but I need more
information on each line (entry) without moving screen to right and left
constantly. Can I have information come up in boxes when the cursor passes
over a cell? Borland Paradox did this years ago, but I ...

I am using the IIF function to show the data in one of two fields.
Exp1: iif([FLD1]=null,[FLD2],[FLD1])
What I want to happen, is to see the data found in FLD2 if FLD1 is blank,
else it will show data in FLD1.

Following is the SQL from a query where I have inserted in the criteria
section of a field of the query (Dealer Name) Not "Skyland Equipment".
However, the name still pulls forward when the query is run.  The spelling
is correct.  Am I typing it correctly?  There is no problem in ...

I have a column that has Account Numbers with Leading 0s. It is currently a
"Text" field. I want to convert it into a "Number" filed. When I do that by
changing the data type I lose the Account Numbers. Is there a workaround?
PS: I need to link this filed to another table that ...

I am trying to add two fields from another query together in a query.  I
want to add the fields together - [qry_AB_Metrics_4].[1
Critical]+[qry_AB_Metrics_4].[2 High] but there is a problem.  If the
Critical and High values are 8 and 6 respectively - the total is 86 not 14.

How can I, in an IIF statement, create the outcome to show in red?
ErrorbyPerson:IIF(table)!(field)=-1,"name"))
I want the "name" to appear in red in the query.
Is it possible?

what is the correct criteria in a query for searching records with current
date only.
like 03/29/06 and nothing before or after that date on 03/29/06?(automatic
for todays date, 03/30/06 for tomorrow, etc....)

I have a formula that works fine in a select query:
SELECT (([dayup]+[timeup])-([daydown]+[timedown]))*24 AS HD,
WORKORD.DAYDOWN, WORKORD.TIMEDOWN, WORKORD.DAYUP, WORKORD.TIMEUP,
WORKORD.MACHID, WORKORD.WONO