Has there anyone got a solution to my problem:
- recently got Windows Vista
- since then, queries with the string function left (e.g. left("member",2)
equals "me") don't work

I have created a query where on my computer I can work with it and I have no
problems.  However, when others open the query in design view the criteria
bar at the bottom of the query is missing.
How do I display the criteria bar?

Hey everyone,
Is it possible to count the number of times something appears in one sigle
cell for each record?
Example: I have a RACE field which was imported from another source.  

Does anyone know how I can tell Access to extract and display all NUMBERS
from an alpha-numeric field?  I.E.  I have a field:
Tab 10mg.dl
Dosage 20mg

I have a table with multiple records for each name. I want to pull 10% of the
records for each name. I have created a query that calculates how many
records it should be. How can I pull the specific number of records for each
name from the table?

I need help in identifying why I am getting this message. I have a query for
a Report where my defined field returns the message that says:
**The Microsoft Jet database engine does not recognize -
'Forms![Level-Top-Reports]!DivID!' as a valid field name or expression.**

I found this information on another user's question on sequential numbering,
but wondering how I can save the generated number in a table?  Right now the
control source is set to:  =RowNum([Form])
Here's the link to Stephen's code:

I have a query with field named: amtpaid
I calculate this field to be amtpaid:[invamt]-[otheramt]
It gives me the calculated amount in this field, but the number is showing
$sign

I have a table that shows how long a member has been effective with my
company.  There are 2 fields, datefrom and dateto, that show length of time
and I've been using a separate table to break up the date range into
individual months.  The table has one field called Midmonth that ...

Hi Groupies
One of my students has asked me a question and I thought I would throw it
out to you all.
She has a database that was developed for her. There is a possibility that

I'm relatively new to all this, I need some help.
Here is what I'm trying to do.
I received a list of bank names that I need to see if we have coverage in
our database. I'm not getting that many matches because of abbreviations used

last night my colleague messed up big time, and one of the table has had it's
data overwritten to one value.
ie: i have 3 tables, one for the booking, one for the home, and one for the
extra details. the extra details has a list number for the home, which has

Say for example I have a database containing the date of birth of people in
the format of YYYYMMDD (a string/text field) and another field about the age
of the person (a numerical field) and another field is, say, the date they
had their birthday last year. I would like to check ...

I'm wondering if I cn tell access to fitler by just those records that
contain numeric values.  For instance:
CURRENT RECORD LIST:
Drugname 50mg/dl

I have a table with the field:
tblFormatted1Summary
f1PropertyID
__________