Is there a way to set a primary key field within a make table query?

I need an update query with an If statement on it.  Basically, it would say
something like If AssignDate is Friday, then update Time Elapsed to 1 hour.  
My problem is that the AssignDate varies and it's in a mm/dd/yyyy format.  Is
there something that can identify when a date is ...

I have the following in a query:
UPDATE Actuals INNER JOIN [Forecast - Dynamic] ON (Actuals.[JDE Bus Unit] =
[Forecast - Dynamic].[JDE Bus Unit]) AND (Actuals.[JDE GL] = [Forecast -
Dynamic].[JDE GL]) SET [Forecast - Dynamic].Jan =

I have a table with the code designation in one column and the number of
records with that code in the other column. I need to find out what
percentage of the total records in the table has each code. Seems so simple
but I cannot get the query to work!

Hi, I am new to access and can't figure this one out. Does anyone know how to
do this? Here is my code:
ps:  this function is not requiring parameters at this time. Thanks. MC
________________________________

How can I display duplicate addresses with matching postcodes. At the moment
my SQL will only find duplicate Street Names, which will only be duplicate if
they also have a matching postcode. Because like a lt of big cities, you can
have more than one identical street name, but it ...

I had posted this question in the Forms thread, but that was probably the
wrong place.
TblPartNumInfo
TblDefectRpt

I have a main table tblOHInst.  Fields Match and Zip are blank.
I have a secondary table tblInstNew that has the same fields as the
tblOHInst but the Match and Zip fields has data.  
What I need to do is update the OHInst table with information from the

What can be done to keep a querie from constantly timing out? Almost all my
queries and functions are doing this lately as my database grows. Any advice
on this is very much welcome.
Thanks, MC

I need a form to allow the user to drill down to records using a multiple  
parameter query. In the columns criteria I have something like this
[Forms]![Form3].[Form]![Text3].
I will have three parameters entered from the form  Date , Mfg and part number

Office 2007
I want to be able to get the Tax Month from a given pay date.
Tax months run from 6 April to 5th May, 6th May to 5th June etc
If the payment date is 19th April the Tax Month = 1

I am trying to create a query to search for various date ranges in a table.
to make it easier for the user i am trying to create the query so they only
need to open one query which shows pop ups for "start dates for field one"
"end dates for field one" "start dates for field two" ...

I have a table where the date field is stored as yyyy/mm. I want to be
able to query all records that have the previous month in their
record. In other words if it is May 1st, 2007 i want to return all
records that show up in my table that are 200704 (meaning april).

I need help with SQL syntax to combine two queries and use a criteria string
to limit the results and feed this all into a report. The criteria is
determined by options the user selects on the reports form, and often looks
like this

Can you check what wrong with this DLOOKUp that I want o insert on a report.
=DLookUp("[Hora_Ok]";"[7_cons_Entradas_Saidas_Renwin_Saldo]";"[Employeenumber] = '" & [Employeenumber] & "' and [DataMarcacao]= '" & [DataMarcacao] & "'")
I have a report base on a querie. and I need to ...