I used the dupicate wizrd in Access 07 to find dupes in my table; I have 5
columns:  student id, courseid, semester, grade, and course year.
I identified the duplicates using this:
SELECT [studentid] & [courseid] as studentcourseid

So I've got a form based on a query with user input criteria - no problem.
However, on asking the user for input, is there a way to restrict his/her
input by certain lookup criteria, i.e. to only look up the value necessary
for an input field from a certain table. A drop-down box ...

I have a table, time (GMT +9) looks like this
11:25:00 AM
01:21:12 PM
03:12:00 PM

I am trying to rank customers based on sales.  I created the following query:
------------------------------------------------------------------------------------
SELECT Q.CUSTOMERNAME, Q.TotalSales, Count(Q2.TOTALSales)+1 AS Rank
FROM [CW qry2008SALES_TOP25a] AS Q left JOIN [CW ...

Greetings all,
I am attempting to create what seems (to me at least) to be a very complex
query. I have a form (which will eventually link to my query when I can
figure out what I'm doing). The form has 4 yes/no check boxes, and two combo

I am school teacher and want to use my Access 2007 to rank scores of students
in examinations.

I have a form that selects a client from a combo box.  There is a sub-form
with a tree list control that I want to populate info applicable to the
client selected by the user.  I have the the following code in the Form Load
event to do this, but it is not working:

I have a table that I want to normalize. The SQL below delivers the results
in Alpha Order. But I want them to appear in field order, just like the order
in the SQL below. Can this be done?, or have I created an untameable monster?
SELECT [Run_point_List_ID], [Run_No], ...

Trying to make a running sum query using DSUM.  I've looked at the sample from
rogersaccesslibrary.com and searched google.  My problem is that when I try to
Group By using AcctNumber, I get the same thing in all records, which is the
overall total of all records, rather than ...

Hi, I use variable in SQL statement, but it says "Enter Paramenter" instead.
Here is my statement:
Enbr = CStr(Month(CurM))
      If Enbr <= "9" Then

I'm working on a query which calculates a paycheck witholding amount.  I take
the employees desired yearly contribution and divide it by the number of
paychecks in a year, in our case, that's 26.  This gives me the amount that
needs to be witheld from each paycheck, provided the ...

I would think that "Show" would place the results in the table or not but it
appears that if you do not check the box the results cannot be used for
calculations in other parts of the query. Does "SHOW" mean "Ignore"?
As an example I have in the "Total" box "Count" in two places ...

I have the following union query.  Basically I am trying to merge the two
tables.  The Tbl_Summary_PO_Details table contains the expected delivery date
(OTB_Date with a Date/Time Data Type) and the Tbl_Summary_Rcpt_Details
doesn't so I put a 0 (zero) in this field.

I want to find out how I can put in a suspense date associated with a person
and have that person contacted to remind the individual of the suspense date.

I'm trying to run a sum function in a query and when I click Run it gives me
an error because the table has an *.  What does this mean and how do I
correct this?