i want to match two table fields but one of the table field only matches at
3rd column and the succeeding 6 characters. Is these possible with ms access.
Please help.
thanks.

I have 80 patients that I wish o form a database including their demgraphic
data, medication and illnesses, how can I perform this with access?

whenever i put in someones b-day, say from 1900-1930, (ex. 01/20/24) it
always comes up 2000-2030. I try to delete it and manually put it in however
it won't take.  Help! I

Hi;
I am using Access for some simple work, but now i have lost
a lot of information (several objects). I believe they still are on
the computer, but links are gone.

Can you have autocomplete function in database fields of Access?

I am trying to build a database where visitors on my website can submit
there photos. That is easy. The problem is that I would like them to get the
opportunity to vote for the pictures also. I guess I need two tabels one
where the results is shown and another where the counting ...

Due to installation issues, I've had to convert a VB application to an Access
VBA application.  The resultant Access application process the data much too
slowly for our requirements.  Any suggestions or references on speeding up
Access apps would be greatly appreciated.

I have a two-part question to anyone kind enough to answer.  We just upgraded
from Access 97 to 2003.  When converting my 97 FE and BE database to 2003 I
get the following message:  "After you have converted this file to Access
2000 File Format, the new file cannot be shared with ...

Our development team is evaluating the future use of Access for development
purposes. We have a number of applications written in Access 2.0, Access 97
and Access 2000. Many were written by users or outside agencies but we have
to maintain them. Some members of our team are ...

I have created a small database using access. Can anyone
tell me how to make it into an executable file so that i
can have the main form set as a first interface of the
system for the user. i have split the database and made

hi i have created a small database and have used
validation rule for an inproper input. but i am getting
the message box from access software. can any body tell
me how can i make this message box come from the system

I know absolutely nothing about PowerPoint but it is my turn to submit a
group PowerPoit presentation by next Wed. nite.  where would be good place
for me to start?

Hello --
Windows XP Home edition
Access 2000
I have a form which can pull its records from a query or a table.

I have a database of name and addresses and I want to count how many
instances of each incode (the bit before the space) there are.
I already have this working in a separate database using this SQL:
SELECT Left$([post_code],InStr([post_code]," ")-1) AS Incode, Count(*) AS

That Date funtio worked fine except it doesn't do what I thought it
would.  I need the Query to return any item [Product] that has not sold
anything in the last 20 Days {SaleDate].  I have the Date part OK now
but I'm still seeing Products that Have sold within the last 20 Days