|
Related Topics:
| how good is this? - These are my stats for one of my websites just for this month so far: Monthly for August 2003 Total Hits 87609 Total Files 72850 Total Pages 8082 Total Visits 6909 Is that good? I have to admit I really don't what is better..
Good tutorial on XML/XSL/RSS - Hi all, I am web manager for a number of large websites. I am trying to get up to speed on content using RSS news feeds and XSL All the tutorials I can find on the web seem to be extremely vague - almost as if they..
Looking for a good copywriter - Hi, I am looking for a good who can re-write the front page for our website (see I am looking for a who writes to sell and one whose copy is search engine friendly. If you can help me out, please contact me. You can..
Today is a good day - For me at least :) Picked up some freelance work for Curious Media, and also got a full time job as a designer <g> *happy* -- Dale, Now playing: The Walkmen - My Old Man
Hostdiscount.net any good? - have seen some adv around yahoo, WHT) from that company. Are they good for lowcost hosting with CPanel? Thanks in advance Marco L.
|
|
|
Next: Webmaster: Forums on websites
|
| Author |
Message |
External
Since: Aug 20, 2004
Posts: 205
|
(Msg. 1) Posted: Thu Aug 26, 2004 5:01 pm
Post subject: Anybody here good with Access?
Archived from groups: alt>www>webmaster (more info?)
|
|
|
I have an Access DB, and I want to do something with two of the entries in
the table.....
One of the table fields is a date field....Basically the date an order was
placed on.....Now I need two new fields to display the date 10 working days
later, and another to display 28 days (including weekends) after the
original date.....
I would like it to do this automatically upon entry of the original date,
but for the life of me, I can't figure out how.....I'm having some sort of
brain fart......
Can anyone help please?......
--
Sam.
www.doohickeys.co.uk
For Desirable Devices |
|
| Back to top |
|
 | |
External
Since: Jul 01, 2003
Posts: 411
|
(Msg. 2) Posted: Thu Aug 26, 2004 5:01 pm
Post subject: Re: Anybody here good with Access? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Fat Sam wrote:
> I have an Access DB, and I want to do something with two of the entries in
> the table.....
>
> One of the table fields is a date field....Basically the date an order was
> placed on.....Now I need two new fields to display the date 10 working days
> later, and another to display 28 days (including weekends) after the
> original date.....
>
> I would like it to do this automatically upon entry of the original date,
> but for the life of me, I can't figure out how.....I'm having some sort of
> brain fart......
>
> Can anyone help please?......
>
<a style='text-decoration: underline;' href="http://groups.google.com/groups?threadm=q8es9.10388%24Lb1.1551543%40news20.bellglobal.com&rnum=1" target="_blank">http://groups.google.com/groups?threadm=q8es9.10388%24Lb1.1551543%40ne...0.bellg</a>
--
Justin Koivisto - spam.TakeThisOut@koivi.com
<a style='text-decoration: underline;' href="http://www.koivi.com" target="_blank">http://www.koivi.com</a><!-- ~MESSAGE_AFTER~ --> |
|
| Back to top |
|
| |
External
Since: Jul 14, 2003
Posts: 423
|
(Msg. 3) Posted: Thu Aug 26, 2004 5:01 pm
Post subject: Re: Anybody here good with Access? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
"Fat Sam" <janetandmas.RemoveThis@btinternet.com> wrote in
news:2p65fuFhjlhoU1@uni-berlin.de:
> I have an Access DB, and I want to do something with two of the
> entries in the table.....
>
> One of the table fields is a date field....Basically the date an order
> was placed on.....Now I need two new fields to display the date 10
> working days later, and another to display 28 days (including
> weekends) after the original date.....
>
> I would like it to do this automatically upon entry of the original
> date, but for the life of me, I can't figure out how.....I'm having
> some sort of brain fart......
>
> Can anyone help please?......
Hrm, would ten working days automatically be 14 calendar days ?
I don't know if there's an SQL command that would give you the exact date
by adding ten (to cover end-of-month, leap years, etc), but if you're
running perl on your system, you could use Date::Calc from CPAN and that
would do the trick (you could then insert the two generated dates into your
DB from there).
--
Marc Bissonnette
CGI / Database / Web Management Tools: <a style='text-decoration: underline;' href="http://www.internalysis.com" target="_blank">http://www.internalysis.com</a>
Looking for a new ISP? <a style='text-decoration: underline;' href="http://www.canadianisp.com" target="_blank">http://www.canadianisp.com</a><!-- ~MESSAGE_AFTER~ --> >> Stay informed about: Anybody here good with Access? |
|
| Back to top |
|
| |
External
Since: Aug 19, 2004
Posts: 21
|
(Msg. 4) Posted: Thu Aug 26, 2004 5:01 pm
Post subject: Re: Anybody here good with Access? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
On Thu, 26 Aug 2004 14:01:30 +0100, Fat Sam wrote:
> I have an Access DB, and I want to do something with two of the entries in
> the table.....
>
> One of the table fields is a date field....Basically the date an order was
> placed on.....Now I need two new fields to display the date 10 working days
> later, and another to display 28 days (including weekends) after the
> original date.....
>
> I would like it to do this automatically upon entry of the original date,
> but for the life of me, I can't figure out how.....I'm having some sort of
> brain fart......
>
> Can anyone help please?......
If you're adding these new fields to the table, you shouldn't. Fields, as
in your computed fields, which depend on non primary keys should be handled
by your client, otherwise this violates the 3rd normal form of relational
database normalization.
--
Tony Cortese
--
Send camera phone photos straight to your online photo album plus a loaded
web hosting package for only $4.95/month - No other Fees
<a style='text-decoration: underline;' href="http://www.big-discount-hosting.com" target="_blank">http://www.big-discount-hosting.com</a><!-- ~MESSAGE_AFTER~ --> >> Stay informed about: Anybody here good with Access? |
|
| Back to top |
|
| |
External
Since: Aug 20, 2004
Posts: 205
|
(Msg. 5) Posted: Thu Aug 26, 2004 5:18 pm
Post subject: Re: Anybody here good with Access? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
"Fat Sam" <janetandmas RemoveThis @btinternet.com> wrote in message
news:2p65fuFhjlhoU1@uni-berlin.de...
> I have an Access DB, and I want to do something with two of the entries in
> the table.....
>
> One of the table fields is a date field....Basically the date an order was
> placed on.....Now I need two new fields to display the date 10 working
days
> later, and another to display 28 days (including weekends) after the
> original date.....
>
> I would like it to do this automatically upon entry of the original date,
> but for the life of me, I can't figure out how.....I'm having some sort of
> brain fart......
>
> Can anyone help please?......
>
Just found a load of stuff on it.....Hang fire for a mo...I may have it
sussed.....
--
Sam.
<a style='text-decoration: underline;' href="http://www.doohickeys.co.uk" target="_blank">www.doohickeys.co.uk</a>
For Desirable Devices<!-- ~MESSAGE_AFTER~ --> >> Stay informed about: Anybody here good with Access? |
|
| Back to top |
|
| |
External
Since: Feb 10, 2004
Posts: 21
|
(Msg. 6) Posted: Thu Aug 26, 2004 5:26 pm
Post subject: Re: Anybody here good with Access? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Fat Sam wrote:
> I have an Access DB, and I want to do something with two of the entries in
> the table.....
>
> One of the table fields is a date field....Basically the date an order was
> placed on.....Now I need two new fields to display the date 10 working days
> later, and another to display 28 days (including weekends) after the
> original date.....
>
> I would like it to do this automatically upon entry of the original date,
> but for the life of me, I can't figure out how.....I'm having some sort of
> brain fart......
>
> Can anyone help please?......
>
DateAdd("d",10,strDateOrderPlaced) and DateAdd("d",28,strDateOrderPlaced)<!-- ~MESSAGE_AFTER~ --> >> Stay informed about: Anybody here good with Access? |
|
| Back to top |
|
| |
External
Since: Sep 14, 2004
Posts: 2384
|
(Msg. 7) Posted: Thu Aug 26, 2004 8:26 pm
Post subject: Re: Anybody here good with Access? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
|
|
| Back to top |
|
| |
External
Since: Aug 20, 2004
Posts: 205
|
(Msg. 8) Posted: Thu Aug 26, 2004 8:28 pm
Post subject: Re: Anybody here good with Access? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
"Justin Koivisto" <spam.TakeThisOut@koivi.com> wrote in message
news:axlXc.1066$j1.19737@news7.onvoy.net...
> Fat Sam wrote:
>
> > I have an Access DB, and I want to do something with two of the entries
in
> > the table.....
> >
> > One of the table fields is a date field....Basically the date an order
was
> > placed on.....Now I need two new fields to display the date 10 working
days
> > later, and another to display 28 days (including weekends) after the
> > original date.....
> >
> > I would like it to do this automatically upon entry of the original
date,
> > but for the life of me, I can't figure out how.....I'm having some sort
of
> > brain fart......
> >
> > Can anyone help please?......
> >
>
>
<a style='text-decoration: underline;' href="http://groups.google.com/groups?threadm=q8es9.10388%24Lb1.1551543%40news20.bellglobal.com&rnum=1" target="_blank">http://groups.google.com/groups?threadm=q8es9.10388%24Lb1.1551543%40ne...0.bellg</a>
Perfect...Cheers Justin....I had just found another resource that lists the
exact same solution.....It's absolutely spot on perfect for what I'm trying
to do.....
--
Sam.
<a style='text-decoration: underline;' href="http://www.doohickeys.co.uk" target="_blank">www.doohickeys.co.uk</a>
For Desirable Devices<!-- ~MESSAGE_AFTER~ --> >> Stay informed about: Anybody here good with Access? |
|
| Back to top |
|
| |
External
Since: Aug 20, 2004
Posts: 205
|
(Msg. 9) Posted: Thu Aug 26, 2004 8:29 pm
Post subject: Re: Anybody here good with Access? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
"Marc Bissonnette" <dragnet DeleteThis @internalysis.com> wrote in message
news:Xns95515F7EE982Cdragnetinternalysisc@207.35.177.134...
> "Fat Sam" <janetandmas DeleteThis @btinternet.com> wrote in
> news:2p65fuFhjlhoU1@uni-berlin.de:
>
> > I have an Access DB, and I want to do something with two of the
> > entries in the table.....
> >
> > One of the table fields is a date field....Basically the date an order
> > was placed on.....Now I need two new fields to display the date 10
> > working days later, and another to display 28 days (including
> > weekends) after the original date.....
> >
> > I would like it to do this automatically upon entry of the original
> > date, but for the life of me, I can't figure out how.....I'm having
> > some sort of brain fart......
> >
> > Can anyone help please?......
>
> Hrm, would ten working days automatically be 14 calendar days ?
As good as for the job we need it to do......I think it would be very rare
occasions when it doesn't work out that way......
--
Sam.
<a style='text-decoration: underline;' href="http://www.doohickeys.co.uk" target="_blank">www.doohickeys.co.uk</a>
For Desirable Devices<!-- ~MESSAGE_AFTER~ --> >> Stay informed about: Anybody here good with Access? |
|
| Back to top |
|
| |
External
Since: Aug 02, 2004
Posts: 145
|
(Msg. 10) Posted: Thu Aug 26, 2004 9:52 pm
Post subject: Re: Anybody here good with Access? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Fat Sam wrote:
> One of the table fields is a date field....Basically the date an order was
> placed on.....Now I need two new fields to display the date 10 working days
> later, and another to display 28 days (including weekends) after the
> original date.....
Do you really? Why?
Do you want a new field that is *initialised* to 10 working days after the
first date field and can then be changed to whatever you like; or do you
want a new field that fixed at 10 working days after the first date field
(and gets updated whenever the first date is updated)?
If the former, then DateAdd will do the job in VBScript.
If the latter, then as Tony Cortese said, you will violate 3NF, a hole
will open up the ground and swallow you up and you'll burn in hell. Really.
If the latter, don't bother storing those dates -- just calculate them on
the fly when you need them.
--
Toby A Inkster BSc (Hons) ARCS
Contact Me ~ <a style='text-decoration: underline;' href="http://tobyinkster.co.uk/contact" target="_blank">http://tobyinkster.co.uk/contact</a><!-- ~MESSAGE_AFTER~ --> >> Stay informed about: Anybody here good with Access? |
|
| Back to top |
|
| |
External
Since: Sep 14, 2004
Posts: 588
|
(Msg. 11) Posted: Fri Aug 27, 2004 2:22 am
Post subject: Re: Anybody here good with Access? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Fat Sam wrote:
> I have an Access DB, and I want to do something with two of the
> entries in the table.....
Migrate to SqlServer?
Sam you really shouldn't be running a mission critical app on access.
--
William Tasso<!-- ~MESSAGE_AFTER~ --> >> Stay informed about: Anybody here good with Access? |
|
| Back to top |
|
| |
External
Since: Aug 20, 2004
Posts: 205
|
(Msg. 12) Posted: Fri Aug 27, 2004 3:40 am
Post subject: Re: Anybody here good with Access? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
"William Tasso" <SpamBlocked.RemoveThis@tbdata.com> wrote in message
news:Xns95523E783C00WilliamTasso@130.133.1.4...
> Fat Sam wrote:
>
> > I have an Access DB, and I want to do something with two of the
> > entries in the table.....
>
> Migrate to SqlServer?
>
> Sam you really shouldn't be running a mission critical app on access.
I know you're right.....But We started off that way and now I never seem to
have the time to change things over.....The DB in question is an offline one
that sits on our order processing machine, and gets backed up on a very
regular basis.....
--
Sam.
<a style='text-decoration: underline;' href="http://www.doohickeys.co.uk" target="_blank">www.doohickeys.co.uk</a>
For Desirable Devices<!-- ~MESSAGE_AFTER~ --> >> Stay informed about: Anybody here good with Access? |
|
| Back to top |
|
| |
External
Since: Apr 25, 2004
Posts: 91
|
(Msg. 13) Posted: Fri Aug 27, 2004 3:40 am
Post subject: Re: Anybody here good with Access? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
*Fat Sam* wrote:
> "William Tasso" <SpamBlocked RemoveThis @tbdata.com> wrote in message
> news:Xns95523E783C00WilliamTasso@130.133.1.4...
>> Fat Sam wrote:
>>
>>> I have an Access DB, and I want to do something with two of the
>>> entries in the table.....
>>
>> Migrate to SqlServer?
>>
>> Sam you really shouldn't be running a mission critical app on access.
>
> I know you're right.....But We started off that way and now I never
> seem to have the time to change things over.....The DB in question is
> an offline one that sits on our order processing machine, and gets
> backed up on a very regular basis.....
<SFX: Dig, dig, shovel>
<a style='text-decoration: underline;' href="http://www.cynergi.net/exportsql/exportsql2.txt" target="_blank">http://www.cynergi.net/exportsql/exportsql2.txt</a>
--
Andrew Urquhart
- Contact me: <a style='text-decoration: underline;' href="http://andrewu.co.uk/contact/" target="_blank">http://andrewu.co.uk/contact/</a>
- 'Staccato signals of constant information
A loose affiliation of millionaires and billionaires' - Paul Simon<!-- ~MESSAGE_AFTER~ --> >> Stay informed about: Anybody here good with Access? |
|
| Back to top |
|
| |
External
Since: Sep 14, 2004
Posts: 588
|
(Msg. 14) Posted: Fri Aug 27, 2004 3:40 am
Post subject: Re: Anybody here good with Access? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Fat Sam wrote:
>
> "William Tasso" <SpamBlocked.TakeThisOut@tbdata.com> wrote in message
> news:Xns95523E783C00WilliamTasso@130.133.1.4...
>> Fat Sam wrote:
>>
>> > I have an Access DB, and I want to do something with two of the
>> > entries in the table.....
>>
>> Migrate to SqlServer?
>>
>> Sam you really shouldn't be running a mission critical app on access.
>
> I know you're right.....But We started off that way and now I never
> seem to have the time to change things over.....The DB in question is
> an offline one that sits on our order processing machine, and gets
> backed up on a very regular basis.....
>
ok - that's a little better. sorry, I mistook that to be an on-line DB
--
William Tasso
Recommended reading ...
<a style='text-decoration: underline;' href="http://www.catb.org/~esr/faqs/smart-questions.html" target="_blank">http://www.catb.org/~esr/faqs/smart-questions.html</a>
<a style='text-decoration: underline;' href="http://www.aww-faq.org/" target="_blank">http://www.aww-faq.org/</a><!-- ~MESSAGE_AFTER~ --> >> Stay informed about: Anybody here good with Access? |
|
| Back to top |
|
| |
|
FAQ
Search
Profile
Private Messages
Log in/Register/Password
