Search results

I have a query 2000+ records in an access 2003 database. Each record is assigned a category in a field called “Fund” (for example, “SCUAD” or “4579”) What I want is to add an incremental count to each record for each Fund. For example, if there were 25 records with Fund = SCUAD, the first...

Hi Jdraw Thanks for the reply. I really want to use TRANSFORM. Regards

Hi I have created the following query (UL) with fields (Clients, Products): Clients Products 726 654 726 278 726 6100 7402 293 7402 8109 HUYT 654 HUYT 8109 HUYT 7440 HUYT 7991 and please advise how to use the Transform function to create the following query: Clients Product1 Product2 Product3...

Hi I'm new to this forum and would like to get help and learn more from the experts. Attached is the file that shows how I wrote the macro (highlighted in green) in access to extract the data from the excel (part of the file). I put the excel to the access table and run the macro. However, I...

Hi I'm new to this forum and would like to get help and learn more from the experts. Attached is the file that shows how I wrote the macro (highlighted in green) in access to extract the data from the excel (part of the file). I put the excel to the access table and run the macro. However, I...