Search results

I know how to do it! Tools menu --> Analyzer --> Documenter. Select the necessary tables to be printed out. That is! Wilson

Anyone knows how to export data structures from MS Access 2000? I want to export field name, field type, field size, remarks from the structure. No records are required! Does it possible? Please help! Wilson

Thank you for your replied. I was managed to correct the statement. It was not data type conversion error but just the Access gave wrong message. I corrected and fixed it already! Bye. Wilson

Can I insert record from the SELECT statement as below: INSERT INTO Table1(Field1, Field2) SELECT B.Field1, Count(B.Field1) FROM Table2 B WHERE (B.Field2 BETWEEN #01/01/2003# AND #25/01/2003#) GROUP BY B.Field1; I have tried in MS Access 2000, it gave me error. It said data type conversion...

Hi Hayley, This attachment is not help me much! What I need to generate the row number from the SQL. For instance, Table1 ===== Field1 Field2 Field3 Say, I want to list out all the fields with the record sequence number (row number) in Oracle, I can do like this: SELECT RowNum...

Hi, Anyone knows how to get the row number in Microsoft Access 2000? In ORACLE, we can do like this: SELECT ROWNUM, Field1, Field2, Field3 FROM Table1; How do I write SQL statement in MS Access 2000? Thanks. Wilson :D

Hi, Anyone knows how to get the row number in Microsoft Access 2000? In ORACLE, we can do like this: SELECT ROWNUM, Field1, Field2, Field3 FROM Table1; How do I write SQL statement in MS Access 2000? Thanks. Wilson