I have Access 2000. I am trying to create a passthrough query that will
reference a form for the parameters. There are two tables on a SQL server
linked with an inner join (DATAWSQL.dbo.INVOICE_HEADER and
DATAWSQL.dbo.BUSINESS_DATE_CONVERSIONS).

Hello, i am hoping someone maybe able to help me with a problem i am having
with an Insert Into Select statement.
I am getting the Parameter dialog coming up when i try to execute the
following query.

I am hoping someome here can help.
I have a table that has data of complaints of a certain type based on
a plant and a date. There are only 3 types of complaints that it can
have. I have sucessfully created a join that brings in all my plants

i want to create a query where the results from both the queries qi and q2
are combined in one

I have a date e.g. 01.10.2007 (Norwegian date format) (1st October 2007)
which I would like to convert to a string with 6 characters:  011007. Which
functions should I use to create this string?

How do I get my email online?  Any internet mail. Please tell me by l,2 & 3
things to do to get my email.

I have a table that has three fields [types of fruit], [total number of
fruit], and [price].  What I want to do is take only one type of fruit
“apples” and change their total numbers and prices using a query.  How would
I go about doing this?

It appears there is no facility for creating an AutoNumber data type field
using DDL.
I need to update database schema changes to some 50 regional mdbs.  This
includes creating new tables and modifying table definitions.

I created a new query and saved it using the make-table procedure, but I
cannot figure out how to view the results using my existing forms.  I
recently upgraded from Access 2000, so everything is taking on a new look for
me.

In a Pass thru query, I want to select the meter_number, acct_period,
prod_period, dth from the dbo.con_vols table and the mcf and btu from the
dbo.meas table where the meter_number, acct_period and prod_period are equal
to the meter_number, acct_period and prod_period in the dbo ...

I got a table that looks something like:
<pre>
menuID          caption        parentID       seq
   1                 Books               0                1

I would like to update the fields AdvTime in my query.  Currently Access is
not allowing me to do this.  Both fields are from seperate tables and are
Yes/No formats.
SELECT tblMABR_Plan.[Hospital No], tblMABR.DateMABR, tblMABR.AdvTime,

tblArea
AreaID
area
tblHeadEnd

I know this is going to be a simpe answer but I forgot how I can rerun a
query without going back into design mode, then back to datasheet view mode.
can anybody let me know. thanks Zag

Hello all, I have a tough problem I need to address.
I need to generate a training report for a given employee.  I have a
list of possible positions.  Each position has a series of mandatory
training classes necessary to be certified in that position.