Recent content by spooky30

Hi I am making a investment porfolio database I have a purchase table and seperate Category of Financial transaction table ,in financial transaction table i can choose a category of finan. Transaction which can be Reciept ( ie yes or no field). What i want to do is sum quantity and amount on...

Thanks doc man the problem i am facing is with concept this is the very best answer i got from various forums but there is one problem that each role may have various sets of tables attached to it like if supplier than supplier related tables like product price etc,in role of doctor visit...

i would like to point out few things ,i am asking this as i want to break down contacts etc to related tables as there can be more than one phone no or more than one type of address ,emails so i want to break them down to their own tables,but relating them to each entry will lead to many similer...

Hi I am new to data base and having problem in normalizing The problem: I have a entity category table in hospital database which has entities like doctors,suppliers,patient,staff etc: each entity consists of variable no of tables,some tables like address,phone are common to many or all and...

Thanks for the quick replay

i am new to access and trying to make a hospital data base. 1. I am making a banking transaction table 2 There is a field in banking transaction where i have to input name of the party 3. this party can be doctors/suppliers/or staff each having seperate tables I want to produce drop...

i have three fields in query Transaction types-grouped transaction date-condition requiring current date Transaction amount- sum when i run the query it gives me sum of amount under each head( grouped) date wise eg total of reciept and payment groups in each date how can i calculate...

I have following tables and fields for cash book Transactions-id,Heads,Subheads,Date,Amount, Heads-id,heads Subheads-id,heads,subheads Entry doneby-id,Name i want to put details in transactions table based on head i have chosen which can be either reciept and payment I want to make Reciept...

I have a transaction form and want to insert subform based on transaction chosen in main form Main Form: Transaction Other forms:1- Reciept Details 2-Payment Details I want to choose transaction type as reciept in main form to insert reciept details as subform or payment in main form to insert...

I am making a simple cash transaction pls analyse my relationships and help if it can be done better . I am facing problem in providing single id for transaction details in transaction table i have broken details in to Reciept details and Payment details and made a join table to provide single...

Hi Thanks for the replay and it is really appriciated but what i wanted to know was 1. I have a table- Type of Transactions containing field TOT with records reciept and Payment 2. Two other tables ie subhead-reciept & subhead-payment containing fields pertaining to either reciept or payment in...

I have Tables for Type of Transactions in cash book and sub head tables for each of these transactions i want to create a relations so that subheads are chosen on basis of type of transactions as these tables have no common fields

I am making a cash book and am a newbie Pls help Tables Type Of Transaction-Reciepts/Payments Subheads-Reciepts Subheads-Payments Details-Reciepts Details -Payments Transactions I would like to relate subhead fields in individual tables and relate them to only records in type of transaction

Hi all I want to display income and expense seperately on the form till the time of last transaction--in cash book,where i will enter transactions. Issue: How do i display total of income and expense seperately on form using conditional sum on date,income/expense , or any other way to do it

Hi all i am working on a hospital inventory system, can any one help me with my problem--ie i have made: 1. Transaction table: Fields include both sale and purchase field 2. Transaction Type: include Sale,Purchase and sale purchse return 3. table 2. is look up table in table 1 4. Is there any...