I have a query that has as one of its fields Total Sales, what I need to do
is add another field called Bonus, however the bonus differs depending on the
amt of the Total Sales.  So if a salesman has sales of between $250,000 and
$350,000 his bonus is (Total Sales/1000)*.25, if ...

Is there a way to automatic reply to the update message you get when
updating your records??

I have a form with start date and end date parameters that the user
can input to run a query. I would like the query to be set up so that
null parameters means to ignore that constraint. That is to say:
if a is not null and b is not null

Hi all,i am a new user of access,i am now using access 2007,i wanted to link
the 3 tables together,to create a query that will returns records of
company,part number,description,selling price and date of purchase.below are
my tables in datasheet view;

I'm fairly new to Access.  I'm using 2003.  Here is my situation:
I have 2 tables: public_po, and local_po.
public_po is an ODBC source from our backend system that is not editable by
me (nor do I want it to be).  It has a unique id field "order_no" and several

I need my query to append to an empty table and have a field that will
contain 1 for the first record, 2 for the second, 3 for the third, and so on.
 If this cannot be accomplished with the append query, is there a way that I
can run an update query to seed this field?  All I ...

How can I remove the last character?  I have a table that lists account #s
followed by a comma.  I need to remove the comma.  For example:  123400,   I
need the "," removed and the account #s can be anywhere from 1 to 11 digits
long.

I have a query that pulls all the records from a table.  For example,
the query outputs the following:
TITLE               REV              POSITION         DATE          
methodA     /    0           /       tech          /      july 5

Hi--I'm new to the group and pretty new to Access.  I'm trying to get
a grip though, but this problem is making me crazy.
My problem, in a nutshell, is that I return a query in which all the
occurrences of a certain field containing RB or FB come back to me

I have a field that has vendor numbers, (115, 3245, 10987, 111,234, etc.).  
Is there a way to runa query that will add zeros to the front of each vendor
number until it is 10 digits long.
I want to see the following:

I have a query that I am trying to pull out only the Club Members that
have Remote Access.
I thought this would be crazy easy and the information that I have is
not accurate.  Please Help!!!

I have an account # table that I use from a different source.  The problem is
that there are two characters that are placed in front of the account numbers
that I need to remove.  For example, the actual account # is 123400; however
it is listing it as 1=123400.  How can I remove ...

I've got a query that is based on a massive SQL table (use an ODBC link to
the SQL table).
The query works fine.  However....it seems unnecessarily sluggish when
scrolling down the list of returned records.

I currently have a form and the path is [Forms]![SVP]![SVP]. I have
created a form with a drop down list that queries my main sheet for
all the possible fields. I cant seem to figure out how to write an
expression that allows me to leave it blank and then return all fields

I created a query that is linked to a form where I created a drop down
list to choose which values to include in the query. Currently, the
form works when I am trying to return only specific values but I
cannot figure out how to return all values.