I want to return records in a query in the order of my criteria. I have
some duplicates.
For example   3,4,5,  4,3,2,   45,44,43
Access is returning the records but omitting the duplicates which I

How can one calculate te best, second best, third best ect, places in a query
using the swimmer time and then attach a value to the place to determine the
pionts of each swimmer during the meeting [Ex fastest time =  place 1 - place
1 +11 =12 points, second fastest time = place 2 ...

I have a table containing a variable number of records and wish to update a
particular field in the first record of the table - but only in the first
record.  This would be easy if one of the fields in the first record
contained a unique and predictable value which could be used ...

Okay Here is a good one, I bet it is an easy one though.
I have two fields for Time Entry [StartTime] and [EndTime]
I used general time entry so I see 11/03/06 02:30, now I want to create a
query that will display only entering a date 11/03/06, all entries for that

I want to return records in a query in the order of my criteria. I have
some duplicates.
For example   3,4,5,  4,3,2,   45,44,43
Access is returning the records but omitting the duplicates which I

I have a league table that works fine, but I need to attach a position field
(1 to 12) to it, that updates every time the positions move. Any help would
be appriecated.
Thanks

I have a problem with a clients' ledger calculation in circumstances when an
amount or amounts of money have been received but nothing has been paid.
The following calculation in my report in a text box calculates the
following -

My Tbl_Main has a Primary Key, a secondary key called Category and
several other fields including one for Cost.   All entries are in one
of four categories, A, A1, A2 and B.  Category A, effectively an
umbrella category, deals with situations when expenditure on A1 and A2

Hello,
I have a table where there are 0.00's in column one and 0.00's in column
two.  when I run my query, I want to be able to see the information without
the 0.00 in column one and two.  Example:

Is there any way to place a comment inside the sql of a query?

These are probably simple and I appreciate the patience of everyone.  Yes, I
am trying the "search" with no success so far.  I'll try to explain in more
detail below, but the basic questions are as follows:
1.  How do I simply get the crosstab to show all rows/columns, even if ...

I want to Append and or Update a table. Do I have to have two seperate
Queries or can an Update Query do both?
Matt

I created a query with the same table twice. They include different data but
the ones I am interested in are the date and status (status being in or out
of the water and coded as 1 or 2). Anyway, as I mentioned I created a query
with the same table twice, where using a line of ...

Can someone explain to me what this code is doing?  I have worked with
arrays in C++ but not VB.  I don't know the VB code meanings.... A line
by line woud be very helpful.....
thanks

I have a table with 4 columes of CustomerID, Date_, Number_, reset_, and
having the following records,
1001;01/09/06;2;no
1001;15/09/06;3;no