Results 1 to 4 of 4
  1. #1
    Erica Nichols is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Mar 2012
    Posts
    2

    New to access and struggling

    Hi
    I am trying to create a report in access. I have used the report wizard and chosen the hotel room type and length of stay (calculated using the expression builder) on 3 seperate queries. When I press next it says "you have chosen fields from record sources which the wizard cannot connect. You may have chosen fields from a table and from a query based on that table. If so, try choosing fields from only the table or only the query."


    I do not understand why I cannot use these queries to make a report.

  2. #2
    winterh is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    110
    Sorry to ask loads of questions but first one are all the fields on the same table, second what type of data is it eg Text or Numbers, and maybe worth checking to see if the expressions are all ok eg numbers plus numbers and not numbers plus text,

  3. #3
    Erica Nichols is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Mar 2012
    Posts
    2
    Thank you for the response. I managed to work it out.
    I do not know how to lose my message or delete it.


    Quote Originally Posted by winterh View Post
    Sorry to ask loads of questions but first one are all the fields on the same table, second what type of data is it eg Text or Numbers, and maybe worth checking to see if the expressions are all ok eg numbers plus numbers and not numbers plus text,

  4. #4
    winterh is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    110
    At least you sorted it, can you mark the question as solved.

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

Similar Threads

  1. Struggling with random ratings
    By EBDoom in forum Queries
    Replies: 5
    Last Post: 03-20-2012, 02:52 PM
  2. Still struggling with relating tables
    By djclntn in forum Database Design
    Replies: 31
    Last Post: 02-14-2012, 02:08 PM
  3. My first Database, struggling a bit
    By ravihotwok in forum Access
    Replies: 1
    Last Post: 12-07-2011, 05:17 AM
  4. struggling with query, plz help
    By jimgros in forum Queries
    Replies: 2
    Last Post: 07-26-2011, 03:35 AM

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