Recent content by amona

Thanks, I appreciate your replay and want to do the second way (I did simple coding before). I do not like repetition it is not professional. Would you explain it, please?

I am trying to use one subreport in two different main reports. The DB is about facilities inventory in a university. The subreport is showing PCs info, and the 1st main reports showing administrative departments and another showing academic departments. I use yes/no field to mark academic...

I have main report and subreport and trying to reference the count() of supreport with =Iif(subform.Report.HasData, NZ(subform.Report.control, 0), 0) I got in the REPORT VIEW: #Name? in the PRINT PREVIEW THE EXACT COUNT HOW CAN i FIX THIS, PLEASEd?

I have to use the sub report to count PCs for each Department/College and I need the main report to group by Building/College. In the Footer of the main report I want show the count of PCs for each building. Any suggestion??

Is there any way to make this happened???

Many Thanks for the quick replay, The report is already grouped by Building/College and I did what you suggest: Textbox with =Count(PC) But it did not work, did not recognize PC because it is in the subReport, then I tried to reference it by =Count(subReport.Report!PC) Any...

I built a database inventory for a UNVERSITY to keep track of facilities (PCs, Printers …) Now I am working in reports: I created a main report showing Building/College and Department/Major and a SubReport to display PCs in each department/Major with count of PCs I am trying to find a way to...

Thanks a lot

Could anyone check my code and help to fix it, please?

How can I do this? I am a beginner...

Thanks for the replay. I am really new to Access… Sorry I want to run the query from a form after selecting from combobox. My code is not working “though I never let users into tables or queries” Then, what should I do?

Hi, I am trying to run query after selecting from cobmbobox list. I did the following but no luck: rivate Sub Comb_AfterUpdate() DoCmd.OpenQuery "Function" End Sub And wrote in the criteria [Forms]![Printer Or Scanner]![Comb] Function is the query, Printer Or Scanner -- the form. Could...