Goodmorning,
In my query I have a bill date and I would like te make a filter to have a
view on all bills>than 90days as well as all bills< 90 days.
Maybe you will get this mail twice, put I am not familiar with the

Every db I've made up till now in FMP has had few pix so I've just stored
them in the db itself.  Now FMP frowns on this as much as A2K you
understand!  <grin>  But there were so few pictures, it didn't hurt.
The current A2K db I'm creating will have potentially a picture for each

I have an import table, OrdersIn, that I want to be able to count the the
number of records processed after the import routine is completed and have
the record count returned to to a message box. Is this possible ?
I'd be grateful for any help

This isn't a specific problem I'm trying to crack, but I'd appreciate
some general advice on something that's puzzling me.
Am I correct in thinking that, strictly speaking, it's wrong to have a
tblContacts with ContactID, FirstName, LastName, AddressLine1 and so

All of sudden I'm having problems in queries with Expressions that I set a
criteria on. Calculated dates I can't use Date() below in the criteria. Iif
statements that return a 1 or 0 and put say a 1 in the criteria I get the
error. What am I missing here.

We share our database files.  For some reason, when we open our 2003
databases (recently converted from 97), we are getting a database file name
with .mdbt as the extension.  
This happens when the database is open.

Thanks to all who helped with my last query - i am having difficulties
again!!(surprise!)
I would like to put an option group on my subform with 3 options. Only one
of the three options can be selected. If the first option is selected then i

I have 2 tables within a database.  I wish to compare field 'ID' in
table 'Report' with field 'SchNo' in table Final List, and bring
forward the data from field entitled 'Name' in table Report, into a
field entitled 'SchName' in table Final List if the 2 id numbers match.

=DCount("*","Clients","[Therapy1] = '1'")+DCount("*","Clients","[Therapy2]
= '1'")+DCount("*","Clients","[Therapy3] =
'1'")+DCount("*","Clients","[Therapy4] =
'1'")+DCount("*","Clients","[Therapy5] =

Please help:  I am trying to manage land and properties in a small town.  
I have 2 tables: Owners and Property
One owner may have one property or own several properties
The form: frmOwnersAndProperty has both tables on it:   The Main form is

I would like to be able to pass variable data (product name) from a Textbox
on a form to query data in a Table and then have that query return the
(price) value into another textbox on the form.  I really wanted to automate
this task rather than having the user select and store ...

I have INSERT SQL code that I run.  I'm not quite sure how to do this.
I need to search for duplicates either before or after the code is run.
 All of the info is on an unbound field just waiting to be inserted.
How and when do I search for duplicates.  I thought maybe DLookUp ...

I run Win2000 with Access 2000. I have created a table & form which has an
entry of a "First Name" and an entry of a "Surname". I would like to have a
combo box on another form that shows the entire name (First namd and Surname)
and allows selection of it. At present I can create ...

What is the syntax, please, to insert into the
Private Sub Form_Current()
event of a parent form
in order to refresh a subform contained within that parent form?

I'm trying to track payroll data that will be update annually.Should this be
done with a data base for each year or should a copy the 14 tables planned
for each year with a name that start with the year. Example 2006earnings,
2005 earnings