I have created a query that is for looking up certain information in a table.
It all works fine but what  I would like to do is have the query ask for
input to use as a filter when it runs.
So say I want to filter information based on zipcodes. How do I get the

I am trying to run an Update query on two tables.  None_Rev_New is the table
I want updated with the Street Name and Street Number from None_Rev_Old where
the property numbers are the same.  I run the query below and it just prompts
me for a paramater value rather than updating ...

I have some queries that refuse to open in the designer. I get a messge 'join
expression not supported'. These queries use to open and Access used to
remove parentheses I has inserted, I was able to re-add the parentheses and
save and run the queries. Now it refuses to open them ...

I posted a question last week about a query that was supposed to draw text
data from a date-sorted table and concatenate the text up to a max of 50
characters, then write it to an output field in a different table.  Problem
was that although the source table was sorted, the ...

Does anyone know why a first record query takes so long and subsequent
queries are seemingly immediate?
I split a database and stored a 15,000-record table on one PC and copies of
the forms on about six other PCs on the network. Whereas the first query

This will be difficult to explain and if it is completly confusing for anyone
to answer, I understand.
The database I'm trying to design gets it's source data from another system
and can be updated as often as I wish.  It is in read-only format, so users

I got this message when I ran a select query.  What does it mean?  What do I
do about it?  I notice that some of my records have a #error.

Thanks for taking the time to read my question.
Just wondering if it is possible to make a formula in a query that refers to
the previous row of data while still working in the current row of data.
Thanks,

rs.open "queryname", currentproject.connection
gives me an error
it says "expecting sql statement"
I'm using adodb recordset.

Can anybody help me to update a field in a query based on a user input?
I declared an integer variable, intNum.
The user input a number through use of an inputbox
intNum = val(inputbox("Enter the correct number"))

I am trying to create a filter in my Access query by a field called
'Purchase'. The possible values in the field are 'p' and null only. I want
only those records which have a value not p that is null. I am also using a
'totals' row in the same query. To create the filter,

Please help.
I am trying to find out when creating a query how to design the query using
a between range to work out the results e.g. find out all the records for the
time range say 10:00 pm and 06:00 am, either on a 12/24 hour clock.

Actually, this is the statement I tried in my query  it doesn't work = IIF(
[Meter Reading (md/gL)] >120,"High",IIF( [Meter Reading (md/gL)]
<70,"Low",""),"Good").
What do I do to make set up this in my Query?

When I import an excel table into the database is there anyway to check for
duplicate records?  Thanks in advance for any help.