I am facing with aproblem where in i have a small access db
with forms and reports now i want to change or set the where condition
of a query based on the value the user selects from the form through a
combo box. For ex:- if user is selecting Invoice_date then the where

Can't figure this out.
I am the only user in the database. The file (RealProperty) can be
queried using a select query that includes just the fields in the
table. I get the above error, however, if I try to export the

Is there anyway to place a column (Item#) in a query, which will show
the item numbers of the results. Say that, if query result has 13
items, Item# values will be sequentially 1,2,3...11,12,13.
I have a feeling that it might be solved by usind DCOUNT function.

How do I create a Query using two tables that have dates field to
calculate a value using both the tables for a Date Range. For Example
I have four TABLES- Time Card(TC), PROJECT, TC hours(HOURS), and TC
expenses(EXPENSE). TC contains name of employees and their billing

How do I create a Query using two tables that have dates field to
calculate a value using both the tables for a Date Range. For Example
I have four TABLES- Time Card(TC), PROJECT, TC hours(HOURS), and TC
expenses(EXPENSE). TC contains name of employees and their billing

Hi. I have a query that check unmatched record between two tables.
My query result are 11 records, i would like to dele those records but it
returns me an error:
This is the error: Specif the table containing the records you want to delete.

My form wouldn't let me update, then I realize that my query is not updateable
either.
The properties are set to "Dynaset" and the other restrictions are set
correctly to allow updates.

In advance, I appreciate any help anyone can give me on this issue.  Here is
my dilemma.  I have a form named "WO" and a subform within "WO" named "WO
Detail".  In the subform, I have a control named "Work to be done" that is a
lookup of a table named "Repair Instructions".  When ...

I am using the Nz Function it work fine but my Currency is now gone how can i
get the currency format to return?
SELECT qrySubCost.Division, qrySubCost.Carrier,
Nz([Cumulative_Impact],"N/A") AS CumulativeImpact

Using Access 2003 (Access 2000 file format).
I have a main form for searching a subform (eventually will be two
subforms).  The subform is based on a multi-table query.
What I would like to be able to accomplish - add a checkbox to the

I have several invoice numbers that begin in DM.  For exmaple the invoice
number is DM123456.  How do I run a query that will delete out the DM and
leave only the 123456.   Note:  Not all invoice numbers are the same length
so I can't right a simple Left function or the ones with ...

I have written the following query and am getting the error message " The
expression is typed incorrectly, or is too complex to be evaluated. For
example, a numeric expression may contain too many complicated elements. Try
simplifying the expression by assigning parts of the ...

I am creating a photogallery with photos of my paintings. Frontpage creates
the Gallery, but when you Preview in Browser, and then click on a thumbnail,
it does not open up the enlarged version of the photo. Please help!
Thanks

I created a database and need to query a yes/no field .  when I run the query
I only receive the ones that were checked as yes.  I tried running a couple
different null queries such as is null, <>,"" and I can't get any results to
appear.  Any suggestions?  However,this only ...

I don't know if this subject makes sense but I have a combo box that uses a
field list for selection.  The fields are in a table and the rows are
activities.  So each row has an "x" placed under the specfic field where this
particular activity should be selected.  I would like to ...