Hello all \.  Iam new to this group.  So if I do anything wrong i do
not mean it.
Here is my question:
I have a currency field (i.e. $24.50).  I want to change it using an

I run Win2k and Access 2K
I have a form that contains a combo box that looks at a table called
"tblAddNames". This combobox works fine but does not show the list in
alphabetical order. So, I have created a query called "qryEmployee" that

I want to make a query from my data in which I can have all person with each
months birthday in a seperate query.
Example:
Everyone in my database with a birthday in November.

I am using DateDiff to display Total time between and existing date and
Now().  In using DateDiff I would like to display the answer in the format:
Total days elapsed, h:mm time elasped (dd  h:mm).  Will DateDiff do this or
is there another function I can use?  Or is there some ...

Is it possible to copy a record when a field contains two entries and obtain
2 records, one with each entrie.
The table is Colors :
Id        Color

I have a bit of a newbie question (basically stated in the subject of
the posting).  If need to get some data out of a SQL Server Database.
Can I use a control from a form to supply a parameter.  I've created a
stored procedure with the parameter I need, I just dont know how to

I need a simple method of linking a number field in a query to a text field
from a table (that I can't change).  I know there is a Val function to
convert text to a number.  Is there an equivalent function the other way -
number to text?

Anyone tell me what is the problem with this query? I am trying to
delete duplicates out of a large table without re-creating the table.
When i run the inside "SELECT (MIN" subquery, it runs super quickly and
returns a table with the 200-300 records that would be duplicates as

I'm combining responses from two different surveys.  The two select queries I
specify in the union query work as expected when individually executed.  The
union seems to drop data for a series of questions.  If we can make the
assumption I have listed the same number of fields in ...

How do you show only the fields you want based data in a different field?
I have the following query..
HLP_CODE ...  STATE
TCCXX1....      WA

I am wanting to do 'bulk updates' to a Notes field - based on appropriate
criteria.  eg - "I send an email to all Volunteers living in Wellington to
invite them to ....".  (NOTE: The user has requested that the Notes field be
one record as opposed to a new record each time a new ...

I am trying to build a select query where if I select one value for a field
to also include another.  I have a form from which I get my value.  For
example, if I select on my form to show all records for course # 112, also
list all records for course # 111.  If the value is not 112, ...

I have this in table:
Joe   xyz
Fred   xyz
Lou  xyz

Can anyone tell me why this SQL is not working for me? I need to COUNT the
number of records/rows there are for each PART, but all I get in the
CountOfPart column is all "1"s. I've tried many different things but can't
seem to get it to work.

Access 2003:
I have a form with a combo box, [cboStudents]
The combo box's recordsource is a parameter query.
The parameter is a textbox on the form.