Re: [MS_AccessPros] Re: make table with a time stamp

 

Liz-

A Make Table should do the same bloat - assuming you are deleting the table after each use.

John Viescas, Author

Effective SQL

SQL Queries for Mere Mortals 

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

http://www.viescas.com/ 

(Paris, France)

On Mar 7, 2017, at 10:34 PM, Liz Ravenwood liz_ravenwood@beaerospace.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Hey Bill.  I totally do that if I weren't working with a situation that I'm working with a consultant on that is essentially building MRP with a LOT of data.  So for the iterations, the delete/append  was blowing the size up pretty heavy.

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] 
Sent: Tuesday, March 07, 2017 2:29 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Re: make table with a time stamp

 

Liz - Instead of a Make Table, I usually keep the existing table and just delete the records before inserting new ones. That way I can put defaults in place, but your way will work just as well. You'll have to maintain the code while I just maintain the table structure. To each his own.

 

-Bill

---In MS_Access_Professionals@yahoogroups.com, <liz_ravenwood@beaerospace.com> wrote :

Thanks Bill.  Yes now() was the solution because we wanted to be assured of when data went in to the file precisely.

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] 
Sent: Tuesday, March 07, 2017 1:42 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: make table with a time stamp

 

Liz - If you want date and time use:

WhenAdded: now()

 

If you only want a date use 

WhenAdded: Date()

---In MS_Access_Professionals@yahoogroups.com, <liz_ravenwood@beaerospace.com> wrote :

Pros, do you know how to create a timestamp on a make table?

 

I was using this:  WhenAdded: cdate(now())

 

But it failed.

 

Respectfully,

Liz Ravenwood

Software Engineer

B/E Aerospace | Super First Class Environments

 

1851 S Pantano Road | Tucson, Arizona 85710

Office +1.520.239.4808 | Internal 814-4808

beaerospace.com

Passion to Innovate. Power to Deliver

 

<snip>

This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

__._,_.___

---

Posted by: John Viescas <johnv@msn.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (7)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• New Members 3

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___