Recent content by jewel

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...