By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,069 Members | 1,260 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,069 IT Pros & Developers. It's quick & easy.

Problem in Access Development

P: 1
Dear Sir,
I am facing problem in access programme development if you can do so please solve it at the earliest.
I have to created 5 tables for the determination of sales individually and then merged all the tables to each other to find out the actual transaction in the whole day.
Fields of Table-1 Name (Expenses )
Field Name Field Type
Serial No. Auto Number
Date Date
Particulars Text or Lookup
Expenses Amount Numeric
Fields of Table-2 Name (Opening Balance)
Field Name Field Type
Date Date
Name Text or Look Up
Account No Number
Opening Balance Number
Fields of Table-3 Name (Consumers)
Field Name Field Type
Consumer ID Auto Number
Name Text
Account No Number
Fields of Table-4 Name JOURNAL
Field Name Field Type
Serial No. Auto Number
Date Date
Account No Number
Name of Consumer Text Or Look Up
Opening Balance Number
Particulars-1 Description Text or Look Up
Particulars-2 Sale of Oil Text Or LookUp
Quantity Number
Rate Number
Bill Amount (Debit Amount) Number
Credit Amount (if Credit Sale) Number
Closing Balance Number IN Query the Field of Closing Balance : [Opening Balance]+[Bill Amount]-[Credit Balance]
Cash Transfer Number

Fields of Table-5 Name (Company Registery)
Field Name Field Type
Serial No. Auto Number
Date Date
Bank Reference No Number
Book No Number
Amount Transfer To Company Number
Invoice Amount Number
Balance Number
Afater All I have to make a query of all 5 tables. I have to merge all 5 tables and in the field of closing balance is calculated like above [Opening Balance]+[Bill Amount]-[Credit Balance] then list all records retreive from all tables but it should shown the difference in balance of each consumer.
After That, I have to make a Daily Report and in the report I have to display
Total Bill Amount of the Day
Total Credit Amount of the Day
Total Expenses of the Day.
Nov 9 '11 #1
Share this Question
Share on Google+
2 Replies


Rabbit
Expert Mod 10K+
P: 12,421
This is poor design. There is no need for a separate table for each salesperson.
Nov 9 '11 #2

Expert Mod 2.5K+
P: 2,545
We cannot design your application for you. You need to learn about relational table design, as Rabbit has indicated. We have an Insight article on this topic which I have linked here for you if you are interested in finding out about proper principles of relational normalisation.

-Stewart
Nov 10 '11 #3

Post your reply

Sign in to post your reply or Sign up for a free account.