Recent content by darylharris

Hello All, Does anybody know a away of copying access data into other applications without the header row. An example being if you copy access data into excel it includes the header row in the spreadsheet. I often have to copy access data into industrial application software but usually paste...

Hello All, I have a database with multiple tables, each table with a subset of common fields I need to work with. The way the database was set up was a series of append queries that created a common table to combine the subset of fields. The problem with this is that I had to work with the...

Thankyou Thankyou all so much for your help. Adam, your code works brilliantly!! I owe you several beers... Cheers Daryl

Revised Transpose Post Yes sorry for the format. I was rushing to catch a train from work and copied it in quickly and it turned out terrible. I will now attempt to explain it better... I am having trouble trying to get it to look right in text so will attach screenshots of what I'm trying to...

Hello all, I have data in a query that I need to transpose as demonstrated. Any thoughts on how I might do this, appreciated. Regards Daryl Existing Format DRAWING PROTOTYPE _3 _4 _5 _6 _7 _8 _9 _10 MC_I_E_43 DOLSHT1 A B C D E F G H MC_I_E_44 DOLSHT2 F N K MC_I_E_45 DOLSHT1 A B C...

Moniker, Thankyou so much for your help and reply........ I am slowly working through it and it is making more sense the more I do. If I cant get it to work, I will have to fly you out to Australia to help lol. It is beautifil here at the moment... mid summer and te job is very close to Bondi...

Hello all I was wondering if there is limitation to the number of IIf statements that can be nested in a calculated field. Basically I need to assign a particular ‘label code’ to a record that will be derived from data with in several fields within the query. The data from the table (that the...