I have tried to use an IIF statement or switch statement in the expression part of the text box to try and single out the Value I want. Somehow, both expressions are always false, they are never true. Are my expressions evaluating the logic?
I have tried building a query that does the criteria for me, and then pointing to the one query and field that would have the sales figure I need. I am still getting a "#name" error in the report preview. Help!
Well, I have tried to create an expression using:
=[qry Trial Balance Non-Zero Values]![Account Titles]="Sales"
I was hoping that this would pick up the Value for Sales. Is this possible? How should I be approaching this issue?
Hi there, I have mostly used wizards to create my reports. I am now trying to start one from scratch, however I am having difficuly adding a record source to my report. The field list is greyed out so I cannot click it. Additionally, I am trying to pick out a particular record from that report...
UPDATE [A], [B] SET [A].PGM_YR = "*", [B].PGM_YR = "*"
WHERE ((([A].PGM_YR)="" Or ([A].PGM_YR) Is Null) AND (([B].PGM_YR)="" Or ([B].PGM_YR) Is Null));
Ok, the OR statement here has changed slightly when compared to the example of the code from prior...
I see what you mean. I have altered my sql statements to resemble yours and I am getting the results that I expect to see, there is one snag, it works for the majority of the fields, for some however, it doesn't, I have tried reversing the is null and the "" around to try see of the...
I think I know the answer to the last installment in my series of questions, I cannot criss-cross the criteria even if it's checking two tables that are not linked. For some reason and I don't totally understand the logic behind sql, the code works better if I have the two nulls on top and then...
Thanks for all your input, however the code that you have above is virtually the same as the code I pasted for you, the difference being that you create an alias for both tables, this gives you easier readability but I imagine that the logic and the performance should be the same.
Having said...
cmmfrds-in hind site, I have just re-read your response, I am not just making a comparison on two fields, I am comparing about 45 out of the 67 fields and I want to be able to do that, regardless of whether the field is null or not.So, I am trying to see if I can build an IIF statement into the...
UPDATE [tbl Products Total TBL by STATE], [tbl Updatable OUTGOING_MIGRATION] SET [tbl Products Total TBL by STATE].[New/ren_Rx_Cd] = "*", [tbl Updatable OUTGOING_MIGRATION].[New/ren_Rx_Cd] = "*"
WHERE ((([tbl Products Total TBL by STATE].[New/ren_Rx_Cd]) Is Null) AND (([tbl...
By the time I read this last portion of this thread, I had created queries that do fill the null records with an asterisk. However because of the 67 fields in my table this was time consuming and I am sure there is a faster way. Once I have time, unfortunately because I am building this query to...
ACTION: IIf([00 Journal Entries]![Debit]=0,0,Switch([Accounts]![AccountTypeID]="EXPENSES","WITHDRAWAL",[Accounts]![AccountTypeID]="REVENUE","DEPOSIT",True,"NO MATCH"))
I have tried using the above expression to try and solve my problem. I have...
I have which has the following table:
ACCT TYPE DEBIT CREDIT
EXPENSE WITHDRAWAL DEPOSIT
CURRENT ASSET DEPOSIT WITHDRAWAL
CURRENT LIABILITY WITHDRAWAL DEPOSIT
FIXED ASSET WITHDRWAL DEPOSIT
LONG TERM LIABILITY WITHDRAWAL...
I am working on a comparison of 2 tables. for either one of the following situations: 1 to see what records match up and what records do not match up. In my tables it is legitimate to have null values in some of the fields. I am just not having any luck in being able to compare those records...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.