I am trying to relate 2 tabels in a query on a time field.  Both fields are
formatted to Short Time. Some relate Ok and others not. What can I try?

I'm trying to replicate what SUMPRODUCT does in Excel to calculate a weighted
average.  See the following example:
I have 2 patients under the PPO Plan Type.  
*Patient 1 has an RPT (rate per treatment) of $251.56, and has had 52

I have a query with a very detailed criteria.  I inputted new records
by using forms that meet the criteria of the query.  However, they are
not there.  Can anyone tell me of some type of refresh that I need to
do in order for the records to show up in the query?  The records are

I have created a Union Query to consolidate results from separate queries,
each one of which represents results for a single month:
SELECT ReportMonth, MonthlyRev, MonthlyCost
FROM qryMonth1Total

Users enter records, I have to determine the nearest due date, for each user.
This code returns the 1 nearest date, but I need the nearest date for all
users.  So, when I add the user it tells me "You tried to execute a query
that does not inclide the specific expression "TR_USER' ...

Have a query with addresses - need the user ot be able to enter just the
street numbers and see all addresses with said numbers.  Such as:"836" gives
them 836, 8365, 836009 from the table.  Not sure how to use a wildcard with a
select criterion.  Simple have [Address Number?] ...

I have a combo box named Rank on my form, and it is based on a table that
lists all the ranks and has a column that has the associated paygrade (which
has a column width of 0" so it can't be seen).  I want to create a few
queries based on the paygrade (i.e. E5 and below or E6 and ...

I have 4 colums
Date  Amount 1  Amount 2  amount 3
i would like to capture al data in a certain date range and sum the amount
sepetately for the entire date range.  I get the date  to list out  

I am getting an error statement that I have a data mismatch in the criteria
expression.  Can anyone tell me where it is?
IIf(DateDiff("d","Arrival Date",[Start Date])>CLng([Rates]![Free
Days]),(Date Range Detention Query_1]![Departure Date]) Or

I have a query that I want to calculate the average of three different fields
pulled from a table: [EmployeePerformanceRating],
[WorkOrderPerformanceRating], and [ContractPerformanceRating].  I tried to
create another query field "TotalPerformanceRating" using the following

I have one table that has records that contain information on different
properties.  I want to create a query that shows all the records where the
owner address does not match the property address (which properties are
non-owner occupied).  How do I do this?

Hope someone can help. I’m not to sure where to post this. Forms, linking ,
ODBC
I have a main form with subform.
Main form has:

I want to to a query to gather a lot of account numbers (160), amd then do a
crosstab query. Is there a way to do this .  Any help will be appreciated.

I have a query that is behind a report.  In the query designer there is a way
to indicate if nothing is selected from the parameter, all records will be
returned.  It has been a long time since working on this that I have
forgotten what is added.  If anyone is familiar with what ...

My team mate used Business Objects to create a report that goes against
Oracle and then sent me the SQL it used to do it.  Ultimately I'd like to
embed the SQL in Excel, but I'm trying to run it in Access first, so as to
get better diagnostics.  When I try to run the statement I ...