I have a stored procedure on my SQL 2000 Server that I would like to call.  I
am using Doug Steele's DSN less connection for the database.  The Stored
Procedure has two paramaters to pass in.
The SP calulates the number of points someone has earned by month.  I would

I need to take a field that contains a full name in the LastName, FirstName
format, and separate it into two separate first and last name fields.  Can
someone stear me in the right direction for this?  I know I saw it in the
help files once, but I can't seem to find it now.

I have a column in a query that represent days the field look like NYYYYYN
I would like to have the formatted to –MTWTF-
Can someone    tell me how to do this?

I have a linked table with a huge amount of data.  I created a query where I
would type in the criteria I wanted to pull.  This took approx 30 seconds
which for my purposes I was okay with.  However, I am now trying to make this
process an automated process, where I can push a ...

I'm stumped. I've suddenly become unable to edit queries. I went in to make a
simple change to a query I've changed before (as in yesterday...), and
suddenly, I can add a new table to the query builder, but I can't drag a join
to the table. SQL view shows the table has been ...

I have a 'simple' concatenation of 3 fields with a comma before the 3rd
field:  "FirstName LastName, Academic"
I would like for the finished string to read; "Jane Smith, PhD"
howevever, I've discovered many records have zero-length strings in the

I have a table named StudentMarks as under:-
Roll No     Name         Total Mks (1000)
001          xyz              775
002          abc              665

At the bottom of the left folder pane in Windows Live there are several
icons, including: Mail, Feeds, Contacts, Newsgroups, Messanger.  But, my
calendar from office live does not appear.  I also have a calendar through
gmail but I can not get that to appear either.  I do not ...

I've got two tables.  I want to perform a LEFT JOIN between the first table
and a subset of the second table (so that each member of table1 has no more
than one match in the subset of table2).  If SQL understood my randomly
generated syntax, it would run the following:

I am trying to get rid of results coming back that are the same:  Explanaition:
I have a member that has 5 records.   I want to get the 1st 2 records (they
are numbered 1-5) as long as they are NOT the same.  (dups happen due to
address field containing the same address, but diff ...

I am a novice user, and know how to do simple queries.
I have a table of 1,500 records, and would like the ability to select
individual records for a report.  Say, for example, I want to print labels
for records 1, 432, 765, 134, and 1487.   Those records may have nothing in

I have a query that returns accounts and balances.  I want the query results
to return each account once, but total the activity of the accounts appears
multiple times in the database.  An example of the data currently returned by
teh query is below:

Who can give me advice?
In a table I am storing the information of apartments and their total
surface area in square meters within a building.
When I select an apartment within a building in a form, I would like to

I want to update a column with a update query, the type of the field is text
and I want to change a .(dot) into :. If I run the query I get no result. It
should not be that difficult. What am I doing wrong

I have Microsoft Access 2000 on this computer but I dont find that the help
describes Jet SQL functions.
Some searching on the Internet reveals Jet SQL functions but these are the
usual Group Aggregate functions : AVG, MAX, MIN, SUM, COUNT etc.