Search results for query: *

thanks everyone for your help here, but I am having to rethink my solution. I think I have tackled this wrong and need to use a VLookup instead, so will give this a go and repost if I need further help. thanks /Skip + CLFlava

thanks clflava I need to match columns A:B:C in both cases. in first sheet there will always be an entry as this is the master, 2nd sheet this is the one that shows only those that have been used - eg A:B:C and in column D will have say 10 or however many times the combination has been used...

hi all I have three colums on one sheet and four on the second sheet. 1st sheet is master copy- has over 5,000 records. what I want to do is match the 2nd sheet with the first and if a match bring in the 4th column or otherwise put a 0. This is my code so far, but I just keep getting errors...

thanks Skip I will have a look at this later today. thanks for your help Dianne

ok I was asked to repost my sql query - the following is what I have: error I am getting is: "The text, ntext and image data types cannot be compared or sorted except when using IS NULL or LIKE operator." SELECT Call.Ref2, Call.CallSubject2, Call.CallNumber, Call.LogDatTim...

thanks Skip Remembering we added the Group clause afterwards on your advice, I didn't have one in, (only having the Select, From, Where) so it may work quite well now but I can't get a result from your code because I get the error mentioned. "The text, ntext and image data types cannot be...

hi all linked to earlier query but a separate problem so have logged it by itself. using visual studio - have say 6 fields across top and two fields on next line. As I have had to add a table is there anyway I can make the 1st field on the 2nd line cover say the 3 fields on the top line - eg...

Is anyone else able to jump in here ??? thanks

thanks BSman for your reply. I have decided to bite the bullet and only use SQL Query Analyser and Studio, a very sharp learning curve but have already spent a few hours, certainly a little easier with an Access background, but still a lot to learn. Yes I have the full rights, so am spending...

hi Skip & PHV thanks for your replies I have replaced my query data with yours (Skip) - I had tried the sum(material field) before but ended up with all records having the same amount = 610.00 which is the total of all. In replacing and trying to run your query I get the following: The text...

thanks Skip I have put 4 of the records here - you will see by record 3 and 4 what I mean (two worktime records were added for this call there are other fields relevant so two records do need to be added - but for this report I would only want them to show once with a total of the material...

hi all I hope I'm in the right forum here I am using ms visual studio / sql query ok I have a field as below call field to Material Charge field is a 1 to many relationship =Fields!MaterialCharge.Value if a call has more than 1 worktime entry - this shows separately with a 0 balance - eg...

sorry everyone I didn't realise there was a project forum - so I have posted this one in there instead

jewel (TechnicalUser) Jul 27, 2004 I have started a new project - ODBC connection This is the first time I have used the project side - so was surprised to find no query window. Moving on I see I need to do relationships in the Diagram window. I have a call table - primary key (field...

I have started a new project - ODBC connection This is the first time I have used the project side - so was surprised to find no query window. Moving on I see I need to do relationships in the Diagram window. I have a call table - primary key (field CallNumber) and a worktime table - (has a...

hi all I am from an access background - we are starting to user MS Visual Studio.net with the query info being done in sql Query Analyser. As I haven't used these before I set up a project in Access but am having probs. Can someone point me to somewhere that will explain sql query analyser...

thanks PH - that stopped the message coming up, but it still brought up the explorer window looking for the file - so have decided to put it in the same folder and all works fine! cheers Dianne

hey all I want to set a button for users to open an xlt as an xls - this is my macro so far Sub saveas1() ' ' saveas1 Macro ' Macro recorded 17/05/2004 by Dianne Dalton ' Workbooks.Add Template:="H:\Word\Template\Tape.xlt" Windows("comp list maker.xls").Activate Workbooks("comp...

ok hopefully last post I now have a command button on my 2nd sheet - so all they need to do is press it and all works fine. Is it a good idea to hide the 1st sheet? thanks Dianne

hey thanks guys very much for all your help ok - I missed the part about importing the data and was opening the txt file instead - on rerunning the macro and importing as suggested the txt file closed automatically. so thanks and I will be more observant next time. Little learning curve here...