As I said, it is an existing field and you can just type in the SQL. For example something like
SELECT
Products.ID,
Products.Attachments.FileName,
Products.Attachments.FileType,
Products.Attachments.FileTimeStamp
FROM
Products
In this example my table is called Products and the attachment field is called attachments. But as I said, although I included the timestamp field there is no data in it. So try it and see if any data is returned by the timestamp field.
On Tue, May 27, 2014 at 5:55 PM, ka0t1c_ang3l <no_reply@yahoogroups.com> wrote:
Thanks for the prompt responses. I've looked through my database and the only 2 fields that show up under my attachment is FileData and FileType. How can I add the FileTimeStamp?
It is a contract management database. I have a compliance form, and my supervisor would like the compliance form to include a list of attachemens for each record and the date the attachment was added.
The database is very large, so it would be difficult to upload it here so that you could review it. I could possibly take out most of the data and leave just the shell if that will help.
Any assistance is greatly appreciated.
Thanks!!
Kat
__._,_.___
Posted by: Peter Poppe <plpoppe@gmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (5) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar