I have a query that is matching an ID to an ID.  I am looking at the results,
and the ID's are not the same.  How can that be if I'm specifically saying
that I want ID in Query A to match ID in Table B?  It's showing two different
numbers in the results.

I need to create a query. I have 3 columns. "Match column", "Date
column", and "field 1" which counts from 1 to 1000. The numbers in the
"match column" are jumbled around. I need a query that looks through
the match column and matches the number it finds with the field 1

Using Access 2000, I want to figure the number of days in a program during a
specific month, (i.e. March), when the program lasted serveral months (i.e.  
Jan - April).
Example:

I have a table that contains service calls.  I want to show the number of
service calls that were still open at the end of each month.  e.g Jan 06 - 2,
Feb 06 - 3
I have a query :

I want to replicate two fields in my db and pad them with zeros.  For
instance say the old field reads 222, I was a new field to read 000222.  Im
really new with access and IM not sure how clear I even made the question.  
Any advice or tips would be appreciated.

Can I create a query that looks down one column and matches all values
with the values of a second comlumn. Maybe in a third column it wil
display the results. Also is there a way to go through a column and
change all the endings to a column of data automatically without goin

We have a database which has equipment identities stored in a database column
named TAG the identity is made up of a series of letters followed by numbers
examples:
V1234  PC12345 PSV123

I have 8 append queries to append to 8 different tables.  All of the tables
use the same ID or Case Number.  They also all have relationships based off
this case number.  I created a macro that would go through the append queries
one by one but since each query asks the user for ...

Thanks for taking the time to read my question.
I'm wondering how I can concatenate Rows together (not columns).
Current Data:
Name        Child Name

I assumed responsibility for an existing database linked by ODBC to an SQL
Server database.  There is a Pass-Through-Query which refers to two people
identified by a4r6 and UME1..
Could you please just help me understand what it's doing, the previous owner

I have a text field that allows zero length strings, but when I do
searches on it such as:
Where(myField='')
It fails to find anything,

Our fiscal year runs from April 1 to March 31, so it spans two calendar years.
My database records expenses along with the date (i.e., a field for expense
and a field for date).
I want to be able to sum all the expenses during our current fiscal year.  

I am trying to write a query that calculates what school year some one is in
from there date of birth.  The information I have to work with is DOB &
obviously the current date.  The criteria is that A School year is made up
of Children born between 1st September in one year and ...

BothFields: IIf([Remainingshares]="is
null",[Buysellshrs],IIf([Remainingshares]="is not null",[RemainingShares]))
What I am trying to do is
If Remaining Shares are BLANK show BUYSELLSHRS

can someone help me run append query where the date criteria comes from a
dlookup?
qryTimeSheets
fldName