Recent content by vapid2323

Could you not just put the same calculation in a unbound text box on the form? Something like =Sum(Value)

Ok sounds like this one might not be possible by all the replies :) I will work around it then

Hey guys not sure how to fix this one, if you look at the images I am trying to add a sub report for a staff list, but I need the background to be all blue. But it seems access wont let me change that, or I dont know how. This shows the report design: And a preview: If anyone knows a good...

As far as I can tell that did the trick and is far more easy for my brain to follow lol. Thanks so much for the help!

Yes thats correct

Hey guys, this is the first time I have ever needed to make a sub-select query and my brain is having a hard time understanding what it is I am doing. I am following a tutorial found HERE As for my data I have three fields, fk_SupplierID, AuditStartDate and LeadAuditorAuditHistory I need to...

NICE! I think this will work, I will try it out later this week when I have some time. Thanks for your help!

Your issue sounds very close to mine you might keep an eye on mine in case it has a awnser that can help you. http://www.access-programmers.co.uk/forums/showthread.php?t=229966

Just got back to this, I guess to simplify this, I need to take and modify SQL statements from queries that have already been created. To give you a visual I have attached a screenshot of my form that filters the data. At the left we have a list of both queries and reports, normally a user...

Thanks for this but I am not sure it will work for my needs as the form I have open is unbound, it creates the where statement with the following code... well there is a bit more but this is a good chunk, also I did not create this code. So it’s only applying a filter to already created...

Hey guys, I will start off by saying http://www.access-programmers.co.uk/forums/showthread.php?t=208324 is very close to what I need. I have a form in my Access 2007 DB that manages filtering all my reports with VBA, as in creates a WHERE statment that I can filter the output with. Now...

Hey guys, I have a report that a user can filter with multiple sets of criteria the issue is that functions like =Count() will just look at the record set and ignore any filter I have. At the bottom of my report I have: ="Total Scheduled Audits: " & Sum("[ScheduleDateCount]") ="Total Completed...

Ok well, this is what I get for loosing my sample code file that holds all the nice sample forms that I find on the internet :( I am looking for a sample file I found back in 2010 that has a interface that looks like this: I know its a long shot but if anyone has an idea where I can get...

I had to update the query a bit more to make it work and show the proper dates, but all in all it was the solution I needed. My SQL: SELECT qryReportDates.ReportDate, Sum(IIf([AwareDate]<DateAdd("m",1,[ReportDate]) And [DateClosed]>=[ReportDate],1,0)) AS [Open] FROM qryCQA, qryReportDates...

This seems to work, I just need to check the values :) SELECT qryReportDates.ReportDate, Sum(IIf(Format([AwareDate],"yyyy/mm")<=Format([ReportDate],"yyyy/mm") And Format([DateClosed],"yyyy/mm")>=Format([ReportDate],"yyyy/mm"),1,0)) AS [Open] FROM qryCQA, qryReportDates GROUP BY...