Hi Again {{sheepish wave}}
Using Access 2003
Querying Maintenance Jobs
What I did:

I have a Make Table query that is used to subset records from one master
table to 40 smaller ones. The problem is that I do not want to have to make
40 copies of this query to get 40 different table names. How can I make the
output table name input as a variable. I want to supply ...

I have two long time fields and a query that subtracts the difference.  In
the query I have an additional field for short time.  I want the equation to
subtract the difference between each long time field and subtract out the
short time.  I'm not sure how to do this.  

I have created my query table and would like to calculate each field
indvidualy for the total amount in the entire database that is under that
field. Is this possible?
My following Query is as followed:

Hi my name is Pete and i'm new to access in general. up to now evereything
was going smoothly but i just can't figure out how to do this.
I'm in the query design view and i'm supose to:
Add a new calculated field, with caption property value of it's name, that

i need assistance extract the following
12345 from 3001-12345Y
6534 from 2007-6534Z
thank you

I'm using a DSum function to provide total quantities by product id.  The
function is providing the GRAND total of quantities, and not the quantities
by product id.  Can anyone spot anything wrong?
SELECT GL_PROD_ID, Quantity,

Here's the query:
SELECT  CalendarDay
FROM tblCalendar
WHERE CalendarDay>=[Enter Date] AND CalendarDay<[Enter Date]+7 AND Weekday=1

Good morning, I'm tryng to put a customized form in one of my queries like
this: beetwen forms![dates]![begdate] and forms![dates]![enddate], but when
inserted it in the criteria fild automatically changes to between
[forms]![dates]![begdate] and [forms]![dates]![enddate]; so ...

I have a big problem:
I have a report based on a query with several colums. I want to let the user
(by filling out a form) deside, which of the colums should appear in the
report. Is this possible??? The user could possibly set a parameter or mark

Hi
I have queries in my database.  When i go into query design , +add table, no
queries are in the queries tab of the show table dialog box. Has anyone seen
this?

I am trying to create an Update query to populate a field called "SoundVal"
wherein I convert a "LastName" field to a Soundex value.  I have found
multiple instances of Code available on the web wherein if I use a form I
can determine the Soundex value for a "LastName" one at a ...

I have a query that parses data form a field.  This field contains 3 digit
codes that I am breaking out.  For instance if the field contains the codes:
aaabbbcccdddeee
My result query looks like this

I have been going around and around with this.  From my query I want to be
able to count the number of items recieved, the number shipped and the number
not shipped.  One field is the item name received, the other a check box
indicating whether it has been shipped.  I have been ...

I am trying to code in the name of the table created from a make query to
include the date. Any suggestions on how to set the Destination table
property. I tried setting it to
  = "TableName" & year(now())