Search results for query: *

I need analyse database information i.e. table name, filed name, properties etc. Is there an easy to export this information using and specific tool? I know we can use the documenter within access but I have many tables and when I export the info to excel it does not export the table name...

Hi, I need to do the following. current data extarcted like this... a 1 01/01/06 no a 2 02/01/06 yes a 3 03/01/06 no a 4 04/01/06 yes I would like the data to be shown like this for 'yes' records only a (02/01/06,04/01/06) I think you can use the WhileReadingRecords to do...

I am trying to create some address label, how can I get it repeat 7 down and 2 across, any ideas. Thanks cr 8.5

I am trying to write a formula so that it searches through Multiple fields to find values in address fields. I want use the formula to extract only these that meet the selection. E.g. Fields are say add1, add2, add3 etc I want to search for the string "GAHANA" or "ENGLAND", this could be in...

I get this error after installing Cr 8.5.. Any suggestion on a fix ODBC error: [DataDirect][ODBC Oracle Driver]The Keywords LEFT OUTER JOIN were not found in an outer join escape sequence Thanks

Hi I have lot of grouping in my report and I need to force the report to sort the data at the lowest group, how can I force it sort at that group. E.g Gooup @ a,b,c,d,e... I need it sort it at e and ignore d, but I need the grouping at the order to get the correct data. Thank you

Hi Simple question, when linking multiple tables which table should be the primary table. E.g. . Header, Detail, Detail1 Provided all the above tables are linked by key is it best to start with Detail or Header Thanks

Hi I have the following:- Two Parameter fields for limiting records shown on the report. i.e. startamt and finamt I have limited this on the group by Sum ({dbsfield}, {group field }) in {? startamt } to {? finamt } But if I enter the range for example -500 to 0, it returns value which are...

Is there a formula I can use to remove all spaces. I have used the trim command but I want all spaces removed thus from with the text. E.g " AA xx" required data "AAXX"

I need to write a report to show only new customers. I need to run the report so that it runs for 2 periods and check who new customers are in the second period. The problem I am facing is that the customers are some time duplicated and I need to exclude this. I need to check by Name and...

I need to summerise data by week for a date range. Is there a specfic function I can use to convert the date to a week number var cr 8.5

Hi I have 3 tables which I am linking but its giving me more information than i need see example below. Table 1 linked to table 2 and 2 linked to 3 Table 2 to contains 3 record and table 3 contain 8 I need to extarct the 3 and 8 records in deatil of the report TB1 no Amount 1 10 2 20 3...