Hi.

> What I need to do is change the "2" and "3" into a "4" and leave 1,5,6 and
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/11831-putting-different-dates-together-into-single.html
> 7
> alone.

Use an update query. Try:

UPDATE tblStuff
SET EnquiryDay = 4
WHERE (EnquiryDay IN (2, 3))

.. . . where tblStuff is the name of the table, and EnquiryDay is the name of
the column with the numbers corresponding to the days of the week.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.


"scubadiver" wrote in message
news:B047257D-6F4B-432C-914C-E6642BF435CF@microsoft.com...
> let me explain:
>
> I have a query that lists enquiries (one enquiry per record). Each of
> these
> enquiries were on a certain date. The list will start on a Friday and end
> on
> a thursday.
>
> I have created a column in the query so that "1" is equal to Friday and so
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11831
> up to "7" equalling thursday.
>
> What I need to do is change the "2" and "3" into a "4" and leave 1,5,6 and
> 7
> alone.
>
> Or is there an easier way?
>
>