-
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.
Code:
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.
-
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.
-
K, sounds good. Tomorrow verify that your field type is a date/time for opened.
-
Hi just noticed the change statment. tryed it and had the same error.
-
-
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. ;)
-
Ok. have removed any sensitive info.
-
thanks talk to you tomorrow.
-
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.
-
Morning, well afternoon :)
When i try to open it or convert to 2000 i get a you dont have rights error.
-
Create a new mdb and import from the 97 one. That should get around the security.
-
Ok imported into new 97 db and then converted to 2000. during conversion i recieved a "could not find description field" error and halts
-
can you not create a 2000 one and import from the 97? (getting around the whole conversion thingee)
-
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.
-
Okay, pick up your computer and throw it across the room. Lemme know if that fixes the problem. ;)
-
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.
-
-
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.
-