I am using Access 2000.  In a query, I have a date field with this criteria.
It shows only the dates for the last 12 weeks.

Is there a way to do the same thing but I need the query to only show

I am trying to develop a SQL query for a report to list an employees
most recent appraisal.  The two tables I am working with are
tblEmployee and tblAppraisalHistory.  tblEmployee contains all the
things you would expect: name, Employee #, SSA #, address, etc, etc.

I have found the records I need in an umateched records query and now want to
delete them from the table.  I reviewed subqueries but don't understand what
the syntax should be to get these deleted.
Any help would be appreciated.  Thanks in advance for any help you can

I just tried the 2nd example at this url and it starts out as:
Dim Q As QueryDef
http://support.microsoft.com/default.aspx?scid=kb;en-us;135546
..but i get user-defined type not defined.  is this type present in

I have a query where I'm using an Iif statement where the results will be
either text or a number.  So, Format within Properties won't work for me.  
Can the formating of the number be written within the Iif statement so it
shows only 2 decimals.  If so, how?  Here is the ...

I would like to customise the message the user sees when the query is run.
Instead of the standard message I would like to put in something like:
"Are you sure you have sent your report and have saved a copy. Please make
sure as this query will change the status to Completed and ...

According to the MS Access Help there is "no equivalent" for bigint data in
MS Access.  
I am using the SQLServer driver.
Is there a way to display these values as a result from a SQLServer database

I have an Insert sql statement but am strugling with how not to have it
insert any duplicates LOTNUM_72 if already exists.  Any help is
appreciated.
sSQL = "INSERT INTO [LotTrackingHistory] (LOTNUM_72, TNXDTE_72,

I am looking to divide two fields "GainOnSale" and "Principal" and input the
result to a third field "Premium" as a percentage with a decimal to the 100th
place.  Also, I'm not sure where I should put the formula.  Any help is
appreciated.  Thanks.

Can I update a linked file with an update query?  Here's what I'm
trying to do:
CUSTOMER is a linked dbaseIV table.  tblSingleLargeSale (SLS for
short) is an Access Table.

I have a crosstab query that works great, but the columns are not in the
order I want...they are displayed as follows:
TEAM#, TEAM NAME, CATEGORY, VENDOR TYPE, LEG 1 GOAL, % OVER GOAL, ADD'L
POINTS, TOTAL POINTS, POINTS AWARDED, TOTAL OF QTY SHPD, 3/6/06, 3/13/06,

I have a query where i am checking to see if a field is a date. If not then I
default a date to it. Otherwise I use it. I am trying to use this to sort the
query so the results are in date order. It does not return in the right order
when I am testing. Can someone tell me what is ...

I have two tables in Access that need to be connected using UPC codes.
This would be easy to create a relationship if one table didn't have
the buying UPC (Each UPC, Box UPC or Case UPC) and the other didn't
have Each UPC, Box UPC AND Case UPCs.  I need to run a query that ties

I have a query using a where not exists shown below.  This query keeps on
choking when runnning.  It takes around 3 minutes to run on my machine and on
slower PC's it takes forever.  My question is is there an alternative to a
where not exists?  Is there a way I can speed up the ...

Hello, first, I have a lot of questions and feel bad asking silly small Q?'s,
and I'm wondering if there are any books / websites recommended for locating
this type of information, such as the following question?  (I am looking for
a solution to the question too!)  :)