Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. sabre30

    cartesian/crosstab query problem

    I didn't think this would work in a crosstab, but it did. I just added the IIF statement to the group by clause. TRANSFORM iif([Fldname]="Balance",[Balance],[Return]) AS TheVal SELECT rptBF_Custom5.PolicyNumber, rptBF_Custom5.IAName, rptBF_Custom5.TPMName FROM rptBF_Custom5...
  2. sabre30

    cartesian/crosstab query problem

    Thanks, yes I tried that and this is the error I get: "You tried to execute a query that does not include the specified expression as part of an aggregate function."
  3. sabre30

    cartesian/crosstab query problem

    Hi, I'm SO close, but I have a problem with a crosstab/cartesian product query that I based on Duane Hookum's example. Here's what I have: TRANSFORM sum(iif([Fldname]="Balance",[Balance],[Return])) AS TheVal SELECT rptBF_Custom5.PolicyNumber, rptBF_Custom5.IAName, rptBF_Custom5.TPMName FROM...
  4. sabre30

    pdf Form filled via OLE from Access

    Hi, I created a pdf form in Acrobat7.0 Pro. I open the pdf using OLE and fill the fields from an Access recordset in VBA. Everything works great on the development machine that has 7.0 Pro on it. When I install it on another machine that only has Reader 6.0, the OLE fails. OK, I...

Part and Inventory Search

Back
Top