Results 1 to 4 of 4
  1. #1
    ThatSkepTicGuy is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Sep 2012
    Posts
    17

    Broken Query

    Hi,

    I have a query which populates a report, only not it doesnt generate any information to populate the report.

    The only thing I have done which I think might have an impact on the query-report "relationship" was to clear all my tables of their contents as it was test data.

    Now i am trying to populate the tables again via my forms nothing appears in my report.



    Any help would be greatly appeciated.

    PS the only change i had to make to a primary field was to change it from number to text

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,726
    Tell us about your query and the tables involved.

  3. #3
    ThatSkepTicGuy is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Sep 2012
    Posts
    17
    Click image for larger version. 

Name:	Query.jpg 
Views:	4 
Size:	115.4 KB 
ID:	9262this is my query

    Click image for larger version. 

Name:	Query Run.jpg 
Views:	4 
Size:	90.4 KB 
ID:	9263this is the result of my query after being run

    Click image for larger version. 

Name:	Relationships.jpg 
Views:	4 
Size:	129.4 KB 
ID:	9264and these are my relationships

  4. #4
    ThatSkepTicGuy is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Sep 2012
    Posts
    17
    I have tried deleting all the relationships and redefining them but that hasnt helped.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Broken Query
    By lkevinc42036 in forum Access
    Replies: 9
    Last Post: 08-06-2012, 09:29 AM
  2. Broken reference
    By cassidym in forum Reports
    Replies: 15
    Last Post: 09-18-2011, 07:57 AM
  3. Update query has broken
    By eskapades in forum Queries
    Replies: 1
    Last Post: 07-11-2011, 03:52 PM
  4. Missing or broken references
    By AdrianR in forum Access
    Replies: 1
    Last Post: 06-21-2011, 10:34 AM
  5. Replies: 2
    Last Post: 10-01-2009, 03:39 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