User Profile

MooseManDan · Mar 9 '07, 03:47 PM

Pardon my stupidity, can I do that? I get my data from an entire separate database and then import it in from the excel spreadsheet to access called DOWNLOAD. I can't mess with the data from the excel spreadsheet because it is locked and will not allow me to add any fields.

MooseManDan · Mar 2 '07, 03:21 PM

That worked perfectly; thank you very much.

On another note: How can I set MAIN DATA Table to update automatically with the DOWNLOAD (linked excel sheet) table?

MooseManDan · Mar 1 '07, 09:21 PM

Code:

SELECT [Main Data].SSAN,
       [Main Data].RANK,
       [Main Data].SUPER,
       [Main Data].NAME,
       [Main Data].[OFF SYM],
       [Main Data].[Type Award],
       [Main Data].[Date DECOR Received],
       [Main Data].[Date DECOR to 9RW],
       [Main Data].[Date DECOR RTD for Correction],
       [Main Data].[Date DECOR to MPF],
       [Main Data].[Date RIP DECOR  received

...

MooseManDan · Mar 1 '07, 05:27 PM

Okay,

I tried as suggested and the code did not list the name in place of the SSN, instead it lists error#.

Here is how the DB is set up...

Tables: DOWNLOAD (Link table) and MAIN DATA. DOWNLOAD is the excel spreadsheet that has all the main information in it. I loaded that into MAIN DATA table so I can add additional fields. I did this because I can only download the DOWNLOAD sheet. How can I set...

MooseManDan · Mar 1 '07, 03:22 AM

Main Data Query is the source...

MooseManDan · Feb 28 '07, 12:18 AM

I tried as suggested but to no avail, I had no luck. Any other suggestions?

MooseManDan · Feb 27 '07, 07:18 PM

Thank you Mary! I'll give it a try.

User Profile

Profile Sidebar

Leave a comment:

Linked Table Download--->Main Data Table

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Access Relationship help please