Search results

thank you for this..but i found out that i was wrong that it will be such easy..because : my main report which have several subreports - are grouped by ID, so one query store many info, so never will be 0 = label is always visible, i think i need something like this: Hide label if there no...

Hi, i have one report with several subreports, subreports have can shrink property set on Yes..so when their query is null, subreport does not show, but their label does so i want something like this but i dont know syntax i tried like dis in VBA - report: Private Sub Report_load()...

now i just looking and you are right, it is solved i even dont noticed..but when i tried if before it was result wrong and i thought i do it same way you told me..i suppose not, so i automaticaly saw same result :D thanks again..

yes this is exactly what i want, but i cannot reach that..maybe i am blind, SELECT Data_G.TheName, Sum(Data_G.[Calculation Basis]) AS [SumOfCalculation Basis], Sum(Data_G.Amount) AS SumOfAmount, Sum(Data_G.Rate) AS SumOfRate, Data_G.Description, Data_G.Idofpayment FROM Data_G GROUP BY...

i have tried it like this before, but it does not do that..after i delete column Data.[idofpayment], it start to work properly, but i need to have this info

hi, i would like to ask if is possible to make query that make this.. from table pick name, sum1, description, sum2, idofpayment and return only 1 unique name but make sum of all.. example my query now return: Oliver - 297 - for services - 100 - 1982 Marc - 324 - for services - 132 - 1982...

Hi, It is possible somehow to always show report even if query is empty..? just report header with no values.. because i have several subreports in one final report, but according to my knowledge these subreports have fixed position in final report, so if some query is empty -> subreport is...

this is what i am talking about..thank you and question is : main report to use a query of invoice_ID's for its record source? what this do and why i need to create this? this one i dont understand how its work..i know where and how you do this but i dont know why, and when i will do this in...

Hi, i tried to create something for one invoice, but i dont know how to make it for all really. I did it in this way 1, I clean up my database according to your advice (now there is round 10 columns instead of 50) 2, need to have 3 selection for one invoice, so i made query for each of...

thank you for quick answers, i will try to do it in that way..if something i will write again, which will probably happen thanks again

Dear all, i am facing problem and i dont know how to solve it or i dont know if it is possible to make it in access. Problem is 1, i have one table with around 50 columns for this moment are important this: customer_id, customer name, id_invoice, and some number.. 2, in table there are many...