Consulting

Page 2 of 2 FirstFirst 1 2
Results 21 to 39 of 39

Thread: Report help

  1. #21
    VBAX Expert xCav8r's Avatar
    Joined
    May 2005
    Location
    Minneapolis, MN, USA
    Posts
    912
    Location
    Oh, it imported the Type as text because I just accepted default. I changed it to number, then I modified the query to get rid of nulls.

    TRANSFORM Count(tblFile.Type) AS CountOfType
    SELECT tblFile.Type, Count(tblFile.Type) AS [Total Of Type]
    FROM tblFile
    WHERE IsNull(tblFile.Type)=False
    GROUP BY tblFile.Type
    ORDER BY tblFile.Type
    PIVOT Format([Opened],"mmm") In ("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec");
    Sorry for the inconsistency. I just left this as tblFile.

  2. #22
    VBAX Regular
    Joined
    Jun 2005
    Posts
    65
    Location
    Hi The ###### are only in excel. I checked the opened coloum and fixed any null values, still same error. thanks for the help i am going to start on it again tomorrow.

  3. #23
    VBAX Expert xCav8r's Avatar
    Joined
    May 2005
    Location
    Minneapolis, MN, USA
    Posts
    912
    Location
    K, sounds good. Tomorrow verify that your field type is a date/time for opened.

  4. #24
    VBAX Regular
    Joined
    Jun 2005
    Posts
    65
    Location
    Hi just noticed the change statment. tryed it and had the same error.

  5. #25
    VBAX Regular
    Joined
    Jun 2005
    Posts
    65
    Location
    yes set to date/time

  6. #26
    VBAX Expert xCav8r's Avatar
    Joined
    May 2005
    Location
    Minneapolis, MN, USA
    Posts
    912
    Location
    Well, before you go, make a new mdb to attach here and export this table to it (with these three columns). I'll see what I can do.


    ....errrr, whenever.

  7. #27
    VBAX Regular
    Joined
    Jun 2005
    Posts
    65
    Location
    Ok. have removed any sensitive info.

  8. #28
    VBAX Regular
    Joined
    Jun 2005
    Posts
    65
    Location
    thanks talk to you tomorrow.

  9. #29
    VBAX Expert xCav8r's Avatar
    Joined
    May 2005
    Location
    Minneapolis, MN, USA
    Posts
    912
    Location
    Can you convert it to 2000 format and see if you get the same error? I want to see if that's the reason that you're having problems.

  10. #30
    VBAX Regular
    Joined
    Jun 2005
    Posts
    65
    Location
    Morning, well afternoon

    When i try to open it or convert to 2000 i get a you dont have rights error.

  11. #31
    VBAX Expert xCav8r's Avatar
    Joined
    May 2005
    Location
    Minneapolis, MN, USA
    Posts
    912
    Location
    Create a new mdb and import from the 97 one. That should get around the security.

  12. #32
    VBAX Regular
    Joined
    Jun 2005
    Posts
    65
    Location
    Ok imported into new 97 db and then converted to 2000. during conversion i recieved a "could not find description field" error and halts

  13. #33
    VBAX Expert xCav8r's Avatar
    Joined
    May 2005
    Location
    Minneapolis, MN, USA
    Posts
    912
    Location
    can you not create a 2000 one and import from the 97? (getting around the whole conversion thingee)

  14. #34
    VBAX Regular
    Joined
    Jun 2005
    Posts
    65
    Location
    Ok had one error on import. under qryfind "invalid argument". when i try to do anything in the new version (design, run, anything) it generates mutiple errors.

  15. #35
    VBAX Expert xCav8r's Avatar
    Joined
    May 2005
    Location
    Minneapolis, MN, USA
    Posts
    912
    Location
    Okay, pick up your computer and throw it across the room. Lemme know if that fixes the problem.

  16. #36
    VBAX Expert xCav8r's Avatar
    Joined
    May 2005
    Location
    Minneapolis, MN, USA
    Posts
    912
    Location
    Just kidding. Here's an idea...short term workaround so you can get this report done. Try creating a new database, 2000 format, and link to the 97 mdb with tblFile. Try to run the crosstab query wizard and build a query based on that linked table. Hopefully, that'll work.

  17. #37
    VBAX Regular
    Joined
    Jun 2005
    Posts
    65
    Location
    LOL. my thoughts to

  18. #38
    VBAX Regular
    Joined
    Jun 2005
    Posts
    65
    Location
    It seems that the to complex expression error is generated by the format of opened to months. works perfect in 2000.

    I can't use 2000 for the report unfortunaty. this department does not own it and is not willing to buy and want thier in house people to be able to generate the report.

    Thanks for trying as hard as you did.

  19. #39
    VBAX Expert xCav8r's Avatar
    Joined
    May 2005
    Location
    Minneapolis, MN, USA
    Posts
    912
    Location
    Bummer.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •