Greetings!  Could use a little orientation.
Given a table Events:
Event    SomeDate
A          4/1/07

i am trying to get the 18 out of this description field and store it in a
new field.  its a pretty consistent string but the number is not always two
digits.  all i can think of is parse whats after the 3rd comma and the
/(slash).  in this case 18.  anyone have an idea on this.

I am trying to create a query and can not get it correct!
I am trying to do a select query on one table using access 2000.
I am trying to look back one record in order to make a decision on the
record I am processing.

I have lost a lot of data in my backend, but
it is only data from a few columns, in one tabel, that I have lost.
My tabel is called taCustemor, and the columns in that
table is called fakFirm, fakAdress. I have use a custemornumber

I have an application that's been running with few problesm for a couple of
years.  Twice now, a table has gotten subtly corrupted so that a select on a
query doesn't work properly inside of code, but it does work in the query
builder.  By not working "properly," I mean that it ...

I have the following TSQL query and am trying to convert it to MS
Access.  It doesn't seem to like the fact that I have multiple
conditions in my join statement.  I've experimented with the syntax
quite a bit but can't make Access happy.  Any suggestions?

Hello all, I need to create a table in code with dynamics columns.
Anyone do this before?  can i see a sample many thanx

On attempting to first set up a switchboard (tools - database
utilities-switchboard manager)
the message 'There was an error compiling this function'.
Nevertheless 'Switchboard Items' is created in the tables section.

I am looking for a little help using multiple radio buttons on a
dialog form.  Based on the buttons a user selects, I want a form to
open using the selected parameters.
For simplicity, I have a table that has 10 fields, 3 of which are Y/N

I would like to have my query find the largest number in a field.  I'm sure
it is very simple, but I'm having a "Brain Fart" and can't remember how to
do it.  Any help will be appreciated.......

I had a running sum calculated field working in a query recently but tried to
reconstruct for the following type of table (have a query first to arrange
the data called qryCumulative, query where I'm trying to add the cumulative
field is qryCumulative2)

I'm trying to make two fields that are similar.
I create but it won't give me the result.
FieldA :      Baseball
FieldB:       Baseb

I have a table [USGS RAW NO TITLE] set up in access with water flow
sites.  I am trying to calculate 7-day moving averages of flow for
each day limited by the site (3-days ahead and 3-days behind).  I
think I have the expression working right on a 7-day moving average:

This is my query named "spVOC_Sp_Example_search" in Access 2003:
PARAMETERS [pSearch] Text ( 255 );
SELECT Example.Example
FROM Example

Hi out there
ready to throw access into the main road!
we have an update query that adds data into an empty table from a ever
changing original table, it works beautifully first time but then