Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

linking

ResolvedVersion 2003

Eduardo has attended:
Access Introduction course
Access Intermediate course
Access Advanced course

Linking

why do i get a #num reference when i link access tables to Excel tables?

RE: Linking

Dear Eduardo

Thank you for attending Access Introduction course!! I hope you enjoyed the course and benefited from it.

Please refer to the following link. You'll note that it talks about Excel 97 but I am sure it also applies to 2003.

http://support.microsoft.com/kb/162539


I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007

Tue 3 Feb 2009: Automatically marked as resolved.

Access tip:

Random sampling

Data is th key to a good database, therefore checking is essential.

A good way of checking data is by random sampling. You can do this in a query, by typing the follow:
1) In the Field box create a RandonID field eg. Randon Id: Rnd(fieldname])

2) sort the field
3)Right click and chage the properties for To value to be the number of randon records you want to see.

4) Change the set to Show row for Randon ID to be False, add all the other fields you want to see and the run the query.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.13 secs.