=IIf(IsNull([p1]),"",IIf(Val(Nz([Form]![PEN],0))<=Val(Nz([Form]![MAXPEN],0)
and Val(Nz([Form]![PEN],0))>=Val(Nz([Form]![MINPEN],0),"PASS","FAIL"))
This control source works until I add the "Val(Nz.... section.  Once I add
that part I'm getting errors.  Also, can this be ...

I use Access 2000.
I have these 2 tables(as well as others): tbCompany. tbMeeting
Some companies have the same name but different addresses.  Each company has
1 Main Contact person. plus additional individual names related to that

I need to store a birth date in a table mainly to keep track of when to
celebrate birthdays.  Some people will offer their complete birth date
including the year, but many will only want to offer the day and month
part of their birth date.  For the most part I only need the day ...

I am fairly new to access, and our work computers only have Access 2000
I have created a bi-Monthly report that we submit to a local La
Enforcement agency, from information we store here. They have aske
that we include photos in our report now. Is this possible? We have th

Access Novice - WinXp/Access 2003
I am in the process of designing my first database and plan to use this
mainly to teach myself Access. The purpose of this database is to store
employees data and track down employees personal info, employment

I'm a beginner with Access 2000, but I'm still sure that the answer to
this question is staring me in the face.
I've linked some tables.  My plan is to have my main table with another
linked containing names of staff members.  Actually, to be precise, it

I have tried for days to open Customer service for access 2007 and upon doing
so get an error....how can i solve this and is anyone else haing this same
problem?

I need to create a database to list all the files in a certain folder that
are held on a specific file server, is there a template or a guideline that
I can reference for this task?  WinXPpro/Access 2003

Trying to use Form Wizard.  When I click on the 'Form Wizard', bottom
selection asks to select a table or query from which to get the data.  How do
I get 'data' generated for the wizard to use?
Also, should MSSQLServer be running on my computer?

I have a DB that is split (front end and back end) on my server.  The front
end is only provided to my clients.  I keep getting new DBs named db1, db2,
and so on in my folder where my DB is locate.  Why is this happening and how
do I stop it?

I have an application that uses several tables and I constantly revise the app and want to update the mdb to the new version. I have been using copy and paste to do this. I plan on splitting the program at some point but not yet. I have to copy and overwrite the records in the ...

If you make a junction table with the primary keys of 2 other tables is the
info that you typed in the junction table supposed to be displayed in the
other 2 tables? if not where is it supposed to be displayed?

On 9/26 Klatuu posted a neat method for storing constants in Access. He
described setting up new CurrentDB properties which are persistent.  My
question - is there any way to see those properties if you don't know what
they're called (or if you created some and forgot what you ...

I can not find template for avery J8173 labels, please help.

I have a basic question.  I have a form used by various people to key in data
with the data going into a table.  I was playing with the query wizard and
queried my table.  As my table is updated, does the query automatically
update?