I have three tables in Access: "wholesale", "profi", and "min_value".
The "wholesale" table has this structure:
code (string)-primary key
type (string)-primary key

 I want to run a macro and tell it to import a spreadsheet, then open a
table in design view to change the data type of a field then after i have
saved that table's design continue to run the next step.  Any ideas?  
So basically,

  First off I am running ACCESS 2003 on an SQL server.
I am running a query that requries a date input.  I would ilke to be able to
input the date to a form and have the query pull it from the text box on the
form.

I have a source SQL:
SELECT LiveMonth.MonthID, LiveMonth.LiveMonth, AccStat.Count AS Total,
AccStat.ASID, [Account Status].AccountStat
FROM LiveMonth INNER JOIN ([Account Status] INNER JOIN AccStat ON [Account

I have an employee database, I have created a query that has the following
fields Employee ID, hourly wage, month, hours worked, and than an expression
that  multiplies the wage by the hours worked to give the monthly amount
paid. I want to add all the months up to get the yearly ...

I have this query to sort the status of claims.
SELECT 07.STATUS, 07.CLAIMNO
FROM 07
GROUP BY 07.STATUS, 07.CLAIMNO;

I would like to create an Access query based on a text field with a result
set that would not include records where the text in that field starts with
the letter z or Z. How do I write an SQL WHERE statement that performs this
function?

I have a orders table.
CustNum, ordType
1,a
2,a

I am trying to create a function that will sort all the people that will be
leaving with in 30 days from todays date and I will also be needed one for
people leaving in a week time frame.  I have tried using >Date()-30 but it
shows a person that has already left 3 days prior to ...

I have a query brings in all my data from different resources.
When I look at the resulting data, I see that f1 has dup records.
ID  f1  f2  f3  date
1    1   6  6    2/11/2008

Trying to use access to generate a price list.  Having a hard time getting
access to round the same way as the system we have.  Been using E2 Roll:
(Round(((((([5.13])/0.8)/9))),2))*9, which comes out with 6.39.  When you
divide by 9 you get .7125, need to have it round up on .01 ...

Can anyone help me with a security problem?  How do I keep people from
accessing  objects in a secure Db, via the shift key back door
method?  Assuming that there are various methods of achieving this
result,  I'll ask for the simplist method, since I fear that the

I have a column that has irregular TABs at the end of the data element. The
length of the string is counting the tab. How do I search for a TAB in the
column? I know in Excel you would use {TAB}, but Access doesn't like this.
Thanks.

I have a select query that runs like this:
SELECT [P - Lease Info].Num, qryTest1.Lease, tbl1BeginStock.BeginStock,
qryNetBbls.SumOfMiscBbls, qryTest1.SumOfEndStock,
qryNetBblsRun.SumOfNetRunsBbls, qryNetBbls.SumOfNetProdIn,

Hi, I'm new here and I hope you can help me. I was given this data and have
no control as to how it was/is created.
I have a table that has an ID, SEQ_NUM, and a MEMO field.  The data in the
memo field is a document. Each memo field is 2040 characters long and the