Search results

Hi All. I created form with unbound listboxs based on query which included Credit field that I want to calculate total and show result in caption of window. If is it possible how to do it? Thanks.

Hi All. Is it posible to create report in Word format? If yes, how to do that. Thanks.

Hi All. In a query I grouped DATE by month Date:Format([Date],"yyyy mmm") to calculate visits in each month. My problem is: How to create dialog where user can enter date based only on YEAR and MONTH and enter in this dialog start_date and end_date? Thanks.

If I will use DSUM it gives me total for the whole table. Do you have other decision? Thanks for replay.

Hi All. I try to generate a report which calculate subtotal for patient AMOUNT for current year and total for whole period from first visit to current date. The result of subtotal =Sum(IIf(Year(Date()=[VisitYr]),[Amount])) is the same like total. What is a correct way? Thanks.

Hi All. Is it posible to create buttons circle or oval forms and insert, for instance, picture from clipart? If yes, how to do that? Thanks.

Thanks a lot. It works but how make it in date (month) order. Now it only in Year order. I need in month and year order. Thanks

Hi All. I need to calculate how many visits per month. What formula in a query I need to use to calculate the same value of DATE field. Thanks.

Hi All. I need to calculate how many visits per month. What formula in a query I need to use to calculate the same value of DATE field. Thanks.

Hi All. I try to create Inventory database where some group of devices can locatated in the same room. I created three tables: Table1, Table2 and Table3. Fields of Table1 are: Tab1ID, Device, SN and more. Fields of Table2 are:Table2ID, Table1ID, Location, Room. Fields of Table3 are: Table3ID...

Thanks for replay. But unfortunately it doesn't calculate.

Hi All. I try to generate a report. This report includes two fields with currency format. I need to calculate total of both fields for each person. When I do like =Sum([Field1]) and =Sum([Field2]) I got correct result for each field but when I do like =Sum([Field1] + [Field2]) I have a problem...

Convert value format in query Hi All. In my calculation in a query: Cost: Sum([Cost]/12*(DateDiff("m",[StartDate],Now()))) Cost is Currency; StartDate is Date. The result look like Numeric format I would like to have Currency format. Is it possible? Thanks.

Hi All. I need to generate a query which will show me in Field1 Cost for the current year only and in Field2 Cost from a start date to the current. If is it possible how to do it? Thanks.

Hi All. I have form with Listbox where Field3 has two value: blank or character - Chr(164). I would like to change Chr(164) to check sign. Is it possible? Thanks.

Thanks KH. And does absolutly unposible to save result in table? May be by procedure or any other way? Thanks.

Hi all. I have a TableA with 3 fields: FieldA, FieldB, Result. A Form1 based on these fields. User will put data in FieldA, FieldB and calculate in Result. Problem is how to keep result of calculation in TableA? Thanks

Thanks Pat. What about color? Is it posible to highlight background of field?

I have the Inventory Form. So the some fields cannot be empty and cannot duplicated. I asked user to enter temporary data like "?NNN" where NNN is sequence number. But if I will have a lot of UNKNOW value to maintain DB became dificult. Is it posible to highlight backcolor and font fields with...

Hi all. I have a simple report and I want to calculate total records in my report. But I don't have numeric fields in this report. My problem is: how to calculate total based on text field if table which I used has relationship to other table? The report doesn't has fields from other table. Thanks.