Recent content by uttamsaxena

The data provided by the utility is in the following format- Serial No/ Consumer No/ Meter No/ Name and Address/ Meter reading/Meter status i.e. OK, Defective or No reading. This info is provided for all the consumers for a month in one booklet. Like wise I have booklets for all the months...

I have to generate unique code for each person in an Employee table. This code will not be the primary key for this table. Primary key is an auto number. This Unique code is for refering to each person in all the correspondence/document/everywhere and every person will know his code and refer in...

Hi, everybody, Thanks for nice tips. I am not making a billing database as the billing mechanism itself is very complicated. I have just to track the consumption pattern of each household. Following thing are also to be checked but I am not that advance in Access , so your help would be...

Thanks a lot for your help. As I am learning Access, this is of very much help to me. one question --- I don't see the months, for which reading has been taken, in your proposed table . Suppose we need to know the meter reading of Mr A OR of Meter No. 123 OR house no 345 for the month Jan...

I want to design a database with following requirement-- 1) I am managing my township association which have around 1000 houses.I made a database of each house as its owners name, house no, address, phone, etc.(Single Table) 2) Now I have to maintain the electricity consumption data, and its...

I also need help on this kind of problem- I need to create a uniq code for each Name with following format Name Code Mekins M0001 Lorret L0001 Abso A0001 Anchor A0002...

For keeping record of provient fund, I have made a access/(or excel) database with many fields like ID, Name,contribution for months eg March, April,..to..,Feb,etc.It contains 50 records. Now I have to print the provident fund statements of my 50 friends. This statement consists of some text...