Sample
Start time 6:00am end time 11:00am
HoundID    JudgeID        TimeScore    Score
333        2        9:00        35    keep and count

Hello again,
I am trying to insert th last date and last balance for a given month/year,
from one table to another with the following query :
INSERT INTO TempBalance4 ( Date4, Balance4 )

Is it possible to create a specific sort order in a query that's not
necessarily alphabetic or numeric?  For example, I want to sort a list of
items in a specifc way:
Laptop

Here is the deal. I would like to create my own vb function to use in the
experession builder in Access 2007. Is that possible? One I want to create is
to determine a week number. I know I can do this in the table but I am
working in a quiery.

Here is my dilemma, I have a table with either one or two asterix in a
column (the same column).  One asterix signifies a different outcome than
two.  When I try to count one asterix and/or two, it adds them all up.  Here
is the SQL view:

Could someone please explain why this happens and a possible solution to the
problem?  I am using ACCESS 2003 and the query type is "make table".
This query works within a Select statement.  If I use the below code, all is
well.  

I am sure there is a simple answer to this, but cannot find it. I want to
create a query to simply count the number of calls name in a day.
I have tblcalls with callsID, contactID, df1, notes,
df1 date stamps the record and I simply want a 'count' of df1 for Now()

I am trying to run a group query Where the date is Now() and want a count of
date to show the numbers of calls made.
I have tried the obvious:
SELECT tblinvest_calls.contactID, Sum(tblinvest_calls.df1) AS SumOfdf1

I have a table with 50K records in it. I have only selected 5 columns within
it which are:
Plant CD
Plant Name

I have the following tables:
1. Location
2. Server
3. Results

Okay, I have created a new database to track sales agreements and generate
quarterly invoices. Each agreement will have at least one but possibly dozens
of "licenses" assigned to it. These licenses are issued in one year
increments (for the most part) and are billed at a ...

I'm trying to summarize similar data from two tables in one query but am
having issues when I bring in the second table.
I have an activity table, with storeId, activityDate, activityA and
activityB.  I use two reference tables (dateRef, to roll up activityDate into

I am looking for a query for a report that will give me the number of each
specific product model which have been purchased by any and all referrals of
an affiliate.  
I have among other fields, fields in my affiliates table for affiliate number,

I've got a query (StringQuery) that returns several string fields from
a table, one of which is a string representing time (in hh:ss
format).  I have another query that uses this query as its source and
which I want to filter the results based upon my time field (ie. all

I am trying to do a union query of two other queries.  Both of these other
queries are "built up" from lots of preceding queries, but it seems that the
more complex of the two is the one causing the problem when I try to run the
union query.  When I try to run it, Access wants to ...