Hi. I have an Access 2000 database with two tables (customers and sales). The
table "sales" contains a field (CustomerID) which is linked to the CustomerID
in the "customers" table. I want to create a query where I get a list of all
my last sales for each customer. The way I ...

I just had something strange happen...
Last Friday all was well with my Access (2k) db.  I have [primarily] code in my
'code' db and data in my 'data' db.  (All tables (4) for this task are in the
data db.)

I have a subquery which is running very slow.
here's my SQL statement:
SELECT s.CCC, s.[91+]
FROM qrytagbyccc AS s

Hello, Hope someone can help me.
I have a table that has 2 columns: "Name" and "Fee".
I would like to add another column Named "Result" that will show +1 if the
Fee is positive and it will show -1 if the Fee is negative as below

Hi. Can anyone help with this please?
I have a field called Image which contains the path and Image name e.g.
C:\My Documents\My Pictures\Mvc0000.jpg
If I have this field called up in a query, is there an expression I can put

Dear all, looking for some suggestions/help ...
I am trying to create a time-table data base for school
I have a years table, periods table, days table, teachers
table and subjects table

I'd like to specify which fields I'd like to export to excel (for mail merge)
using check boxes in a form.
I.E when check box for surname is ticked, surname is exported. If not
selected the surname field is hidden.

Thanks for the help. I'm using Office 2003. I just created 4 queries to find
the most recent payment on 4 different credit cards. Now I want to create a
union query to compile the data into one location.
Problem:  When I copy the SQL syntax from each of the queries I get this

Just wondering if MS Access can format the data presented to an SQL query.
For example, if I have a table with 10 digit telephone numbers and I store
only the digits, is there a way to tell Access to format the column as (###)
###-#### so that SQL queries on that column (with no ...

I'm trying to achieve the following SQL in an access database. However i'm
having trouble porting my SQL to a suitable format which Access understands.
I'm trying to insert a row which has two columns, one is a value which is
assigned using my VB .NET application, the other one is ...

I have a database containing an action query.
When I open this by double-clicking the mdb file and double-click the action
query to run, I get some message prompts from Access (I know which prompts
are shown depends on the options selected in Tools-Options-Edit/Find-confirm

Is it possible to have a parameter query where I select the options from a
list rather than typing the options?  If so, may I know how to construct it.
Thanks,
Ray

I've got 5 queries, all doing the same thing but seperated per client, each
off the back of a seperate table for each client. I want to combine these
queries into one table or query for reporting purposes but I wouldn't have a
clue where to start, does anyone have any ideas?

Um... LOL.. in one of my queries, i sorta.. well.. i ran out of columns
in the design grid.
Im using MS ACCESS 2000.. is there an option in the menu that will
show me more columns or add more to the grid?

I'm working on this database in which I have 2 forms:
one form has personal information (PersonalInfo)
and the other one is a search form (Search)
In the search form I have a field in which I want to type any part o