Here's the SQL:
SELECT tblEventResults.fkAthleteID, tblEventResults.EventResultsID,
tblAthletes.School, tblEventResults.FinalPlace, tblMeetEvents.MeetEventID,
(SELECT Count(*)   FROM tblEventResults AS T WHERE T.FinalPlace <  

The runtime is once again available...
http://blogs.msdn.com/clintcovington/rss.xml

We have contact data sitting in an SQL database and I would like it to be
viewed and updated live in Outlook. Is this possible? Is Access the correct
method to do this? How do I "double link" a file in Access so that it is
linked to an SQL database AND to outlook?

Access 2003
I have a make table query and one of the field is a $$$ dollar amount.
I set the properties to "currency".
However, in the table, the field type is "Number".

I have an issue where the users are cutting/pasting text, from emails, and
Access is returning an error that the field is too small to accept the data
they are attempting to 'add'.
The text is obviously not too long, so I am assuming that there are unwanted

Why it is when you link an Excel Sheet as an attached table that you can not
change the data from inside Access which modifies the Excel Sheet?  What was
real strange is I could do this but now I can not?  Any Ideas why this seems
to be set in read only mode?

I have a field labeled Messages in my database. The way data is entered has
been switched recently, and so now data is entered via a website. I noticed
that when I ran a query on the data, the entries that have been made by the
website the data has this <P> at the beginning of ...

Why does Access 2007 all of a sudden shrinks the database file  size
specially when migrated form and older version??
moreover, when access stops responding, it created another file named
filename+backup which is the same but smaller in size????

I hope this is the same community at the one accessible via Google Groups. I
just noticed that the Google Groups one has not updated since yesterday.
I have two tables. Listings and Loans. Some Listings become Loans, but when
I get the data I am not supplied with a key to link the ...

I have a combo with 3 rows.
In Afterupdate I have:
If combo = 3 then
  TextboxXPTO.Enabled = False

What I want to do is set up action buttons using my own warning message. EX .
Please verify that you have moved file before deleting"  instead of "
relationships that specify cascading deletes are about to cause 1 record(s)
in this table and in related tables to be deleted" .

Hello Experts,
I have a report that based on a query.  The query adds up my monthly hours
for the people that work on the project and the report displays the result.  
my formula in the query to calculate total forJanuary for example is 07Jan:

I have an access database which I cannot open. The message I get is "The
Microsoft Jet database engine stopped the process because you and another
user are attempting to change the same data at the same time."
I make some search and found this problem is due to a corrupted ...

I am intermediate when it comes to building a database. Unfortunately, what I
need either goes beyond my knowledge or I just forgot how to do it.
I am building a db for my business. The db is not online, just for me to
keep track of items, costs, expenses, so on and so forth. ...

I am trying to add a new record from the a parent form to child form, but
when I click the button in get the following "expression to you entered
refers to an object that is closed or doesn't exist"
here is my code