Search results

theDBguy, Ranman256, Many thanks It works now

Hello experts I have a form which has a subform. At the bottom of the main form I have a button for opening a report. I want that report to be filtered according to the value showing in one filed of the subform. Is it possible to achieve? How to write a where condition in the Open report...

Hi I am searching this thread for a sample/template database for small business accounting. Does anyone know if it’s possible at all?

I've done something now. I created another query as a data source of report where some calculations are already done. Now the new report looks fin in both modes. Thanks for looking into it

No Gasman, the report view is correct and print preview is incorrect. I want to calculate a so called ratio. That is when all consultants do equal number of MDTs then their ratio is 1. If someone does more then the ratio is up. But it is not the proportion of MDTs. Some of our consultants work...

I am very sorry to be such a pain tonight. But there is another problem. When I open report, my calculated field Ratio displays correctly. But when I open Report Preview, the calculations go wrong and the field is showing incorrect values. What's going on? I attached db . r_10_mdt_cons_01

Sorry theDBguy I found it, You've just collapsed it completely Now I see what is the trick Many thanks for your help lbs

theDBguy, I can't find it in the group footer. How did you hide it? I just wanted to remember how it looks like for use in the future.

theDBguy and isladogs, Thank you very much, It works and I can use this field for further calculations of Ratio what I wanted. But, culd you explain it to me where =[number_rows] came from?

Yes this is what I need I will try it now to see if I can use iot for further calculations

No, this is not I am after. What I want to see: An 1 1 LS 1 BrRDE_post 3 2 LS 2 NC 1 BrRDE_pre 3 3 cem 1 ck 1 ls 1 BrT_post 2 2 ls 1 TW 1 BrT_pre AW 1 2 2 CK 1 So...

I think I caused some confusion. Actially I am not counting the number of records. I am counting the number of rows in a group, which is not equal to number of records. The Count(*) gives me the number of records. Because one consultant may show 2 and more records then the number of rows in a...

Isladogs, I noticed your post only now. Yes it works for counting the number of records. But unfortunately I can't use this calculated number for further calculations, for example in expression builder. It does not want to recognise this number as a proper field. I did not manage to reduce...

The same message. If I ignore the message and press OK then it returns an emty field. If I use Count() then it returns 0

I created a field with the name Cons_count and gave it all you adviseed (=1 and running sum over group). Now this field shows me numbers of rows in a way: LS 1 AW 2 TW 3 CM 4 So it numbers the rows. Then I created a field in the group header and now I am fiddling with the...

I can see now the numbering of the rows. But I can't use it for my expression. It produces a message: enter parameter.

Hi guys I am trying to build an expression for an unbound field in a report. I want to show a ratio of number of particular meetings for each consultant. For example, the total number of meetings = 5 These meetings were done by three consultants. So I should have the number of meetings done...

I am sorry, but I can't do it. For example, I have main report with Field Rota_id And I Have a crosstab query with Field Rota_id as row Heading. I try to insert into report footer crosstab as a subreport. It asks me to define the fields to filter and I choose Rota_id in the master report and...

Yes, I can create a report from a crosstab. But each time it asks me which columns I want to include. The thing is the next month there will be different collumns and thier number will be different. So I need each time after the data changed to create a report. And also I could not include a...

Hello I have a good report containing data from several queries. I want now to include to the report my final piece so that it was as a subreport. Unfortunately I can't do this because that piece of data is in the form of a crosstab query. Is there a possibility to solve this? Probably I can...