microsoft+access+training - queries
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft+access+training - Queries

microsoft+access+training - Queries

resolvedResolved · Low Priority · Version Standard

replyReply Tue 24 Apr 2007, 13:04Delegate Christopher said...

Christopher has attended:
Access Intermediate course

Queries

WHEN YOU RUN A QUERY BUT THE TABLES AREN'T LINKED PROPERLY, WHAT HAPPENS ?

For upcoming training course dates see: Pricing & availability

replyReply Tue 24 Apr 2007, 14:55Trainer David said...

RE: Queries

Hi Christopher

If the tables are either not linked or not linked properly, then the query will either not run or it will not return a correct data set. If a query uses multiple tables, these table will have to be linked properly other when the query runs, it will not be able to manipulate the data correctly.

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


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard