I created a db that tracks original, actual and discounted yearly numbers for
each deals. I capture the numbers through a continuous subform.
Deal
Actuals    Acctgdata1     AcctgData2   AcctgData3

I have read through many of the posts but cannot get the correct format.
Subtract time1 from time 2.  The result could be minutes or hours.  Here is
the query expression
Enroute Time: DateDiff("n",[Call Time DIsp],[Call TIme Enroute]) & "\60" &

I have the following query and it gives me the "Too complex" error message:
SELECT tblAll.Doctor, tblAll.ScheduleDate, tblAll.Time, tblAll.Accounts,
tblAll.Review, tblAll.MemberName, tblAll.MemberID, tblAll.FacilityMD,
tblAll.ContactNumber, tblAll.[2ndContact], tblAll.Outcome, ...

This is what I want to do.  
In the PO_TBL I have a field PO_ITEM_NBR which combines the data of the
PO_ITEM and PO_NBR fields.
I want to parse into the actual fields of PO_ITEM and PO_NBR which will

I am running a query for information based upon some invoices and want to
eliminate those invoices that contain specific words in a particular field.  
How do I do that?

I am trying to count how many specific individual values appear in a query
column, but the COUNT function returns the number of records, not specific
values.
EG:

I have 1 query and 10 forms. The query is used as a look up for a field
(StudentID) on all 10 forms.
Per request, I added an unbound combo box on all 10 forms (cbo151). I'd like
to use the value in this combo box as a parameter for a field in the query.

I recently ran an update query which I used an excel 2003 file as a linked
table.  I took Date Of Birth off the sheet and it was entered into my DOB
field on a table.  The problem is that the birthdates dates before 2000 have
converted from 12/16/2007-12/26/2049.  These dates ...

I have a Crosstab query in which I need to convert the empty (null?) values
to 0. I have tried using the Nz function, but it doesn’t seem to work. I know
this is probably simple, but could somebody point me in the right direction?
The field that I need to convert to 0 is ...

I am trying to update a field in a table from a text box on a subform.
Basically when the user opens the form they choose from different people and
get their details. i would like them to be able to update the data. So i have
created a button and on click the following SQL is ...

Hello, I need to update a field to the sum of another field in another table.
for example
I tried to something like UPDATE [PHYSICIAN GROUP] INNER JOIN [PHYSICIAN
RATE INFORMATION] ON [PHYSICIAN GROUP].[GROUP NUMBER] = [PHYSICIAN RATE

i am using the following code on the save command of a form & wish the
queries only to run for the current record on the form but they seem to run
for every record in the table, this takes about five minutes on the current
4000 odd records any suggestions

I have text values stored in a field in a table of about 200 records.  Some
values repeat themselves often.  Is there a quick way to find out which value
appears the most often?

I have created a database which logs operational data for an industrial water
plant.  
I want to output a table of the data, based on inputs from the user.  I've
created a form where the user can enter a date range for the data they want

I've a problem, in order to retrieve data from multiple tables, I'm joining
(inner join)
the same table with 3 other tables. and therefore i get duplicate records.
How do I get rid of this duplicate rows.