Hey all, I am trying to write a function for a Module.  Here is my code:
Public Function fncModelNo(OptionKey As Variant)
   Dim ModelNo As Variant
   ModelNo = Left([OptionKey], InStr([OptionKey], ".") - 1)

I have a query that currently runs using built in date parameters. I want to
change this to run from a form, but every time I try to run the query this
way it comes back with incorrect results (28 entries instead of about 3000 -
it only uses the last txt box instead of acting as ...

I need to use an If statement in a field in my query, here's what I need it
to do:  If field name "PYE" equals "12/31" then insert "1/1" or If field name
"PYE" equals "11/31" then insert "12/1" or If field name "PYE" equals "10/31"
then insert "11/1".  

I have excell spreadsheet for various credit cards (table a, b & c), and
checking account (table d), and want to join automatically so I can run
reports and track categories.  The queries join only the common entries,
while I need all rows.  I like access ability to edit the ...

I have been trying to set the criteria for a Yes/No field so that the user
can choose to see True, False, or both.  The "both" part has me stumped.  I
have tried variants of:
IIf([Yes or No or Both] = "Yes",True, _

I've created a Password in a Query... but I want a mask to be shown when the
user is inputting that password - for example, "*********".

I am trying to create a crosstab or pivot table. I have one table involved
that is used to track dates that employees call in sick. The fields I'm
needing are [ID] (primary key for the table-each "call in" has a unique
value), [EmpID] and [Date]. I want to see the EmpID (rows) ...

I have a database table that has a row called "Company", which may
return different variations on a company name, depending on how it was
entered. For example, it may return one of the following:
WidgetWerks, Inc.

I have an append query that has alot of calculations in it and it takes
several hours to run.  I have tried copying and pasting the data but because
of the calculations it still takes forever to copy.  Does anyone have any
suggestions on what I can do?

Say I have Table A in MS Access 2000 with the following fields: id;
school (humanities, science, medicine) and anxiety(mild, moderate,
severe). I want to end up with the school rows on the left
(humanities, science, medicine) and the anxiety headings on top (mild,

I have created some queries that the user can use to search by adding certain
criteria. However after a few uses the users find that they are asked for the
same criteria twice before the query runs. Does anyone know the reason for
this?

I have a table that list a count of peoples visits along with the State City
and 5 digit Zip Code. I would like to query this data so I can get a
total(Sum) of peoples visits by their 5 digit zip code. This is difficult
because some Zip Codes can have more than 1 town associated ...

This is the result I get with the following query:
RefNumber       InvoiceLineAmount       InvoiceLineQuantity
65914                7.72                            1
65914                500                             1

I have a form that has 5 text boxes.
1) is the start date
2) is the ending date
3) is an expression:=Month([end_date])

Can you please tell me how can I modify this query to identify these 'pairs':
1234A and 1234B; the below query is working when I have 1234A and 1234AX;
the characters before X; or in the first case before A and B are the same.
Thank you,