Back again

[Cronk]

If you don't see any output in a report (or form) where you expect to see data, the first thing to look at is the data source for the report.

If you open your query, there is no output because you don't have corresponding records in all of the tables in the report.

Your query is based on Inner joins. Google "Outer joins in access queries" to see how you can get around the issue of missing data in the joined tables.

 

[Sarah Byrne]

I just had a look on google at that and put the information needed in the tables and form and still nothing. I know its got to take its information from somewhere (query). In the northwind example its showing that the query (after selection) has brought up the filled out fields in the table http://office.microsoft.com/en-gb/a...n-outer-join-query-in-access-HA001034555.aspx I didn't think you had to do that and that access would do that for you? Also if you look at my report in my last post, if I add a subtable for the brief description, contact and comments this will bring up the whole thing from jobsheets. All I want is for there to be multiple lines for this like in the report so that they can sign off each individual thing as they go along. I know I post a lot and probably being rather annoying but after trying to google things for a while you start to hate google and I rather like google

 

[Sarah Byrne]

*does the dance!!* Ohhhhhh yehhhh!!!

 

[Sarah Byrne]

Sorry Cronk that subform that you added to the jobsheet to display the contacts as a list check box. It comes up no or yes in the report. How do I change that so that it come up with the name I have tried and I now want to bash my head against a wall. everything else is fine and all up and running but this has me stumped.

 

[Cronk]

Sarah

Re-read my last post. That applied to no data being displayed. If the displayed data is not what you expect, follow the data path.

What's the data source for the report's text box? What does the report's recordsource show for that field? Then back to the underlying table and what is physically stored in the table.

 

[Sarah Byrne]

This is what I don't understand it comes up that there should be Mr Joe Blogs but its just coming up Mr. I know that for this reason you shouldn't use lookups but as I don't know VBA this is the way that I chose to do it.

 

[Sarah Byrne]

Was a simple Trim

=Trim(IIf([Title] & " " & [FirstName] & " " & [LastName],[Title] & " " & [FirstName] & " " & [LastName]))

That had me bashing my head against a wall for a long time.