I have a database with students results in it. Thay are able to retake exams
with the maximum result counting toward their qualification. I am battling to
get a query together which will sift out where there are duplicate module
results as well as selecting the result with the ...

I have a querry that I do not want to  Show ID A1 A2 A3 and so on, I tryed
Not In("A*") but this did not work is there a way to do this without having
to
Not In ("A1","A2","A3")?

All,
I am quite new to Access but have used Excel for a number of years
now.  Most of the work I've done in Access has been trial-and-error
type of stuff.  I've been given a project which requires some Access

Hi I am having issues concatenating a text field. The field contains details
of when a call back has happened. I want to concatenate into one field. I
have tried using the following SQL statement (Thanks Duane) but with little
sucess.

I have 3 crosstab subreports (BarChartData1, 2 & 3), each having a row of
text boxes (Tot7 thru Tot67) in the report footer which display column totals
generated through code in each report and each report is nested separately in
the report footer of a main report. Now, included in ...

Hi there, i have a problem trying to sum some values that are in
certain rows...The table looks like
Col1 Col2   Col3    Col4
-----------------------------------

I'm a member of several networking communities e.g. Wanna Network and
mentioned in my profile that I also have a travel website,
yvettejonestravel.com.
If I try to go to yvettejonestravel.com, it takes me to the comments page of

I need to concatenate the contents of a specific field from multiple records
into a single, multi-line result. I know how to use Chr(13) & Chr(10) to get
the carriage returns & linefeeds. The problem is figuring out how to
concatenate the contents of a specific field from ...

I'm trying to add a column to an Access 2000 DB using SQL. I know that I can
add the "NULL" criterion to make sure that it isn't a required field, but is
there a SQL command for me to also turn "Allow zero length" to be yes?
Thanks.

I have downloaded a zipcode database and want to use it to find mistakes in
my table with 20,000 records. The zipcode database sample records as
follows: (ZipID is auto number primary)
City                        State    Zip        DefaultCity (Yes/No type:

Hi. I have a database (a table) with 2 fields : the name of a member and the
name of a viewed movie. I try to obtain the list of movies that a member have
not seen yet. In my table, I have added un false member that have viewed all
the movies. To identify the membre for the query ...

How to speed up querying of 1 million records in a table? I know websites do
this all the time with their data.  How else does one of a million bank
customers log in to their Bank of America account in a matter of a second (or
less!)

I have been searching the net everywhere and have not been fruitful as yet.
I did find formulas to determine distances but when i put them into an SQL
statement they cause errors. it appears Access spits the dummy if you have a
calculation that is too long. I first tried it in MS ...

Is there some documentation somewhere I can reference for more information on
2 things:
1) The Jet Expression Evaluator (what functions & stuff are actually
available within Jet Expressions?)

In a sample database, I have the following query.
SELECT Null As Title
FROM tblDummy
UNION ALL SELECT tlkpTitles.Title