Search results for query: *

ok... it's the NZ portion of the expression that is killing me. if i remove that NZ portion it works without the maketable. leave it in, and it only works with the maketable and with very poor performance (long lag). what is the best way to use the NZ function or the IIF statement?

i dunno. i just saw the ! notation before and i stuck with it. back to my problem... i did a maketable on the first field with the current_ltv field. this let my second query with the sum work. why is that? i dont really think my expression was that complex. is there a way to make it work...

i just tried what you suggested, but the second query summing the current_LTV field still produces the same error.

pulling the data from other queries. i thought []![] notation was standard...

i have a field in a query with a field called current_LTV: current_LTV: IIf([qfinancial]![most recent appraisal value] Is Null,[qfinancial]![Actual Balance]/[all]![appraisal value],[qfinancial]![Actual Balance]/[qfinancial]![most recent appraisal value]) and then in another query, i want to...

i figured it out. i was simply trying to filter the underlying recordset that was being pooled together by a query called qall. so all i did was create a form called switchboard with a txtbox called whichseller and a command button to generate the different reports i want. and in my query...

frink, what if seller is not a field in the query the report is based on? basically, i'm trying to choose between using the entire recordset and a subset of the recordset (namely, where "qall.seller = 'cibc'" qall, being the query which pools my entire recordset together.)

jjob, will this work, even tho the report being generated isn't directly based on the query qall? qall contains the field being filtered on, "seller" the report is based on a query called qreport which is a result of a series of queries on qall and does not include the field...

Hi, I am fairly new to Access as well as VBA. My current setup has a report called "qall summary" which is generated by a bunch of queries all going back to a single query which collects the raw data together, called qall. I want to be able to: 1) generate this report based on ALL...

Hi, I am fairly new to Access as well as VBA. My current setup has a report called "qall summary" which is generated by a bunch of queries all going back to a single query which collects the raw data together, called qall. I want to be able to: 1) generate this report based on ALL...