Recent content by wilkob

I am in need of advise from you experts :-) I want to build a database stored on a server which can be used by our employees as basis for their Excel pivot reporting The idea is as follows: I make a query that will get selected data (via odbc) from several Progress database tables of our ERP...

Hi all, I am using the a transport delivery performance query and module giving me the working / business days This module I got of microsoft.com and included the holidays I would like to extend below script to use only then holiday when it is linked to the country where the goods are send...

Hi and thank you for your reply Since we have a lot of small customers that I am not interested in, I decided to take the top 150 I was thinking of doing an descending sort on sales turnover in the table Sales 2008 (made a misstake in my earlier post) Then I will manually delete all records...

Hello, As a newbie I need help with the following I am trying to use MS access to collect Sales data via an ODBC connection and to output it in a certain fomat. Basically I have done the following: 1. Create a maketable query to extract ALL sales data from 2008 into a table called Sales2009...

WORKS LIKE A CHARM !!!! :D many thanks

I am trying to clean up and organize a database through a series of queries. First I have a maketable query that creates a local table Then I have some update queries that clean up the local table and put parts of a long line of text in a column over various columns Finally I have a select...

I don't know if this is possible, but I thought I ask I have a column with name Diameter in the records of the column I have the different dimensions in numbers 1,2,3 etc Is there a way to create a new value in another field that gives Diameter: 1 mm Diameter: 2 mm Diameter: 3 mm Just...

Fields: Spec Thick Wdth Lgth Dia OD ID HB Rm Rp02 Rp05 A5 A4 Yield Elong IACS All fields are text field 255 characters long UPDATE TagsTraceDatabase SET TagsTraceDatabase.Thick =...

hello I am trying to run an update query on a database with about 12000 items First I run the query, get the message that it will update 12000 items and then I get a next screen which shows me the following message (my applogies for the translation :-) ) not all records in the update query...

one last one and then I promise that I'll stop I ran my update query and have two problems: 1.) I get a message that 144 records could not be updated because of an error of the type conversion ? Where can I find an error logs which list some details on these 144 records? 2.) for some of the...

I am a very happy man. Couldn't let it go and struggled along :-) Understand now the code, where to put it and have solved my problem: UPDATE TagsTraceDatabase SET HB =...

I thought I understood what I had to do :rolleyes: but then things went bad 1.) I added the two columns HB and Rm to my table 2.) I created an update query and copy/pasted the code from WayneRyan into the SQL text 3.) I ran the update query and presto : it says None in the column HB anyway I...

Oh my, I am way out of my league..... :o This is NASA math to me. I have copied and pasted the code in a new query design(in a SQL layout) and have changed the name of MyTable to the table that holds the source data. Is this what I should have done because I am getting errormessages

I have got another one very tricky issue (I am building it up in difficulty :-) ) I have two field in my table in which there is a row of text like this: QCV=<OK>/QCD=<OK>/HB=<196>/QCH=<OK>/Rm=<625>/Rp0.2=<286> I would like to get rid of all the QCV=<OK>/QCD=<OK> QCH=<OK>/and then move the...

GOT IT !!!!!!! Messed about a bit more and just used the [group] & Replace([size]," ","") & [grade] and it did the trick :-) Thanks