Kamis, 31 Mei 2012

RE: [AccessDevelopers] New DB Design Ideas

 

You should be able to setup a table with the following fields:
 
Date, Client, File_Name, Count, Transaction_Number, Amount, etc.
 
You would enter multiple files on any given date, and record the client it was for, and the other info you specified.
 
I'm not sure how you are ending up with empty rows.
 
Hope this helps,
Toby
 
-----Original Message-----
From: AccessDevelopers@yahoogroups.com [mailto:AccessDevelopers@yahoogroups.com] On Behalf Of yshopper
Sent: Thursday, May 31, 2012 1:29 PM
To: AccessDevelopers@yahoogroups.com
Subject: [AccessDevelopers] New DB Design Ideas

 

I am starting a new project that will track Daily Tasks. One of the tasks is to download and process files. Each day the number of files will change. I need to record the name of the file and several other pieces of info after the file is processed; i.e. Count, Transaction Number, Amount, etc.

Some days there will be only 10-12 files, other days there could be upwards of 70-75 files. I need to record each file for each day. Also, these files are associated with 3 different clients.

How would I design a table(s) that will allow this type of data? I have a DB setup but it ends up with empty rows on all but the busiest days. I would like to avoid that if possible.

Thanks for any tips or suggestions,
John

__._,_.___
Recent Activity:

Please zip all files prior to uploading to Files section.
.

__,_._,___

Tidak ada komentar:

Posting Komentar