I have to create a query that updates only 1 row in a table with no primary
keys defined and double records. The problem I'm having is that my WHERE
statement (in the UPDATE query) can give more than 1 result (because of the
double records). How can I make sure that only 1 of those ...

help

Hello, I am trying to create a query that will display results in a combo box
if either of my option groups on the form are null, and it isn't working.  
This query works only if both option groups have a value selected. What I
would like is for the combo box to show results if ...

I have a table of dates and events. I would like to know how to make a query
that filters to display on any given day, only records whose events are
scheduled for the current week only.
For example, if they click this action button any time during the week, the

[I apologize for possible multiple postings due to technical
problems]
Hi,
My ASP page offers a search box allowing the user to enter a

LS,
I am trying to do the following. I have two tables in which I store date.
The first table contains a column named "Description" and "Connector". The
second table contains a column named "Text".

I'm trying to sort a field in a query that calculates the number of days
between two date fields in the same query.  However, when I try to sort a
recordset on this field, it sorts as if it were a text field instead of a
numeric field.  For example, 145 comes before 15 in the ...

I got a new webcam for Christmas and I installed it on my laptop, but before
I could finish my niece showed me here new trick, sliding down the stairs on
her stomach, obviously I wanted to record it so I skipped the end of the
installation where it asks you to reboot your ...

I have not used Access in a long time.  I have a problem with a query and  I
am wondering if it is because of the join type.  No data is coming up in the
query.    Let's say there are 5 tables.  And all tables link to Table 1.
Is it correct to say in a inner join if there are is ...

What query do I use to convert rows to columns (Table 1 to Table 2)?
Table 1:
PackageID    Status    City    Invoiced
P10    S10    C10    100

Can anyone recomend a good printed (UK?) or electronic reference guide for
the sytax for SQL within Access 2000 (JET?).
Perhaps just as important might be those items that look good at first sight
but that are not really any use when you try to use them.

I'm making a query where an expression calculates a total price of an order.
Total: Sum([Amount]*[Price])
is the expression I'm using, but when I run this it does not list orders
with 0 items (yes, I know, this isn't supposed to happen, but I want it

I'm a newbie, so please be gentle with me...
;)
I don't really know how to do calculations in a query. I've set up a report
based on a query, and with lots of trial & error managed to insert calculated

I use Access 2003. What I want to do seems somewhat complicated to me, so I'm
not even sure if it is possible. I've created a test database of movies to
try things out that may be needed for the databases needed for my work. One
table has movie titles, stars, etc. The next thing ...

 I am using code to create a query based on user inputs.  What I want to do
is create this as a read only query.  I want to use code to do this.
Any help is appreciated,
Chuck