
28-Jul-2006, 08:24 AM
|  | Guest | | | | | | | | | | Re: putting different dates together into a single group Hi.
> What I need to do is change the "2" and "3" into a "4" and leave 1,5,6 and
> 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. Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11831
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 Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11831
> on
> a thursday.
>
> I have created a column in the query so that "1" is equal to Friday and so
> 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?
>
> | 
28-Jul-2006, 08:24 AM
|  | Guest | | | | | | | | | | Re: putting different dates together into a single group
Same idea but if dealing with a query then just add another column to the
query and enter the following: Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11831Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11831
=iif([EnquiryDay] IN ("2","3"),"4",[EnquiryDay])
Immanuel Sibero
"'69 Camaro" wrote in
message news:O1spGvTlGHA.1240@TK2MSFTNGP05.phx.gbl...
> Hi.
>
> > What I need to do is change the "2" and "3" into a "4" and leave 1,5,6
and
> > 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
> > 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?
> >
> >
>
> | 
28-Jul-2006, 08:24 AM
|  | Guest | | | | | | | | | | Re: putting different dates together into a single group I used a similar one to Immanuel:
Group: IIf(([diff]=2) Or ([diff]=3),4,[diff]) Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11831
and it does work but I realise its not helpful for producing a real date to
put into a report.
So using your idea where exactly do I put the code but using real dates (if
possible)
cheers.
"'69 Camaro" wrote:
> Hi.
>
> > What I need to do is change the "2" and "3" into a "4" and leave 1,5,6 and
> > 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
> > up to "7" equalling thursday. Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11831
> >
> > 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?
> >
> >
>
>
> | 
28-Jul-2006, 08:24 AM
|  | Guest | | | | | | | | | | Re: putting different dates together into a single group Hi.
> but I realise its not helpful for producing a real date to
> put into a report.
I'm not sure I understand your question. Do you mean that you want to
convert the numbers 1 through 7 to days of the week, i.e., "Wednesday" or
replace them with an actual date, such as 6/21/2006?
> So using your idea where exactly do I put the code but using real dates
> (if
> possible)
First, make a backup of the table, just in case something goes wrong,
because the update query will permanently change the values in that column.
(I'm assuming that this is what you want to do.) Create a new query and go
to the SQL View pane (View -> SQL View menu), then paste the code into the
window. Replace the table name and column name with the names of your table
and column. Hold off on the next step (running the query) until we clarify
exactly what you mean by "using real dates."
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:88F69204-9850-40EB-86A6-2E534E1DF4A3@microsoft.com...
>I used a similar one to Immanuel:
>
> Group: IIf(([diff]=2) Or ([diff]=3),4,[diff])
>
> and it does work but I realise its not helpful for producing a real date
> to
> put into a report.
>
> So using your idea where exactly do I put the code but using real dates
> (if
> possible)
>
> cheers.
>
>
>
> "'69 Camaro" wrote:
>
>> Hi.
>>
>> > What I need to do is change the "2" and "3" into a "4" and leave 1,5,6
>> > and
>> > 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 Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11831
>> 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 Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11831
>> 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
>> > 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?
>> >
>> >
>>
>>
>> | 
Support Us! Become a Promoter! | | Gurfateh ji, you can become a SPN Promoter by Donating as little as $10 each month. With limited resources & high operational costs, your donations make it possible for us to deliver a quality website and spread the teachings of the Sri Guru Granth Sahib Ji, to serve & uplift humanity. Every contribution counts. Donate Generously. Gurfateh! | (View-All)
Members who have read this thread : 0
| | There are no names to display. | |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | | | | Tools | Search | | | | | Display Modes | Linear Mode |
Posting Rules
| You may not post new threads You may not post replies You may not post attachments You may not edit your posts HTML code is On | | | | » Gurbani Jukebox | Listen to Gurbani while surfing SPN! | » Active Discussions | | | | | ਨਾਮਾ Today 06:37 AM 2 Replies, 45 Views | | | | | | | | | | | | | | | | | | | | | | | | | » Books You Should Read... | | | |