Hello -
I have a query that sets criteria on a DATE field to pull data from the
previous day (if yesterday is not equal to sunday), and if yesterday is equal
to sunday, then it will pull data from friday - sunday.

I have a product list.
Their names are like,
XYQ A2AJCJ AB
I must find products that are same, but only the for example 21st character

I have data for 01/01/05 to present.  I want to show only the data for
certain months for 2005 only but I keep getting both 2005 and 2006 data
coming up.  I tried using "Between 01/01/05 and 02/01/05"  with no luck.  I
have tried using >01/01/05 and <02/02/05 with no luck.  

I am having trouble getting my queries to accept drop down menus for the
users to search for what they want to enter in the parameter searchs.
In my tables there are drop down menus already created, but when I go into
the properties of my query and select combo box, value list and ...

I have a continues form based on a query and I want to be able to update the
records but never to add new records (From this view).  My question is how
can I get rid of the last blank line in my form (the one to add new
records)?

I am hoping someone can shed some light on a problem I am having. I am
using a script to write some properties to my *Message* table in an MS
Access DB. That is working fine.

I need to concatenate 3 fields where all the fields are number format.
The problem is this - when concatenating them I lose any leading 0's that
may exist in the original tables even thought ive formatted them as for
example 000 to make access put in the leading 0's.

I have select statement that is pulling up 'masked' password fields.
How do I re-write my query so that it will decode these masked fields.
Thanks

Ok, I want to create a query that pulls specific names out of a number of
fields.
I have 7 fields labeled, Operator1,Operator2,etc.  all of these fields are
drop down boxes which you can select a specific operator/Employee who ran a

I have an A2K database with links to Excel spreadsheets.  When I import the
data, I would like to split the address field up into Street Number, Street
Name, and Miscellaneous.  The problem I'm running into is that the data I'm
getting has numerous formats, looking like this:

This is just a HowTo. I am more than likely putting this out here
because someday I will forget how it is done and want to come back for
a refresher. Or it could be that I want to help others, you be the
judge.

Anybody has done or put a File Browse button on a MS Access Form ?
I was trying to use the MSDialogbox, but seems not working
I am using MS Office 2003 on Win 2K
Thanks

I would like to know whether or not it is possible to create a query which is
displayed as a series of combo boxes or list boxes where the user can select
which options they would like to choose.
I would like to have the option for the user to choose about 5 different

I have a table storing the quiz data of the students like this:
Date | Time | Name | Grade
I can show the data of specific student by the query below:
SELECT *

When I have a table in a database and try to open a new query using the
wizard, the error comes up twice saying there is an error on loading DLL.  I
have tried all I know to do.  Take Office 2003 Professional off, put it back
on with full application installation, use the cd for ...