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

ms+access+courses - queries

Forum home » Delegate support and help forum » Microsoft Access Training and help » ms+access+courses - Queries

ms+access+courses - Queries

ResolvedVersion Standard

Per has attended:
Access Intermediate course
Access Introduction course

Queries

How can I create a query that links a company with reports recieved?

RE: Queries

Hi Per

Firstly you would need to link the two tables using primary and foriegn keys. Once this is done you can then use a query to extract all reports for a customer, to do this you would use the fields that link the talbes (primary and foreign keys).

Hope this helps
David

Access tip:

Display current date & time in column of any width

The worksheet function =NOW() returns the current date & time. When entered into a column which is not wide enough to display the value NOW returns, the cell displays ###

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.08 secs.