Search results for query: *

Hi, How can I select all or part of the data from a table, create a new table and insert all the selected data in it. My query would look like Select * from table but how can I create a new table and insert those data in it. Thanks for your help

I am using Pervasive and Crystal report without any problems. Pervasive 10, and Crystal 11 by the way. To do some reports I sometimes extract my data and put the tables in an MS Access Db. My crystal report is using an ODBC connection to the Pervasive, and the MS Access, so I just change link...

On my report I have a set of specific values that I sum. I would like to calculate the percentage of each value compared to the total of all values. Obviously the total value is known only when the report is done. I did this a long time ago, but just do not remember how to do this. Any Hint...

My table is as follows Sales|VendorNb|EmployeeNb| I created a report showing sales by employee Nb if vendor Number is 11111. Now I would like to modify my report to have 2 columns: 1 Column showing sales from vendor 11111 1 Column showing sales from other vendor items. For example, Employee...

I would like to create a sql statement to update one field with the first 5 digits from another field. for examople; Column1: 'This is a test' Column2 would be 'This ' If I was able to do this in Access, I have problem to do this directly from the Pervasive SQL prompt. Any help or suggestion...