We just converted our 97 Access databases to Access 2003.  The project went
well with only some small code changes.  One that has become larger over time
is...
we import XML files into the databases.  In the 97 version, when the file

I'm just learning my way with IIF statments.  I am creating a rent roll. Two
basic  tables are involved - Leases and Properties.  Availability for
Properties with a lease in effect Today is NO, and the rent income is the
amount of total rent.  Availability for Propeties without a ...

How do i make query to ignore a date in the Date/Time field in Access 2003?
Thank you
TT

Can some please help
I have a union query, which is made up from the sql from 2 seperate queries
from 2 seperate tables.
Both the tables have a field called "Account No"

I have the below code.  What I am trying to do is to have an email generated
from a form.  The form has several fields that I would like included in the
email:
Addressees

I knew how to do it but forgot and can not find the DB where I used it
earlier.
I have a table with verhicle milage, and would like to find using dlookup
the last entered record of a certain vehicle, so I can calculate the covered

Hi, I've made myself a database to keep a record of my sales and purchases
invoices. On a main form [Invoices] there is a SubForm [Invoice Sub Form]
which is based on a query containing 5 fields from a table called [Invoice
Sub Table], InvoiceID, Product, Amount, UnitPrice, ...

Okay.. I'm going to try and simplify my problem because I'm really looking
for a conceptual method to do what I'm doing.
It's basically a recon of 2 files with the same fields.  Let's say there are
10 fields.  The criteria for a match consists of matching 4 of the fields.  

how might I go about this

I have two tables.
One holds personal data (tblPerson includes - personRef, personName etc) the
other holds details about where that person is on a given date
(tblAppointments Inc - visitID, personRef, Date, Location)

I am working on a customer inventory for services that we have preformed for
our customers over the year.
The problem I am having is that when I enter in the information for one
When I goto the Report Query Report it prints all the same information for

About a year ago I got help from this board in using NZ to retreive a zero
instead of a null value. I'm having trouble remembering how to use this.
Could anyone give me a hand with some tips on where to place NZ.
Thank you

I'm having trouble with Rounding in Access 2002...
Here's my formula:
Extended Cost:([Mileage]*0.345)+[Cost]
When I run that formula through my query, with Cost = $25 and Mileage = 25,

An Access 2003 query that has been working fine, began throwing Error 3001,
Invalid Argument when it is run.  It is a Make Table Query, and when 2
particular fields are included in the query, it gives this error.  Without
them, it runs fine.  Both fields are "memo" type fields, ...

I have a query that counts the number of days between start and completed.
This may be a difference of 1 or more days.  Below is my query.  How can I
group this to give me an average of days per branch?
SELECT [qryFILLED - AT].LOB_NAME, [qryFILLED - AT].DistName, [qryFILLED - AT].