Creating a report with null's not showing

[pbaldy]

I practically wrote it for you on the other thread. All you had to do is fix the field names.

[brobb56]

I am a novice. I am trying to learn. I am no where in the leaugue you are but I want to learn. I do not know where to place the string. Tell me where to put the string. Give me the string again of you please and i will try it. I am sorry.

Thanks

[pbaldy]

Don't be sorry, but don't be helpless either. Give the string to you again? You can go to the other thread and get it as easily as I can. I told you where it goes there. You obviously know how to create a query, since there are several in the sample. Start a query with the wizard that gets the first year/form, then switch it to SQL view. Copy the format of what I did there.

[brobb56]

Thank you for your time.

This issue is still open. I have received "help" with expectations that I can fill in the blanks. I am not stupid or helpless. I however, can not fill in the blanks. All I request is someone who wishes to help and explain.

Thank you

[brobb56]

strings were given to solve this however, the instructions were very sketchy and did not help me in making a union. As a novice, concise complete and understanding assistance is what would help. Does anyone know how to create a union. It is clear I am a novice and no doubt test the patience of those more learned. PLEASE HELP A NOVICE LEARN.
Thank you

[pbaldy]

SELECT Calls.Borrower, Calls.[Report ID], Calls.[Years Requested 1], Calls.[Form Type1]
FROM Calls
WHERE Calls.[Years Requested 1] Is Not Null
UNION ALL
SELECT Calls.Borrower, Calls.[Report ID], Calls.[Form Type2], Calls.[Years Requested 2]
FROM Calls
WHERE Calls.[Years Requested 2] Is Not Null
UNION ALL
SELECT Calls.Borrower, Calls.[Report ID], Calls.[Form Type 3], Calls.[Years Requested 3]
FROM Calls
WHERE Calls.[Years Requested 3] Is Not Null
UNION ALL
SELECT Calls.Borrower, Calls.[Report ID], Calls.[Form Type 4], Calls.[Years Requested 4]
FROM Calls
WHERE Calls.[Years Requested 4] Is Not Null

[brobb56]

Thank youbut I do not know where to place it. I did unions in Access 2003. This 2010 is very greek to me and I am without understanding to creating a union.
Thank you

[pbaldy]

I'm not sure how to say it any clearer than to start a query and switch to SQL view. Does this help?

[brobb56]

I will try this.

[brobb56]

I took my old query. I did a union on it and there are a few cells that are crossed years to forms. Other than that it is perfect. Any suggestions.

[pbaldy]

I have no idea what "crossed years to forms" means.

[brobb56]

Only on some records the year shows up in the form column and the form type shows up in the year column. I deleted all records and put new ones in and it seems to be on year 2 and form 2. Other than that your advise has been stellar and it looks just like it needs to. Any ideas on those few that go awry?

[pbaldy]

If you look at the SQL I posted, you'll see I reversed the form and year in the first SELECT clause. They should all match, so the order of the 4 fields in each of the SELECT clauses is the same.

[brobb56]

I should have caught that. I will play with it and add new records. If this works, which it looks like it will. I just need to add one more column at the end that will be labled FOR IRS USE ONLY, Thoughts.... my concern is the union. Pbaldy, thank you for your patience and superb knowledge.

[pbaldy]

You can add it to the UNION (each part):

SELECT Calls.Borrower, Calls.[Report ID], Calls.[Form Type2], Calls.[Years Requested 2], "FOR IRS USE ONLY" AS Whatever

but I'd probably just add a textbox to the report that contained it.