I want build a SQL query to generate statistical result from
table(students) in MS Access as below:
Student# City Amount
001 toronto 1000

Each record in this table is a combination of several strings.  Each string
contains a user name.  I need to extract the user names from these strings.  
I know how to extract it form one string but I don't know how to make it
repeat the action (with a loop or something) to get ...

I have 2 tables that I want to do a join query on.  Both fields in the table
are text, but with numeric data.  On one table the data has 2 leading zeros
and on the other this is omitted.  
What is the best way to join these two fields?  Is it with a like statement?

This Works.
SELECT invoice_h.customer_id, [Promopoint List].Heading,
Sum(invoice_d.ship_qty) AS SumOfship_qty
FROM customer_type INNER JOIN ((([Promopoint List] INNER JOIN

My membership database contains a table for annual membership contributions.
I record information about each check received, as well as the membership
"season" which it covers.
I have set up a multi-table query to give me the names and addresses of

I have a table that has 4 columns which contain dates.  I set up a query that
has those dates in it and want one parameter to search for the date ranges in
each of those columns.  
So basically I want to be able to type a beginning date (i.e. 1/1/00) and

I've read the Help topic about what isn't updateable and queries with more
than one table usually falls into that category.  But I am trying to do that
and need help with the code.
I have a table of NoShows (we log when a client doesn't show up for an

Suddenly, my queries in an Office Access 2003 database displayed "invalid
argument".  Is there any easy way to trace the problem area where causes the
issue?
Thanks,

I ran a query to calculate the cumalative totals by day. Here is the statement:
SELECT DailyQuantities.ItemID, DailyQuantities.EndDate,
DailyQuantities.QuantityCompletedDuringTimePeriod,
DSum("QuantityCompletedDuringTimePeriod","DailyQuantities","ItemID='" &

oh oh,,
May this be doing?  Under the main form when the code is running ... to
insert the code docmd.goto next record between of the code to make the
subform move the point next record.. ... as so Think of the command button on

I have a cross-tab querie that is working fine.  The possible row headings
are 1-10.  Of course, if in the data there is no data for, say the row
labeled "3", there simply will not be a "3" row in the output.
However, I'd like to get the data into a report that has ALL the ...

1.  Make table query produces a placeholder field TMPNUM set to 0  (eg.,
TMPNUM: 0)
2. Append query appends a value in TMPNUM = 71.58
3.  What shows up is 71

I would like to import the NDX 100 index daily into an access db. The web
query to get at this data in excel format is:
http://ichart.finance.yahoo.com/table.csv?s=%5ENDX&a=09&b=1&c=1975&d=06&e=7&f=20
05&g=d&ignore=.csv
The end date would change daily...What would be the best ...

I need help in designing and creating a select or parameter query. The
table has a date field which will need to be is a comparison with
today's date. There is one other date that needs to be considered.
This is the date that is three years from the date in the table. (1)

I need to know what the sequence number of a record is without refering to
the navigation bar, so that if records are deleted I can tell when browsing
what place number a record  lies in out of the total.  If I could interogate
the navigation bar all would be great.