Page 2 of 3 FirstFirst 123 LastLast
Results 16 to 30 of 42
  1. #16
    geniass is offline Novice
    Windows 7 Access 2007
    Join Date
    Aug 2010
    Posts
    20

    Yes the way its curently set up is that the ID's are autonumbers but seem to be arbitary. But the Id's couldn't match the Id's in table 1 because there should be more items in table 1 than table 2, or have I just misunderstood you?

  2. #17
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Do you allow special keys?

  3. #18
    geniass is offline Novice
    Windows 7 Access 2007
    Join Date
    Aug 2010
    Posts
    20
    I dont know, how do I do it?

  4. #19
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    Good luck with it Gen. You're in good hands with Ruralguy .

    I think I cluttered this thread up too much. Better always to get advice from just one person to keep the confusion to a minimum. If you need clarity on any of the info I gave, send me a message.

  5. #20
    geniass is offline Novice
    Windows 7 Access 2007
    Join Date
    Aug 2010
    Posts
    20
    Ok thanks ajetrumpet, i'll send you a message if i need more help, but i'm still baffled here.

  6. #21
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Quote Originally Posted by geniass View Post
    I dont know, how do I do it?
    Thanks Adam. I have some time to assist here. As for Special Keys:
    Office Icon>Access Options>Current Database>Use Access Special Keys

  7. #22
    geniass is offline Novice
    Windows 7 Access 2007
    Join Date
    Aug 2010
    Posts
    20
    Ok I enable special keys, pressed ctrl G and the imeediate window is empty.

  8. #23
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Here's a picture: http://www.btabdevelopment.com/ts/de...aspx?PageId=28
    ...right below the Tabbed Documents function.

  9. #24
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    So the query is *not* running then, right? How are you attempting ro run the query?

  10. #25
    geniass is offline Novice
    Windows 7 Access 2007
    Join Date
    Aug 2010
    Posts
    20
    Here's the query:

  11. #26
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    When you switch this query to Datasheet mode are you getting any records returned? As Adam was explaining, without a join of the two tables you will probably get a cartesian product of the two tables.

  12. #27
    geniass is offline Novice
    Windows 7 Access 2007
    Join Date
    Aug 2010
    Posts
    20
    I am getting some records and the only field missing, is price.
    Also by the way their are 2 records in table 1, but any query i make returns each record twice do you know why this is?

  13. #28
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Quote Originally Posted by geniass View Post
    Also by the way their are 2 records in table 1, but any query i make returns each record twice do you know why this is?
    The long answer is: http://en.wikipedia.org/wiki/Cartesian_product
    The short answer is All of the records from the second table for each record of the first. In otherwords, all possible combinations.

  14. #29
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    You have also named two fields in your query [Price]. Not a good practice.

  15. #30
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    This appears to be just a test db so how about posting the db so we can play with it?

Page 2 of 3 FirstFirst 123 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. query problem i have a problem wi
    By maxx3 in forum Queries
    Replies: 0
    Last Post: 06-29-2009, 02:29 AM
  2. Problem with query
    By maxx3 in forum Queries
    Replies: 8
    Last Post: 06-08-2009, 11:58 AM
  3. query problem
    By maxx3 in forum Queries
    Replies: 35
    Last Post: 05-29-2009, 04:07 PM
  4. Top 25 query problem
    By tmcrouse in forum Queries
    Replies: 3
    Last Post: 05-07-2009, 09:02 AM
  5. Problem in Query
    By Bruno Trindade in forum Queries
    Replies: 4
    Last Post: 03-28-2009, 04:10 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums