Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. GueGueBla

    Using Criteria to display values in report

    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?
  2. GueGueBla

    simple: add record source to report

    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!
  3. GueGueBla

    simple: add record source to report

    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?
  4. GueGueBla

    simple: add record source to report

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

    table comparison inclusive of null data

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

    table comparison inclusive of null data

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

    table comparison inclusive of null data

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

    table comparison inclusive of null data

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

    table comparison inclusive of null data

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

    table comparison inclusive of null data

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

    table comparison inclusive of null data

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

    DATA COMPARE TO UPDATE

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

    DATA COMPARE TO UPDATE

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

    table comparison inclusive of null data

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

    table comparison inclusive of null data

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

Part and Inventory Search

Back
Top