• WSzbrett

    WSzbrett

    @wszbrett

    Viewing 14 replies - 31 through 44 (of 44 total)
    Author
    Replies
    • in reply to: Query Question (97) #617566

      That is exactly what I was trying to get to but I had the syntax wrong. Works great. Thanks!

    • in reply to: Exporting to Excel (97) #614492

      That made sense and I no longer lose the “+” signs when I export to Excel. Thanks!

    • in reply to: Exporting to Excel (97) #614360

      I tried to specify the column as text in Excel, but it doesn’t make a difference. The custom format is a good idea, except these are credit rankings and if I do that, it places a “+” in front of all of the positive numbers where I only need it on certain ones. i.e. 3 and 3+ would both be valid entries in the column.

    • in reply to: Exporting to Excel (97) #614349

      That sounds promising but I’m fairly new at Access so I not exactly sure exactly where to do this in the query or report

      Thanks

    • in reply to: Exporting to Excel (97) #614157

      I tried that and it works, but I lose some data calculations that I’ve incorporated into the report that isn’t in the query.

    • in reply to: Exporting to Excel (97) #614101

      I tried that but it didn’t work. Somehow I have to have Access create the column as a text field in Excel before it exports the file, if you know what I mean…

    • in reply to: Crosstab Query Question (97) #537974

      I only figured it after thinking really hard about what was going on and a little trial and error. However, now when I export the report into Excel, it drops the column sums that have the Nz function in them but picks up the rest. Anyone know how to fix that? You close one door and another one opens…

    • in reply to: Crosstab Query Question (97) #537949

      To answer my own question in case a hapless Access newbie like myself has the same problem. If you use Nz in a report text box, the control data and name must be different or you will get an error…

    • in reply to: Crosstab Query Question (97) #537924

      I tried that and I got a #Error in the report column… other variations yield all zeros, wiping out any values. Hence my frustration.

    • in reply to: Crosstab Query Question (97) #537916

      Here is the Query. Can anyone tell me how to insert the Nz function and make it work. I’m about ready to give up…

      TRANSFORM Sum([Cost, NBV, RV].SumOfLRESID) AS [The Value]
      SELECT [Cost, NBV, RV].[Dealer Name], Sum([Cost, NBV, RV].SumOfAEQPCOS) AS SumOfSumOfAEQPCOS, Sum([Cost, NBV, RV].MaxOfLNETINVS) AS SumOfMaxOfLNETINVS, Sum([Cost, NBV, RV].SumOfLRESID) AS SumOfSumOfLRESID
      FROM [Cost, NBV, RV]
      GROUP BY [Cost, NBV, RV].[Dealer Name]
      PIVOT Format([LTERMDA],”yyyy”);

    • in reply to: Crosstab Query Question (97) #537907

      I stumbled onto the Nz function after posting and was playing with it. I guess the best solution is to use it at the report level but I’m having trouble making it work. The contol source in the text box for the column is 2003. I either get all zeros or error. Could you give me some examples of what is the correct format for the Nz function in this case?

      Thanks so much for your response.

    • in reply to: Date Input Mask (Access 97) #533899

      I didn’t really check the Excel dates, good catch.

      I resolved my problem the easy way. I went to the person who generates the file I’m importing and asked if the date format could be changed to mm/dd/yyyyy. No problem. Wish I had thought of that before I spent a bunch of time trying to make it work. smile

      Thanks for the reply

    • in reply to: Date Input Mask (Access 97) #533810

      Eeek. I’ll try to figure it out (just starting with Access). I wonder why Excel handles it and Access doesn’t. Does Access 2000 have the same problem?

      Thanks for your reply.

    • in reply to: Add months to date help #524649

      Thanks Andrew. FYI – I also found out that EDATE will do the same thing.

      Regards,

      Brett

    Viewing 14 replies - 31 through 44 (of 44 total)