I have one table (T1) with customer (Nr), amount type (Code), amount (Sum).
Values for code: S - amount, A- discount for amount.
How to create query what calculate [amount - SUM(of discounts)] for each
customer ?

I am trying to generate a report using two combo boxes to select the search
fields and two text boxes to be the search parameters. This search feature
previously had only one fiield selector and one search parameter textbox and
worked OK. Now I am adding a second search parameter ...

Hey guys, hope someone can help me out here...
I have a single table with roughly 12,000 records. Each entry has a period
in which it was made (periods in occordance with our company calendar Period1
is October thru Period12 which is September), also each entry has a Week in

Hi I am a new user to access 2007 and I'm having the following problem.
I have a table called "TBL_Man Process Details 1" which includes the fields
"Material A Description", "Material B Description" & "Material C Description"
I then have another table called "TBL_Raw Materials" ...

I have several tables linked to a main table using a unique reference.  Each
table has a credit and debit field.  I have created a query using the main
table joined to the other tables (using the unique reference) in order to
calculate the total credit and debit balances.   ...

I know this is probably basic stuff, but I never could get the hang of
subquerires!
I have a table which contains a plethora of data, all realted to a date
field (JD). I also have a verision field. (VERSION)

I am wondering if anyone knows how to put comments in the SQL statements
within Access queries. The usual syntax is '--' in the beginning of the line,
but that doesn't seem to work in Access.
Thanks.

I've made a make table query and I have column 'A' with expression
builder.It sort Descending.
The expresion calculate values from some field.I want to return
the top 10 highest number only.Ex : I have 300 record and the value

How can I merge two data in two different data records into one data?
In data table,
Name       Test_1
AAA      result_date1

I am running Access 2003. I created a query that prompts the user for
the initials of a person saved in a field called primarysource. I
entered [Please enter the directors initials] in the criteria field.
This works fine.

I have data that comes from an external source. Every now and then they
forget and have quotes for inches in the description.
I want to setup a query that checks for " quotes.
I can I do this?

I have created an Access database that is designed to send an E-Mail
out to a new student's advisor. As part of this database, I have
created three tables. The first table assigns an ID number each
student advisor based on campus. The second table is designed to

have a simple select query to select rows by date entered..have data rows for
3/15/07. When use criteria of <=3/15/07 (or even =3/15/07!), I dont get
returned rows. If change to <3/16/07 I get the 3/15 rows...never saw this
before..

Within a query, I'm looking for the function (should it exist) that returns
the number of occurences a particular string appears within another string.  
Akin to InStr, but returns the quantity rather than the location.

Is there a solution for the following?
I would like the following Crosstab query to display the months in numeric
values starting with the current month as "0" the previous month as "1" and
so forth instead of the "yy/mm" format. It will be so much easier for me to