Search results for query: *

Thanks very much for that - cant believe it was something so simple.

Hello Everyone! I hope somebody can help me with this query. I am using Crystal Reports 9 to report on an SQL Server 2005 database. I have been asked to do a report that calculates the amount of products sold by each salesperson grouped by product. The problem arises because although there are...

That worked perfectly, thank you!

This should be a straightforward enough question but I am having some problems resolving it. I have a string value which contains numbers which I need to pad with leading zeroes if the number is less than 4 digits in length i.e if the value has 1 digit it needs 3 leading zeroes and if it is 2...

Thanks vbjock and BobRodes!

Hello, I dont normally do any VB programming so you will have to excuse my ignorance. I have been asked to extract all the individual lines of text from a text file and to take this information and put it into a table in an access database. I understand that this will involve looping through...

Hello, Apologies if this is terribly obvious but I cannot get my head around this problem. I am using Crystal Reports 9 to report on a SQL 2000 database. I have been asked to produce a report that shows resources issued on a particular day(I am reporting on a library system). This hasn’t been...

Thanks very much synapsevampire and lbass, that has worked!

Hello, I have been asked to trim a number field in an Access database to remove all but the first two digits after the decimal point. The number of digits before the decimal point varies and I have am having some difficulty creating a script that will ignore the digits before the point and just...

Hello, I am using Crystal Reports 9 to report on an Access database. I have been asked to produce a report which will display the number of books that were on loan on a given date (I am reporting on a library system) The formula I had devised to do it was as follows: If...

Hello, I am working with an Access 95 database and have been asked if I can produce an SQL statement which I am stuck on. There is a table called Catalogue which contains a field called Author. Over time some of the values in this field have been entered in an incorrect format i.e...

Thanks for that!

Hello, Apologies if this question has been asked before. I am using Crystal Reports 9 on an Access database. I have created a bar chart which displays catalogue records in stock grouped by owner (I am reporting on a library database). Unfortunately some of the items have no owner so the bar...

That worked, thanks very much for that!

Hello, There is probably a very obvious solution to this question but I cannot work it out! I am using Crystal Reports 9 reporting on an Access database. I have a table called Enrolment which contains a column called group.At present I am using a parameter which forces the user to choose which...

Many thanks for that - I will give it a try

Hi, I am using an Access 97 database and I have been asked to tidy one of the fields by removing the first 2 characters in the field if they are numeric. This is lightly beyond my limited sql expertise - is there any easy way to do this? Many thanks.