Recent content by inq80

Managed to get it working by changing the query . Altered the joins so all the required Data showed me on one query and just used that to popular the report.

Thanks. I'll have a go and see what happens

If i take out the parameters can I add them to the code instead? The claims data i need isn't just for a particular product, it has to be between two particular dates as well

Also, just so i learn... can anyone say why this didn't work? =Sum(IIf([ClaimsQuery]![Product]="Aggregated Fleet",[ClaimsQuery]![excessValue],0))

does parameters effect it? The query it's pulling the data from is created from a form which sets a startDate and endDate. I really want the query originally to be filterable by dates and products but i struggled to get it to work with more than one parameter.

thanks - tried and it goes blank? I've also tried: =DSum("ExcessValue","ClaimsDataQuery","Product"='Agreggated Fleet') - goes blank =DSum("ExcessValue","ClaimsDataQuery",[Product] ="Agreggated Fleet") - returns error

update: It's definitely the reference to the criteria it doesn't like. Just tried without and it showed the total: =DSum("ExcessValue","ClaimsDataQuery", ) Just need to figure out how to get the parameter to work now :)

tried it and the "enter Parameter value" box popped up for Aggregated Fleet I changed to it "Aggregated Fleet" and just get error. I'm still at a lost as to why Access is finding it so difficult to reference a value off a query it quick easily finds on another report?

I've not but just tried and cant be getting it right as it still errors: =DSum("ExcessValue","ClaimsDataQuery","Product = Agreggated Fleet") thanks for the suggestion though.

Hi, Could someone please help point me in the right direction for this? I've tried looking online but I cannot find a solution (must be searching the wrong terms). In my head this should be simple, but i'm clearly not doing something right. I've got two reports set up from individual queries...

Hi Sneuberg, perfect! Worked a charm. How on earth are newbies suppose to know when not to use a function to perform a calculation?

Hi, Has anyone come across this before? I'm creating a report which displays the amount of calls we've received and who they are from. Within the report I've got a field called "caller" and this info is pulled from the source query. Next to it I've got a field caller "callerCounter" which as...

Thanks again CJ for your advice. I've re-attached an updated example for all to see my intentions with the report this will hopefully end up with. I've also added all the buttons to the form so people can see all the options that will eventually be required: group 1 with 18 group 2 with 3...

Hi CJ, Thanks for the reply - your "case" code looks like the best one for me. your point over the best layout however has got me thinking and posed a second question: Although I take on board your comments about updating code and forms etc if further options are needed; the users have all...

Hi, Can someone point me to the right direction? I've created a form with three option groups on it. I need to restrict the options available in the third group depending on what answers the user chose in the previous two groups. I assume this will need to refer to a table with the details...