Recent content by maxik

Hi all, I have looked around and haven't been able to get a solution to my problem: I need to sort the field list of the excel pivot table (when you click on the field to expand it to have the available fields sorted). :cool: Does anyone know a solution to this? Thanks in advance! Snapshot...

Hi, Is it possible to link a query in access 2002? It gives me only tables in the menu. Thanks in advance. Max

pbaldy I figured it out - format([field_name],'000') - and it worked. Thanks a lot for your help!

Paul Thanks for your help. I tried it and it worked, except I can't get those 0s in front of the ID. What's the syntax of Format?

FoFa I tried it, didn't work. the reason is access is not storing the format of the primary key, which is "AB"000, it stores just the numbers in table and when union queried it pulls only the numbers. I was just wondering if there was a work around it?

Hi all, I have a UNION query of multiple tables: Select * From tblCal_SlsAB UNION Select * From tblCal_SlsBC; Both of them have Unique IDs as PK, such as: AB001, AB002, etc for tblCal_SlsAB and BC001, BC002, etc for tblCal_SlsBC. When I do the UNION query I get: 1, 2, etc for both IDs...