Hi I have the following SELECT query that has turned out to be unupdatable....
.I think it may have too many table joins ???
I have tried it without the DISTINCT and the equation but it is still not
letting me update

I have a table with two fields in which I have entered default values in the
default field at the bottom of the table-
   "N" and the second field "C".
When I run a query, that information is not automatically inserted into the

I am attempting to pass a parameter to a Crosstab query from a dialog form.
A report is created from the query, and embedded in another report as a
subform. i.e,
QuestionnaireReport

How do i group this query by tblIssue.plIssID ?
SELECT tblIssue.pIssID, tblIssue.pIssDate, tblIssue.pIssTo, tblIssue.pIssBy,
tblIssue.pIssDept, tblIssueLines.plIssQty, tblIssueLines.plIssPrice,
tblinventory.MRN_No, tblIssueLines.plIssPartID, tblinventory.Description,

I have an unbound text box on a form (It will be hidden) a typical value in
the text box could be 1,3,4,5.  I want to use this value as criteria in a
query.  E.g show records 1,3,4,5
If in my query I manually type IN (1,3,4,5) the query works fine however if

I need to write an equivalent statement of a multi-line case statement, but
I understand there is no real eqivalent of CASE, so IIF is used.
What I have, in pseudo code is:
IIf([TBL_Project_GLDetails.T2]=49734600 then 4900, 45734600 then 4500,

I have a table that includes a date field txtexpirydate with dates in the
future. I want to set up a query that finds all records where the date field
is in the future ie after today. I've tried using > Date() but that doesn't
seem to work. How do I do this?

I have a query that selects workorders from a table then trys to
calculate the total hours down by using the function:
DateDiff([h],[DAYDOWN]+[TIMEDOWN],[DAYUP]+[TIMEUP],1,1) AS THD.
Instead of doing the calculation it asks me for "h" which I understand

I have created a query to look up the records foe today's date by using
Date() in the criteria for the field OrderDate.
This works fine! So I created a Form using the query to make it easier for
the user to look up today's records, that worked fine!

I have the following expression in my query and I'm getting this error "The
text is to long to be edited". Is there a different way to write this?
Capital Markets Name: IIf([Capital Markets
originator]=[forms]![frmReportCriteriaMarketer]![txtEntertheMarketerName],[Capital

Need some help. I have read the Mid, Left and Right options. But I have some
data that may very.
The Data will come as follows (1 FLD):
CC,4.5x5x7,C2

I have a program that imports data, processes it and places the results
into final tables. My problem is that it is really slow. Each temp
processing table has almost 2 million records in it. I have identified
the deletion of these temporary records as a bottleneck in the speed.

Does anyone know of a good third party scheduler that will run access
queries?
Thanks,
Chris

I have a table where periodically records are deleted (i.e., bc a case has
been terminated).  These records, however, need to be put into an 'archive'
table.  I am currently accomplishing this by first running an append query
and then a delete query.  Is there a way to combine ...

I have created an update query with 3 fields.  
1. Markup – This is the field I intend to update.  In the “Update To:” box
in the query, I have [Enter the new multiplier:], which will prompt users to
enter the new value when the query is run.  This works as desired.