i have a form that does not multiply correctly. i enter Quantity, UnitPrice,
check Expendable (if needed and this adds 10% to the UnitPrice). then the
UnitPrice and the 10% are added together.. everything is fine. I then
multiple the UnitPrice (which goes to NetAmount) by the ...

I am trying to create an expression in Access to calculate the following...
If [Total Commission] > 20000 then ([Total Commission] - 20000) * [% Profit
Share]
How do I create using the > sign and then calculating from there to get my

Good Afternoon!
I have a table that has two fields representing the date as follows:
ReportingMonth (numeric 1-12)
FiscalYear (20072008 for FY 2008)

I have a field in my query that has a combination of letters and numbers. In
the table from which the query is derived, this field is formatted to have
all letters capitalized (>) and I have the following input mask: LA0000. In
my query, the letters aren't in caps. I'm concerned ...

I'm having the following issue: If I create a function that reads:
IIf([Inc_Date]>=#9/16/2007#,"New","")
the function works properly, regardless of whether [Inc_Date] falls in
September or October (I'm creating this post and running this query on

Although I have a few books on MS Access I have not come over any topic that
discuss the aspects of speed when creating queries.
For example, in my case I'm doing a "simple" query that draws the material
from several tables (some very large), most tables are linked (ODBC) and the

I  need to build a query from 8 or 10 other queries so that I can build a
form from all that information. The 8 or 10 queries are based on (total)
probably 15 different tables. I can build the query ok but it has 800,000
items in it and runs slowly. I don't want my form based on ...

I hope this makes sense.  I have a database that has a student table as
well as an interest table.  Each student can have multiple interests.
When I run a quesry to find students interested in a certain area
(interest), the results give me a student record for each interest!  I

I'm trying to produce a database will be used to track all the contracting
agreements we have with our clients. At the heart of the database are two
tables (tblFarms and tblContracts) which are related one to many
respectively. Each farm may have many contracts but only one of ...

My boss has asked me to create a query to find for example all songs by an
artist in a CD Collection database.  The query can only retrieve some songs
for some artists and no songs at all for other artists. I've checked the
query which seems ok. I think the problem could be ...

I have a calculation that I have made to work in Excel...but I realy need it
to work in Access.
I need to calculate from the number of hours a machine has been run, when it
is due for its next service.

I am getting an overflow error when I insert an unbound textbox with
calculations.

I lost my query design grid-it is not showing up.  I can only see the
selected tables and relationships in the upper part of the design screen -
any idea how I can make the grid display?

Databases processing SQL return a count of affected records.  For action
queries this is useful information. An update may be syntactically correct
and be processed by the database, but will affect no records and a lot of
records. Is there any way to retrieve this record count in ...

I'm trying to build an expression in a query that will test two fields and
reutrn a value based on the  following logic:
*******
If the 1st digit of the LeaseNum field is "S", and