Access 2003

Hi Claire

Thank you for your question

Could you please clarify what you wish to achieve. Do you wish to use a Vlookup function to reference different fields in a table or query? It would also be helpful if you could give an example of the sort of data you would be working with.

Thanks

Stephen

Dear Claire

Thank you for attending Access courses!! I hope you enjoyed the courses and benefited from them.

The function that is required to lookup values in MS Access is Dlookup. Please refer to the following links to get some basic understanding how they work:

http://office.microsoft.com/en-us/access/HP011004351033.aspx?pid=CH062526711033

The following link provides you with some examples for the Dlookup function in MS Access.

http://www.blueclaw-db.com/domain_aggregate_function/dlookup-function.htm

AS I can see that you have done MS Excel Advanced with us you may be more comfortable with Pivot tables. You can achieve this in MS Access by clicking on the view button and choosing Pivot Table or Pivot Chart view from the drop down list.

We do cover Pivot table sand other advanced topics such as Macros, SQL, etc.. in Advanced Access course.

Please find the link below to see the course content for our Access Advanced course as well as the schedule for the future training:

https://www.stl-training.co.uk/advanced-microsoft-access-in-london-2003.php

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
MCT