Go Back   Talk Microsoft > Microsoft Operating Systems & Software > Microsoft Office Family

Reply
     How do u make a sheet on microsoft access where it will show all the  
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 10-18-2007, 10:48 PM
Junior Member
 
Join Date: Oct 2007
Posts: 5
Default How do u make a sheet on microsoft access where it will show all the

information of multiple tables? when i try to do it the data repeats an object over and over and then moves to the next object and data from another table is in order but repeats everything over and over
Reply With Quote
Links
  #2 (permalink)  
Old 10-20-2007, 12:54 AM
Junior Member
 
Join Date: Oct 2007
Posts: 11
Default

To eliminate repetition of records begin your query with . . .

"Select DISTINCTROW "

A more definitive answer would depend on knowledge of the tables (and relationships) you are using in the query.

§
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -4. The time now is 10:21 PM.