OK,  I have 1 table that contains records where the will be dollar values
that will need to be matched.  But,  The dollar amount in one record will be
a negative of the dollar amount in the matching record.  i.e.
Record 12345   $5.75

I am trying to write a query that will result in getting the name, address
and trade of my firm being added to the name address and trade of the
consultants for every job  (the other consultants vary by the job).
This is in order to write a multiple column subreport that will list ...

When you use the Round Function in a query in Access it does not work the
same as the Round Function in Excel.
When you use this function to round numbers such as 2.5, 3.5, 4.5, 5.5 etc.
to the nearest integer it will round the ones with an even number to the left

I have a base source Table1 with EquipmentID and description fields as text:
EquipmentID      Description
00875                 ....
0545

emails in inbox have disappeared.  It hasnt been deleted and it's not in
other folders.  its also not showing in recover deleted items

I have 2 tables related to medical records.
The first table has Treatment Codes(CPT) and related Diagnosis(DX) codes.
Sample Data:  Transaction Table
CHART    DATE    CPT    DX

In a program I am writing I need to isolate the day value from a date. I have
a date on the format dd.mm.yyyy, and need a formula in a query that returns
only the dd value as a number. I.e. from the date 14.05.2005 i need the
result 14. Do anyone have a formula that handles this?

I need a column to be numbered 1,2,3,4,etc for each item in a group(JobNo),
for
example:
OverallID   JobNo      MYID

I need an expression that lets me do the following:
If the value in field A is 0 (zero) then I need to add the value from field
B in a parenthesis to the right of the 0 value. (i.e. "0 (xx)").  The value
in field A must retain its original value if it is not 0.

Learning to create a query. Required to input multiple dates in the criteria
section and not sure how to do that or if it's even possible! Keep getting
the message "Data Mismatch". Other criteria required is name, #of guests and
notes. I can't figure this one out, and Unit ...

I have problems with the round function:
1. Round(ExchangeRate,2) gives 54.5099983 when ExchangeRate = 54.51
2. Banker's rounding. Ex. round(2.725) gives 2.72
The workaround I use for the first problem is to introduce a constant in the

I have 2 tables.
Table Transactions contains data for patients medical visits.
[DATE],[NAME],[TREATMENT CODE],[DIAGNOSIS]
Table Approved Diagnosis contains a list of approved Diagnosis codes for

I am trying to create an SQL statement which would return to me the maximum
date before a specified date. I was able to get a list of records with dates
prior to the one I enter but not the last one. Can anyone help? Thanks.
SELECT tblDates.dEntryDate

Hello all - I am creating a query of providers (docs) and need to impor
the languages they speak for the directory. Problem is - languages ar
kept in a seperate table (ProviderLanguage) and they have multipl
entries for each provider (a new record is created each time a languag

Table contains a single record for each part number with 12 separate fields
for units sold in each of the last 12 months.  I want to perform a select
query that yields the maximum units sold in 1 month for each part number.  In
Excel this is easy as Max will compare both ...