When I create "iif statement" before making a table.   The field has text
and size of 255 but I want to make it into "number and size of 8" instead of
"Text and size of 255".
Your help would be much appreciated.

I have an Itemfield in my Itemtable, what I would like to do is extract some
information from that Itemfield and put in a different table as follows
itemfield  example = DOC51110 , DFM51111, DOC5113, FSP51110, FSS51111 etc
I would like to extract the first 3 left characters and put ...

Hi all, I'm trying to modify the Inventory Database that I downloaded from
the Access download site. Here's what I have so far and still what I'm
trying to accomplish.
1.) I've been able to change the form and add the table values that relate

Okay, we'll break the problem into parts, hopefully solving one part at a
time.
As John suggested, it's necessary to have a separate query that handles the
aggregates.  Here it is, Aggregates query:

I have a database that records info re patients that are enrolled in
different medical studies. Each study is denoted by an ‘IRB number’. So in
the table with the patients’ information, each patient’s name is lined with
the IRB number of the study the patient enrolled in. What ...

each two row in my table is duplicate ,how to take out duplicate rows?

I have made a Query out of a list of clients and have also selected a
"criteria" [Please Input Last Name:] but what if I whant to see the complete
list? What can I write so that the query will show all the data? (meaning,
not filtered)

I asked this question in the 'getting started' forum. Maybe the wrong
place, thought I should try here also.
I have three tables that represent three separate mailing lists
(converted from text files). Many of the people are in all three lists.

I am using access to query an Oracle DB... my query is as follows
SELECT a.DEFECT_ID, b.STATION_NO, b.CODE, b.DEFECT_STATUS, b.PO
FROM a INNER JOIN b ON a.DEFECT_SEQUENCE_NO = b.ID_DETAIL
WHERE (((b.STATION_NO)="BLDG12-MAINCAB") AND ((b.CODE)<>"B7" And

I have several rather complicated queries that are used for mail merges that
use functions as their fields.
ex:   Field~     Tour Time:  IIF(Format([time],"h:mm AM/PM")="12:00
PM","12:00 Noon",Format([time],"h:mm AM/PM"))

I've written an underlying query for a report that uses criteria entered via
a form.  The query is used to determine the number of items sold at a
particular branch each week.  Users enter the beginning and ending dates of
the week and the name of the branch.  The information ...

I am creating a SQL query for my report.  The problem is when I sum the
transactions in SQL query, the total number comes out different from the
total number that I don't sum in SQL query.
Does anyone know why?

I have a client on OfficeXP.  I am trying to do a couple of updates and fixes
and in one of the queries I am writing (my system is on '03), I am using the
Left$ funtion, like LastInitial: Left$([LastName],1).
When I try to run the query, I get "Left$ - Function Not Defined".  Am I ...

I have a query involving 23,000+ records (where 5 numbers are averaged per
record).  Is there any way to speed up the process?  
Thanks.

I have 6 queries I need to run which will fill in null records in 6 fields.  
I don't want my users to have to click "Yes" 6 times.  How can I suppress the
"You are about to update xxx rows" messages.  The following code and sql are
an example.