I'm creating an inventory database with a field named "item description". I
want to create a query that can search for keywords in this field and output
a result. For example, this field will contain data like "Kingston 1GB
JumpDrive". I would like to be able to search "Kingston" ...

I am new here, and a novice level Access user.  I am building a query.  I
have client  records I am trying to calculate the number of days stayed in
our facility in a month.  I have a Client table, Client admissions, and
client services tables.

I am trying to run a Delete Query using two tables.  Here is what I have so
far:
DELETE DISTINCTROW tblProjects.[Project Phase (Per EPMO)],
tblComments.[Project ID]

I'm somewhat new to ACCESS and still trying to learn it. I'm having a
problem with a query I'm running if you could please help me out I would be
really appricative. Im trying to combine only certain records by matching up
dates from 2 different fields. I'll call the fields ...

HELLO
      HOW CAN I GIVE SECURITY TO THE DESIGN VIEW TO PREVENT ANYBODY NOT
CHANGING ON IT.?

I am a new user to this discussion group. Hope you'll are having a good day.
I am currently trying to establish a database where I have a table with the
below display
eg:

I have two seprate columns in my query (as shown below)What I need to do is
only show all dates Under SEL before 3/16/03 then show only the dates for SE2
between 3/17/2003 and July 28th 2003. How do I do this in a query. I cant
figure out how to seprate the SEL dates from the ...

My Query is laid out as follows in order to give me the Denominator:
Field:Hospital
Table: BNH_HF_PT_LVL
Total:Group By

I have a database with 2 columns and more than million rows. The first
column is the id
Example of the data (2 columns)-
04731   CRM

Okay, I have [date1]-[date2]=cycletime. In a query how  can I have a field
that reports the total average of all the records for the cycletime? So say I
have 50 records I would like to know the average of days(cycletime) for all
50 records.

I have a database that is 1.8 million rows and I need to place this in excel.
Excel can only take 65500 rows.  I need to simply select by rows 1-50000,
then rows 50001 - 10000 and so on.....

Before I create a report I need six different queries to run.  How do I get
all six queries to run without haveing the "yes / no" promts poping up?  I
have already unchecked the boxes in the "edit/find" in the options.

I am having a problem appending some data from a table in a remote db
to a table in the local db.
My code is:
Private Sub pvtRefreshSubDepts()

I hope I can explain this well enough. I am new to Access.
I have a tble of 1800 stores, a table of Inventory levels for each week, and
a table of 10 products.
***tblStores***

I have a simple update query, run from a command button, which changes a few
fields.
However, I want the user to be able to simply click the command button & the
fields to be updated without the Prompts - You are about to run a query etc.