My last project in the database I am building (thanks for all the assistance
so far!) is to build a form where Stats are entered.  The idea is that the
project managers enter work in a month on a particular job in percentages.  
Thus a job might already be sixty per cent done, and ...

I have a counter on my switchboard that runs with the following code:
Function MissingEntryCountRecords() As Long
Dim db As DAO.Database
Dim rst As DAO.Recordset

Hello, friends...
    I know you're likely tired of hearing this sort of question so I
apologize in advance for asking, but I am clueless as to how to go
about getting this accomplished.

I do not know SQL but I am familar with Access. I need to build an expression
using dlookup for the situation below.
I have two tables, table I contain addresses complete with five (5) digit zip
codes.

I have set up the addworkday module from
http://www.mvps.org/access/datetime/date0012.htm
And it works great if I don't add the optional array for the holidays.
However, I do want to include the holidays and when I add the array to the

Is it possible to have a query pull information from a drop-down?  I have a
report based off of a query including criteria: [dept] and  between [start
date]and[end date].   Is is possible to have the result of the [dept] create
a drop-down menu to enter the data?

Hello and thanks so much for your help!
I have a simple table of Physicians that have the fields, Location and Group
(which is the Physician Group he/she belongs to).  Both the Location field
and the Group field are populated from the Location Table and the Group

I have db update process all in queries, but I need to have it as a code
procedures.
Have little knowledge in code writing. I don't know if it's possible and I
would appreciate any help with it.

I want one of my selections in my CBO to always show as the default. How do I
do this? Is it in the query or proportites?

I have created 2 separate Union Queries that work just fine.
Can these 2 union queries be used in Another Union query  (that will
essentially combine the output of those 2)?
Thanks very much,

I have 1 table with  ~217k records, 6 fields (Site_id, Date, parameter,
value, remark, value_orig). Data in the value field are text strings, but are
numbers. They also contain ">" and "<" chars, null values, ZLS, white space
and other unwanted text. I've written an SQL select ...

I have a field in which some of the records end with text enclosed in parens:
parameter    value    remark    PCODE_ID    units
Air Temp (deg C)    9.16        20    degrees C
I want to delete the space and all the text enclosed in the parens.

I'm trying to create a form where, if there is text in a text box, a
pair of command buttons will be enabled. I have figured out how to
make this work if the text box has been updated, but I can't figure
out how to make it work if there's already text in the box when the

I need to query all records that have a date from today back through the
past 30 days (from a date field in a table).  I tried <=Date() - 30 with no
success.  Other ideas?
Thanks!

I have a string that contains alfa & Numerics
I need to query the numeric part which could be anywhere within the string