Search results

I removed all the queries from the report query and readded them all, set up the relationships and added appropriate fields. In the text box with =IIf(IsNull([P1 testing.DRV]) And IsNull([P2 testing.PASS]),"No Issues",[P1 testing.DRV]+Chr(13) & Chr(10)+[P2 testing.PASS]) ...... i get a blank...

Hi boblarson. I tried that from your earlier post - however access give me a "Enter Parameter Vaue" for [P1 testing]

Im just trying a few things and renamed the queries P1 and P2 to "P1 testing" and "P2 testing" resp. Of course adjusted the formula and updated the record source in the report accordingly. =IIf(IsNull([P1 testing.DRV]) And IsNull([P2 testing.PASS]),"No Issues",[P1 testing.DRV]+Chr(13) &...

Guys - Kudos! thank you for your help. I now understand why Chr(13) & Chr(10) was not required in the first part (with Null) I tried =IIf(IsNull([P1.DRV]) And IsNull([P2.PASS]),"No Issues",[P1.DRV]+Chr(13) & Chr(10)+[P2.PASS]) and the issue is resolved. Thanks again - all of you.:D

Tried your idea as well and unfortunately its still blank =IIf(IsNull([P1.DRV]+Chr(13) & Chr(10)+[P2.PASS]),"No Issues",[P1.DRV]+Chr(13) & Chr(10)+[P2.PASS])

Attached a test database. Im using Chr(13) & Chr(10) for the new line. Dunno if that causes issues with null NOTE: Once you open the attachment, you will find the report shows data in the text box, but if you change the date in table P1 to yesterday (or something other than today) you will find...

thanks - I tried =IIf(IsNull([P1.DRV] & Chr(13) & Chr(10) & [P2.PASS]),"No Issues",[P1.DRV] & Chr(13) & Chr(10) & [P2.PASS]) but im still getting a blank/empty - it doesnt show "no issues" P.s. P1 and P2 are the queries, DRV and PASS is a concatenate of two fields in those queries. So DRV...

how would I do that in a query? Just type the formulas in the criteria?

Hello good people. I'm working with a report that pulls data (text) from a query and it works fine. What I would like to do is: >>> IF a text box (text71) in the report is blank (no data found in the query) then show "No Issues" I currently have =[P1.DRV] & Chr(13) & Chr(10) & [P2.PASS] in...

Thanks guys. I think this issue has been resolved. The combination of concatenating in the query and the "proper" relation ships have reolved the issue. Thanks again.

Yes this is for a daily report so I only want records that were entered today, i will also add another criteria later for the name. I will try the relationship above and get back to you. Thanks.

In the attached file all dates are todays and you will see in the report that the formula: =[P1.SKU] & " " & [P1.Notes] & Chr(13) & Chr(10) & [P2.SKU] & " " & [P2.Notes] shows all the necessary fields. But as soon as I change the date in one of the tables, then I get errors.

The issue is with the report. The query (P1 or P2) seems to be working as an example below is the sql: SELECT Table_P1.Names, Table_P1.SKU, Table_P1.Notes, Table_P1.ID, Table_P1.Dates FROM Table_P1 WHERE (((Table_P1.Dates)=Date())); I have also attached a test database. Thanks.

Hello. I've created a DAILY report to show data (text) entered into a table and I need help with it. I tried searching the forum and could not find any answers. I want the text box in the report to get data from 3 queries which have a date() criteria. P1 and P2 are queries of the original table...