I am trying to set up a commissions report.  
Here is my commission qualifier:
If the $ value of the items sold  (this is a calculated sum) create a total
sales amount of more than $2000, commission is due.  If it is less, no

Have had a good look through various discussion groups for this and can't
seem to find what I am looking for, I hope someone can help.
I have a access 2000 database which captures projects coming into the
department, each project is then resourced to a team member. When they have

I intentionally tried both conditions but MsgBox does not start. Where did I
do wrong?
Private Sub cboFrom_BeforeUpdate(Cancel As Integer)
   If Me.From < DMin("TimeIn", "qryVisitData") Then

How do you edit the column headings in a Union Query?
I cannot get the normal Design View that would enable me to do this - I can
only get the SQL view.
Thanks

I am converting the following query from SQL Server to MS Access.
The following query fires a 'missing operator' message within my VB IDE.
strSQL = "Select w.empID  " _
   & " FROM tabEmp w INNER JOIN tblArbCtr c ON w.empID = c.wrnID WHERE " &

I need the following translated into functional SQL:
Select * FROM tblHCounts WHERE
RCD_NEW = 'N' AND
(RCD_CHG = 'N' OR RCD_CHG = 'n') AND

I have a field [DeptNumber].  
Some of the [DeptNumber] are 1, 2, 3 or 4 characters.  I need to make this
field 4 characters.  In other words,
2 would be 0002

I have a 2 column table called tblstorecat. It has a text field and a
corresponding number field: storename & storenumber
I have a data entry form that has a text field called title. When a user
types in the title of the product, I would like to populate another field, in

I am running a crosstab query however the column heading with the dates is
not in order. Instead of 1-2005, 2-2005.etc, I am getting 1-2005, 1-2006,
1-2007, 2-2005.
How can I get the dates to run sequentially at the top? The SQL code that I

I am trying to develop a query where my client wants to track how much
time in minutes does a nurse spend in various activities (staff
education, patient/family education, answering drug relation questions
etc. etc.) to assist nurses in other units. What query type should I

Good Morning,
I have an annoying thing i am trying to sort. I am creating a report using
access to format the data. I am trying to give an hourly breakdown of
results. In my data i have a "CallDateTime" which records data in a

I have a form which generates records in a table on "close".
Every time the form is closed it generates another set of records.
Therefore, I end up with many duplicate records in the table.
I created a "Find Duplicates" query which works perfectly.

How I can make parameter query which asks user for either Null or not Null
values (only two options) and then assign this parameter to a control on a
form as dialog for inquiry, to run the form or report afterward??
Lets give you more details;

I need a query where I calculate the net profit (or loss) in the given
transactions. So, I have to sum up all the positive value transactions
and subtract (actually add since the sum here will be negative) the
sum of all negative value transactions.

I want to know how to structure (design) a database that conforms to
"double-entry" standards.
I am just looking for a starting point, or guidance in the right direction.