I have a customer database that sales people use to track their customers. On
opening the sales rep can search for the customer by account no, phone
number, contact name, or company name which then opens the main form,
frmCustomers. For security reasons I don't want the sales rep ...

I have a two tables, obligations and instruments.  I have a junction
table(obl_inst) to create a many to many between those two tables.  My main
form is instruments and obligations is a subform.  If neither table is
populated and I add an instruments record thru the instrument ...

I have a database that tracks medical facilities.  Each facility has at least
one Specialty classification (ex. surgery, pediatrics, cardiology, etc), and
many of them have several Specialty classifications.  The facility name is
the Primary key for the table that stores the info ...

I am familiar with the trim command to drop extra spaces in a data field when
joining 2 fields.  But I am trying to create a table that acutually inserts
blanks or spaces  so that ifwe normally see
Jacob(end)

I am working on a delete batch form that simply deletes assigned batches for
users.  The records that need to be deleted are in the assignedbatches table.
I have only a little experience with delete queries, but this works in the
Access QDG:

I have an Access database that analyses telecoms data for a number of
clients, each with their own list of numbers. I have a master data list that
contains weekly call data. This is matched up to the list of numbers for each
client and a report produced showing calls to those ...

I have a predefined list of id's in a table named tracts.  None of the other
fields in the tract table are populated.  I want to use a query to find the
first available number in the tract table and use this to populate a combo
box.  Available means the record is clean other than ...

I am trying to make a calculation in a field on a query as follows
when [position] is less then 21 and greater then 0 = A
when [position is less then 41 and greater then 20 = B
when [position is less then 51 and greater then 40 = C

I have a M.S Access query that I am trying to use a variable to pull
current data, so in the criteria of the specific field. I am using the
Select Case command to populate the variable.
The code looks the following:

I want to replace the first digit in a text fld from a 1 to 8. What is the
best way to do this in a query. The length of digits very from 6 to 9.
Thanks
Matt

This is what I have:
1) A tblLocation with 3 numerical records called OfficeID (1,2,3)
2) A query called qryData based on the tblData. The Criteria in the query is
set to 1 so I can retrieve only data for office 1

Total newby when it comes to access so im hoping someone can put me in
the right direction. I am trying to calculate answers completed in a
survey. Here is my table structure:
tblPerson

I have a table with these columns:
idExam  idQuestion  Result  total
=====  ========  =====  ====
1        1       ok       12

My current query results contain the following fields: PatientID, Claimnum,
Activitynum, Diag1, Diag2, Diag3, Diag4, Proc.  Each patient can have
multiple claims.  Each claim can have multiple activities.  Each activity
will have Diags 1-4 and a Proc.  

I have a query whose criteria is based on dates on a form:
Between [Forms]![Performance Measure]![txtBeginDate] And
[Forms]![Performance Measure]![txtEndDate]
txtBeginDate = 10/1/06, txtEndDate = 10/31/06