I have four tables as follows
Table -1 – "expenditur e"
Field 1- date of payment
Field 2 – type of payment
Field 3 – Amount paid
Table – 2 "Medicine purchase"
Field 1- date of purchase
Field 2 – Name of medicine
Field 3 – Qty purchased
Field 4 – Amount paid
Table -3 "Patient"
...
mukesh
Last Activity: Oct 27 '07, 09:36 AM
Joined: Sep 8 '06
Location:
-
consolidated information in query
-
how to get the progressive total in a form
I have designed a form in ms access to show the account of firms. In the total column i need a progressive total of one or more column of this form. what to do please
thanks in advance -
formatting of contents of report
hi,
i have designed a report having a good amount of text. I want the line specing as - 1.5 line (just like in MSWords) and the text 'justified'.
I can i do that please tell me. The property of text box do not contian any setting to obtian 1.5 line specing.
thx in advance
mk -
how to set a search form in access
hi,
I have two tables one - "company" and another- "detail" I want to design a form where there is field showing the names of company in a list box as under--
company : _____________
:[____________]
and one another field names "detail" showing all the details from table "detail" related to the comapny as under
-----detail-------------------------------------------------------------------------------------... -
how to set a condiitonal default value of a table field
Can we use expression in default value for a table field for example –
IIf(Table-1.field-1=table-2 . field-1, table-1.field-2, 0)
Interpretation – If field-1 of table -1 is like/equal to field-2 of table-2 then value of field-1 of table-1 will be the default value other wise 0 will be the default value
Can I use this type of conditional default value if yes please tell me how. I tried to set this... -
is oracle a MS Access like software
Hi,
I use MS Access for data base. I am interested to know about the oracle. Is oracle a MS access like platform for database program. like MS access does it provides userfriendly environemnt to develop data base. Is it neccessary to have the machine connected with internet while developing databse in oracle.
i want to know this.
thanx in advance -
Is oracle a platform like a MS Access
Hi,
I am new wanting to migrate from MS Access learning to O racle learning. I want to know is the oracle a platform like MS Access to design a data base for various and different work.
can data base be prepared off line (where computer in not connected to internet)
please detail me
thanx -
How to have two page header in a report
Hi,
I want to show two tables one after another in a report. The heading of these table will be fixed while there will be number of details under the headings in these two tables.
This will ony happen when there is two page header in a report to hold the heading of table. I can draw only one table with freezed headings. What should i do for another table.
help please. thanx in advance -
I can't see the SCALE property in the General proeperty tab. Will u explain me step by step... -
how to store a decimal number which is not a currency in a table field
Hi,
I have a field in a table the property of which i have set as a general number with 3 decimal places. I want to enter a weight 1.265 tons but the decimal place do not work.The number gets round up. I do not want to set its property as currency
please help me how to do it. -
Is this a module? How shoud i use it
I have save it as 'module1' and in the calculated field of query table typed - Min: min_in_columns ([numer1], [number2], [number3])
but when i open the query, it opens the module automatically.
I do not know how to write module and how to refere the same in query to work it.
please help me. You are too intelegent to help me, i know it....Leave a comment:
-
Oh its amazing. Now I think that time to be taken by MS Access for such type of query is one or two seconds irrespective of the numbers of records. Thanks I will go ahead with this formula. thanks a lot. I will first feed numbers of recods in the table and watch the speed. Thax a lot...Leave a comment:
-
Thanks for your answer and support - but I need a formula for calculated field in a query which automatically selects minimum number amongst the numbers in more than one "row" (not a column) of a table
please help....Leave a comment:
-
I expressed what i felt. Well your post give me confidence on this type of formula. I want to aske whether your table contians - IIf (IIf (IIf())) - type of formula which is complex....Leave a comment:
-
due to formula "IIf ( "argue", 'true', 'false')" makes my query slow
One another problem
I have used a formula in the calculated field of a query as -
IIf( [A] <=[B], (IIf([A]<=[C], [A], [C]), (IIf ([B]<=[C], [C], [B]))
the above formula is working properly to give the lowest of [A], [B] and [C] but the problem is that the query is some slow as compared to other query not having such formula. At present, there is only one record in the query to calculate and to... -
How to find out Minimum of numbers in rows of a table
Thanks a lot
I will try your suggestions after a while but there is one another question -
I have a table having fields as - num1, num2, num3 and num4
I have a query named "MinimumNum "
Now in the calculated field of query "MinimumNum " - how can i get the minimum of num1, num2 num3, num4
please help me - i used - Minmum: DMin( num1, num2, num3, num4)... -
calculation of up to date age in terms of year/moth/days
Dear freinds,
I need date difference in terms of years/months/days i.e. i want to create a calculated field to show the age of person in year months and days. The DateDiff() expression of MS Access calculates the age in years only and do not show the month and days.
Will you please help me
thanks a lot in advance
No activity results to display
Leave a comment: