Search results

Hi All, I have a table with 60+ fields, which includes around some 30 dates also as field names. Now my requirement is that i need to move those date field-names alone into another table or a query..? Ex : Table Field 1 | Field2 | FIeld3(date) | Field4 (Date) | and so on... The new table...

Hi, Below is my sample table structure. ------------------------------------------------------- |Name | Type | week1effort | week2effort | week3effort| -------------------------------------------------------- Mr. A | X | 5 | 6 | 2 | Mr. A | Y | 7 | 1 | 3 | Mr. A | Z | 5 | 6 | 3 | Mr. B | X |...

Hi, I have to export 4 queries into 4 sheets of single excel file. I dont want the file path to be hard coded, instead user should be able to select the file location unsing Save Dialog box. My Code works fine for getting 4 sheets into Excel sheet well. Also please check in the following code...

Hi, I have to find the records in table A which are not present in table B and display it as result. But the Problem is value in table A might not be exactly same as the values in Table B. For Ex : Table A - contain value 125458 Table B might contain value same as 125458 or something like this...