Search results

Thanks Wayne, that worked!

Is there a way to query half the records of a table? I currently have a make-table query which generates a "New Days Work" Table, based on date. I would like to further divide the "New Days Work" table into equal halves, but have not found a way to do it. Any suggestions? Joe

I was wondering if there is a way to export the Table Design Structure: 1) Field Name 2) Data Type 3) Description Into a Spreadsheet. I was able to do this a long time ago, but can't seem to remember. I'm using Access 2000. Thanks! Joe

Wow, that was quick! Your revised line worked perfectly! Thanks again Joe

I was able to use a past thread to get pretty close, but not quite there. I'm trying to enable the user to select a table to view, by keying in the archive table name. My code is as follows: Public Sub OpenArchiveTable() Dim strArchiveTableDate As String Dim archivetableexists As String Dim...

The two tables that I am trying to compare are housed on two separate systems. Therefore, there are no keys or standard linking mechanisms. This is a problem because I'm forced to compare the name fields, which do not have the same structure.

I am trying to find matches between two tables using the name field. Table A has 115 records and I am trying to pull the account number from Table B, which has over 500,000 records. The problem I'm facing is that the two name fields are not in the same format. For example: Table A Name -...