Search results

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...

Ok I have created the new query that will give me a list of dates I called it qryReportDates and its grouped by month. When I run the query I get a data mismatch error, guessing thats cause by trying to sum up dates? I did some google searches and found the CDate() but when I wrap my dates in...

I have started a thread over in the VBA section to see if they might have a solution. Also I cant really send my database over its on a SQL server and all the code in it is restricted by my company. Not sure it would help you anyhow as the sample data I listed in the last post is the same as...

Hey guys, So I stoped by the Query section and spent a few days trying to figure out how to make a query that will allow me to count how many open records I have each month. That thread can be forund: http://www.access-programmers.co.uk/forums/showthread.php?t=214642 It might be a good...

When I read that I almost feel like we have come full circle :), My first sample query already groups by month. And I allready have done the counts on those records. That works just fine when the record only shows for one month (Like the recived and closed stats) But that still will not provide...

I have made some sample data of what the end query will look like. I expect this to take more then on query to finish my main focus is understanding how to create the Open and Open>30 Days The sample will hopefully help you understand what I am trying to do.