I have an inventory database, in one query i want to show total parts in stock.
the tables I have are  TblAcq  ( main inventory ) and WOCheckout ( Parts
going out to a jobsite )   When I tell it to use the "In Stock" from TblAcq  
minus the "Quantity" from WOCheckout  i ge the ...

I have a crosstab query that uses the between (two dates) function.
The query works fine but when I try to create a report out of it it
says that the row source is incorrect and will not create the
(tabular) report. Is there any way of fixing this?

Help help help!  Please... :)
Okay, I need to get a list of clients we've processed an order for during a
certain time period. The table lists each item a client had on their order,
so I will get multiple listings for a given client. I just would like the

I am trying to filter my query to show only the values that do NOT end in
.00.  I've tried Not Like ("*.00") and other variations of that, but it
doesn't work.  I have a feeling it's possibly because the format is a number
and not text, but I'm not sure how to fix it.  Can anyone ...

I have an application where I need to generate sequential number in the
range 1-99999.  I have a table which will have one column storing these
numbers.
tblSeqNumbers

I need to create a indicator field that will look at a field and see if it
has a certain code in it and then return a Y or N.
I was thinking that I could use an IIF to look at the field and if it
contains a "C" or "P" or and "S" (using Like function?) then the field would

I have a query that has the following sql code all it is doing is updating
another table from a data push.  It worked up till this weekend now I am
getting an error when I try to run it that says "The seach key was not found
in any record.

i want to view report based on employee ID and by year selected.
I created report depend on table query.
what commad/SQL command for view employee by employee_ID and year ?
Screen input data

I am building a database that will track employee training. I need to know
how to build an expression that will return only those employees who's
training is out of date. Meaning that their training date is more than 365
days old.

Below are my table:
Main Table
PartNumber(pk)
Incoming

I have only 2 fields and want to change rows to column headings.  My table
looks like this:
ColA  ColB
N1      1

Hi. I have a database that keeps patient followup information for outcomes
after treatment for cancer.
One of my tables has multiple rows of data (toxicity followup) per person
for distinct dates (clinic visits). I am trying to build a query in design

Dear Sir,
I am using Visual Basic 6, Microsoft Access 2000 & ADO 2.5.
In my table there are 140 fields. I am Using UPDATE Query to Update Value of
Fields & INSERT Query to Insert Record in Table. I Update & Append only one

My database has only two columns and when I write a query I display only one
of them. The displayed query is about 8 inches wide. How do I reduce the
width of this displayed query? TIA.

Access 2003
If I have a table like this with fields and data like this:
Table1
Acct - Name ------ value1 - value2 - value3