I have a table with column headings like so with sample data
InsID, Type2, ID2, Type3, ID3, Type4, ID4, Type5, ID5 as far as ID16
1234
4567

I want to use an unbound form variable in a query as a parameter, please tell
me how to do it?

I am trying to get my query to compile our current monthly pass rates.
The above Criteria does help in displaying pass rates on an associated
report, but they are not the current month.
What is wrong with my Criteria?

Greetings.  I am working in the query design view.  I have 3 tables that I
need to bring together into a query for a report.  The tables are;  
tblClient,
tblRevenue,

i want a slide show which also my video clip animation

Is there any way trhat i can write Dynamic Stored Procedures and Triggers
for MS Access Database through MS Access? The requirement is to use only MS
Access. The front end will be MS Access forms. MS Access forms will call
stored procedure and trigger for data processing in MS ...

Table Groups:
GroupId       Group Name           MasterId
1                     AAA                         0
2                     BBB                         0

I have a table that has 5 fields:
ID, AutoNumber
Ticket, Number
Techs, Number

When creating a query that looks for particular values in certain fields, I
have decided that I would try to be clever and make a new field, in the
query, calculated on two other ones. In the query in question I have decided
to use the CONCATENATE function to the FirstName Field ...

I have written an update query that will adjust the rank of items in a list
as follows:
Private Sub Rank_AfterUpdate()
Dim CurrentProcessID As Integer

I have one table with invoice numbers.  Another table represents invoices
that have already run and also has invoice numbers.  I need a query to pull
only records from the first table that are NOT in the second table.  I do not
know sql, so I need a solution I can do in the query ...

When I type the following in my query:
Funding_Month: Format(DatePart("m",[Funding_Per_Begin]),"mmmm") in my query
where (For example) [Funding_Per_Begin] = 2/1/05  the result is JANUARY.
Am I doing something wrong?

I have 3 fields, employeNb, date and hours
and i want to fing the overtimes hours using somthing like
SELECT INV.empno, Sum(INV.hr) AS SommeDehr
FROM INV

I have a SS#, Last, First, Source, Dept, ZipCode table.
I noticed I have duplicate people. e.g.
ss     last      first    source    dept                          zip
123456789  WALTERS     GEORGE       TL    SOCIAL SCIENCE    10805

I have a linked table that pulls data from our accounting database.  In the
table are account numbers formated like 999-99999-99999, is there a command
that I can put in a query to split this into 3 seperate fields?
Thx!