I am trying to make a referral database for my boss.
I have two tables REFERRALS and CODES.
In REFERRALS, the table contains surname,name, date (that referral was sent),
and CODES contains codes that have corresponding timeframes (in days) like 7

Per earlier post, I am trying to save 'out' production data from a
program called Solomon - basically (I think) this was /is an Access/Sql
based program.
We are updating to different application and I need to bring over ONLY

A query designed by someone else includes the following:
   SELECT Left([Period],4) AS YR
It runs on my client's machine but not on mine.  The error message I get is
   Function isn't available in expressions in query expression

I recently upgraded to Access 2003 from XP.  I want to copy and paste a query
result to Excel.  But the "copy" and "cut" commands are disabled in the main
menu, the tool bar, and the context menu.  Any idea why?

I am trying to run an append query and am getting the following error:
[IBM][CLI Driver][DB2/NT] SQL0952N Processing was cancelled due to an
interrupt. SQLState=57014 (#-952)
I am able to connect to the ODBC driver in Adm Tools and have run this query

i have a table that has duplicate values (maximum 2) for the field AWK_ID
which is OK because 1 AWK_ID can refer to different products.
i would like to create 1 records for every AWK_ID with information of both
products it refers to

Please help.  
I'm trying to produce a product price list from a table that records all the
price history for each item.  The query should show only the last date it was
updated for each item in the list.  This price would be the current price for

I have this select count query which i need to change into a random count
what do i need to change to make it select random. What it does it count a
Qty of PIN numbers. But i need it to do a Random Select of a Qty PIN numbers
(Select Count (Tmp.Pin_Number)        

Sometimes ago, I requested and got help on truncating the last three digits
from a field with data of the following format ????-????-???. I would
appreciate help on truncating the just the middle four digits.
I tried truncating the last eight and then based on the result obtained, ...

Please help me in this issue....here is my code..and tabel struct.
column name            datatype
dateofS                     date
stid                             number

I have a query where I enter the auto numbers allocated by access in a table
to produce a report of interview questions.  I want the query to be in the
order I enter so when I mail merge it they come out in the order we are going
to ask them. The query is in the form of "1 or 7 ...

My parameter query was working perfectly.. it collected values from a row of
text boxes on a form...but now its acting as if it doesnt see the
form/parameters  by asking me  for the paramaters over and over again? What
happaned?

Can Anybody tell me what performs better in a where clause looking for
several text strings:
Method 1:
Like "Example_A" or like "Example_B"

Hello to all,

Table has a field named TIME.
Datatype:Date/Time
Format: 09/12/2005 6:24:45 in 24 hour format
Want to have a field, named TIMESUB that substracts TIME by 7 hours using