Search results

  1. Z

    Iif Statement reading as text not expression - PLEASE HELP!

    I'm having an issue that I feel should be a simple fix but I simply can not figure it out. I have an iif statement: IIf([forms]![Main]![District] Is Null,IIf([forms]![Main]![DistrictList]="View all Districts",>0,[forms]![Main]![DistrictList]),[forms]![Main]![District]) The problem is the...
  2. Z

    Like "*" in a iif statement

    I have a drop down menu in a form and for the default value I have it set to "View all Districts" so the use can simply view all districts instead of choosing one from the dropdown. I am using an iif statement and trying to use the Like "*" function if the drop down is equal to "View all...
  3. Z

    Iff Statement stored in table

    I am developing a access program that has a large amount of queries in it. Most of the queries will use an iff statement in them. The iff statement will be the same across most queries but it will also change every few weeks. Is it possible to save the iff statement in a table and just call...
  4. Z

    Iif statement where false has no condition

    I have drop down menus on a form that I use in an iif statement in a query to narrow the results according to what is selected. However they will have the option to leave the drop down blank and I want it to return all possbible results. How do I write an iif statement to return all items if...
  5. Z

    Convert text string to date

    I have a field that looks like this YCS1292. It is saved as a text field. The right 4 number are the month and the year the account was created. In this example it would be 12/1992. I need to convert this to a date so I can do a between function in the query. Can anyone help? Thanks!
  6. Z

    Show Current Filename in Report

    I would like all of my reports to list the current filename. Can someone please help me out with how to do this?
  7. Z

    Very odd behavior in a form

    I am having a very odd thing happen in one of my forms. I have added 8 if statements that simply display a line of text if a statement is or is not null. The if statement looks like this: IIf([AttributesPrivateNote] Is Not Null,"Private Notes Available","") Each field is looking at...
  8. Z

    Open external file using a macro

    Ok. Here is what I'm trying to go. I have a field in a database that is the name of a file. In a query I formated it to a new field that included the address of where that file is on the network. The new query looks something like this: \\web01\website\images\test.jpg Since I created the...
Back
Top Bottom