I've Orders and Agents tables joint in a query. The Agents table has
AGENT_ID and MNGR_ID. The query pulls the monthly orders per Agent. Some
Agents have sub Agents and I differentiate them with the MNGR_ID. So what I
need to accomplish is to pull the orders of all the Agents and ...

I'm having a problem with a query.  I have two times, a TimeFinished and a
TimeStart.  The senerio is that I have a room that could be used multiple
times during a day.  What I'm trying to do with my query is see how much time
in minutes elapse it takes from the time a group ...

How do you print date picture was taken with the picture?

I'm trying to drop and create a table in access 2003, but I keep getting a
syntax error.  What is the correct sql code to use?
Thanks,
Akilah

Hi again,
Ok, new question.  I need to find information for the last milestone passed.
Now I have a table like this
Main table:

************Introduction:***********
Have a database to a company, where i store the entities contacts and
data in a table Company_Table, that links to another Table
AgentSegment_Table, that serves the pourpose to create a surrogate key

I currently use a parameter query (in an Access query grid) that has a pop-up
that asks for a date. Is there a way to have it automaticly use today's date
if the user leaves the pop-up parameter blank? Almost all the time we are
dealing with today's date. We have plenty of ...

I have a column in my table called Record #.  I need to perform queries on a
regular basis which include specific Record #'s.  So I may need to select
over 200 specific record numbers in a query.  This is turning into a
nightmare.  Firstly, in design view I'm manually typing:

I have a question that I really have no idea how to resolve.  I am working
on a database that I have read-only access to.  The problem is is that I dont
think it was designed very well.  There is a specific field that should
connect 2 tables.  Unfortunately, in one of the tables ...

I would like to know of a query that will tell me the type of each query
within a database, AND what tables/fileds it updates/makes.
OR
query each table within a database and have it tell me all of the queries

Hello everyone!  Using A02 on XP.  Not a programmer but lovin' learnin'!
I have a little DB that I'm using to import .txt file from our system,
replace SSN's with "000000000" and add an AutoNum ID field (for privacy
issues) then spit out .xls file to a client for editing, we then ...

I have a query as below:
-------------------------------------------------
SELECT SLEEP2.FamID, SLEEP2.ResID, SLEEP2.Salutation, SLEEP2.Add1, SLEEP2.
Add2, SLEEP2.Add3, SLEEP2.Add4, SLEEP2.Add5, SLEEP2.Country, SLEEP2.PostCode,

I have the below function I used yesterday without issue. I'm using it in a
query. Today I get an Undefined Function error. I know this function was
harvested from an Access 97 MDB. Yet, it worked fine yesterday. I have the
following references checked and have included the query ...

How do I limit the following query to max 10 scores eliminating the ties on
the high side?
SELECT tbl_Last20.[Contact ID], tbl_Last20.Score_ID, tbl_Last20.Differential
FROM tbl_Last20 INNER JOIN Members ON tbl_Last20.[Contact ID] =

Hello;
I have a table having 2 fields:DID,dName.Although DID is a unique field,the
table's PK and a Long accending number,but its numbers are not followingly.I
mean the 8th record may have DID=8 but for the 9th record DID=10 and for the