cmcreynolds
Active Member
- Joined
- May 21, 2015
- Messages
- 295
so, I have run into an issue in a PQ if/then statement
if [SeatFee]="Yes" then [Program] & " (Seat)" else if [StudentMarker] <> "" then [Program] & " " & [StudentMarker] else [Program]
which is fine, but in the original data, I made an error and typed something in the cell, but then deleted it and it comes through PQ as "null" and so doesn't apply to the above if/then statement.
I have tried "clearing contents" and formatting and everything in the original cell, but it still enters PQ as null (all the other blank cells are blank).
Do I have to add another "extension" of the if/then to encompass nullses? or am I forgetting to do something in the original data?
(to get this report out today, I'm going to just add another else if [StudentMarker] <> null then... but is this the only way?)
Weird
if [SeatFee]="Yes" then [Program] & " (Seat)" else if [StudentMarker] <> "" then [Program] & " " & [StudentMarker] else [Program]
which is fine, but in the original data, I made an error and typed something in the cell, but then deleted it and it comes through PQ as "null" and so doesn't apply to the above if/then statement.
I have tried "clearing contents" and formatting and everything in the original cell, but it still enters PQ as null (all the other blank cells are blank).
Do I have to add another "extension" of the if/then to encompass nullses? or am I forgetting to do something in the original data?
(to get this report out today, I'm going to just add another else if [StudentMarker] <> null then... but is this the only way?)
Weird