Recent content by deepanadhi

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 wrote query as u suggested. But when 'LIKE' is used in query, the relation between Table A & Table B is the Design View gets disconnected and filtering doesnt happens as expected. All the Records are displayed in the output. SELECT * FROM tablea LEFT JOIN tableb ON tablea.name = "*" &...

Hi, Thanks alot for the reply. I am verymuch new to the Access. So can you be more specific where this piece of code should be used. your help would be much appreciated if you can explain me in bit more detail. Thanks, Deepan

//What are the data types of the values? I think the data in table A must be numbers and that of Table B is String. Is that correct? // In both the cases its string. Mostly Alphanumeric codes. Eg : Table A - TGHLU9455040 Table B - Eb5-CHJ20175, TGHLU9455040

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