Search results for query: *

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...

Thank you for your quick response. I was hoping there was an alternative to updating the table with values and then making a comparison of that.

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...