Search results

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...

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...

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...

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...