I am trying to parse a text of the type: "Diabetes; COPD; LDL". I want to
extract Diabetes and CPD and LDL from this string. In excel you can use left
(or Mid or Right) alongwith FIND function to locate the seperator (; in the
examle string). But Access does not recognise FIND ...

I can see a lot of people have posted about this topic, but I couldn't find
anything to help me.  I have a query based on four tables:
1.  Projects
    ProjectID*

Good Afternoon,
Got a rather complex brain teaser for you. Please review my sample data....
TableA
LNAME        ADDR1          ARRIVAL             DEPARTURE        CODE

It seems no one can correctly help me with my problem. So I try it again and
now in this topic.
I have a table with muliple fields (columns).
In one of these columns all rows can contain only 3 different values: for

ost ocity dst dcity shipdate  paid amt    transport amt
A    B       C  D      1/1/07     7888           777
E    F       G  H       2/3/07    733               887
I     J         K  L      4/5/08       998             756

I wonder if i could get some help with the following issue with the date
When i do query as below
mycurrdate = Format(now, "d/mm/yyyy")
myWeeklyIDCounter = DCount("[WeeklyID]", "WeeklyReport", "[Student_No] = '"

I have created several queries and now I would like to rank my result to
only get the TOP 10 percent.
Could you please assist me with an Access SQL statement that can accomplish
this?

I have a query that appends data to a table.  This works fine however I only
want new records that have been collected to be appended - at the moment it
keeps appending thousands of records every time the query is run.
I do remember reading something about this but I have lost ...

Using Access 2007 - By reducing the width of columns in Design View manually,
I was able with Access 2003 to print on a single page.  How can I do it with
Access 2007 ?  Thanks

ignore

I have table which has the results of various contests:
Year  Team  Result
2007  A        W
2003  A        L

I need a query (and where to place it) the counting the numbers of days
between two dates (not counting weekends)

Hi I have a query that looks at a detailed transaction list that includes
account numbers, transaction time/date, amount of transaction etc.  I need to
find out the time elapsed between transaction records with the same account
number.  Since there are hundreds of possible ...

Hi I'm new to Access and I'm trying to create a simple report that contains
multiple medical and certification license expiration dates.  How do I create
query for all of the criteria for anything that would expire from today's
date up to 1 month out.