Search results

  1. I

    trim

    Hi, how do I trim a date to this format mm/dd/yyyy. My current date is in this format mm/dd/yyyy hh:mm:ss. Thanks!
  2. I

    wild card

    I want to wild card anything that's in a parenthesis that doesn't fall in this format of ( number / alpha). Can anyone help? Thanks!
  3. I

    trim

    hi i would like to trim for just the day in a date, please help write this. if 5/25/2010 - i want the "25" part only. Thanks,
  4. I

    iif statement

    I'm trying 5 iif statements in one and it's giving me lots of error. My statement is iif([date received] is not null, iif([compliance]=20, iif([days]>=10, "Met",iif([compliance]=10, iif([days]>=5,"Met","Not Met"),"Not Met"),"Not Met"),"Not Met")) Please help me correct this so it works.
  5. I

    pulling character count

    How can I pull only fields where there are 14 charaters or more? Thanks!
  6. I

    Macro

    Hi, I have a spreadsheet that has multiple chunks of column headings within the same spreadsheet. In one of the column there are data that are divided by a "|". I would like to find all the data divided by "|" in those column and bring that data down to another column and copy all the remaining...
  7. I

    Looping data

    I'm not sure if this is a VBA issue or a query issue, but I would appreciate any advice anyone can offer. I have a spreadsheet that has multiple chunks of column headings within the same spreadsheet. In one of the column there are data that are divided by a "|". I would like to find all the...
  8. I

    Error

    I'm trying to link a table in and it give me this error: "Invalid field definition 'IW_Date" in definition of index or relationship." A person next to me was able to link the table without errors. Any idea what might cause this and how to fix it? Thanks!
  9. I

    Overflow

    I ran the queries in my database and it's giving me an error of "overflow". There's only about 1500 records. Does anyone know what this means? Thanks.
  10. I

    adding - in phone numbers

    What's the easiest way to add in the dashes in the phone numbers? I have 7574565899 and want 757-456-5899. Thanks,
  11. I

    Translating functions

    Hi I inherited this long expression and I'm having trouble understanding the functions used. Can someone help me translate as to what it is doing? Future Sell Price Est: IIf([Price Code Formula] In ("Cost","PR1","PR2","PR3","2xCost","Cost Plus","2X Cost Plus"),Switch([Price Code...
  12. I

    wildcard decimals

    I have a list of numbers both whole and decimal numbers. I want to do a search for all decimal numbers. What should I use? Example: 123 123.23 I want to find anything with "#.#" - like 123.23 in the above example. Thanks
  13. I

    Converting Julian Date

    Hi I have this formula in Excel to convert to Julian but I what I need is a way to convert in Access. Do you know how to convert? Excel formula: =("1/1/"&MID(A1,2,2))+MID(A1,4,3)-1 Thanks,
  14. I

    IIF statement

    I have 2 questions, but I think they are similiar in definitions. They are the the iif statements below. I don't understand what this is doing. Can someone translate for me, please? IIf([PP 6 Month Unit Sales] Is Not Null,IIf([preferred cost] Is Not Null And [preferred...
  15. I

    Rename data

    How can I manipulate the data within a column? I just want to rename it to something else. Any help would be greatful.
  16. I

    #Delete

    I'm pulling in a new table from OCDB but what I see in all the columns are "#Delete". Any idea what might have caused this? Thanks
  17. I

    auto a copy of a table

    how do you write a query or a macro that automatically copy an oracle table and rename it each week to do a comparison? thanks
  18. I

    adding a new column to existing table

    i want to write a query so that it adds a new column to an existing table. i tried appending to the table but it wouldn't let me.
  19. I

    making new tables

    i heard that you can create a query that makes a new table and also a macro that makes a copy of the link table. does anyone who how to do this? thanks,
  20. I

    last entry compare of record

    I have a set of data I want to compare possible changes but am having a hard time writing the query criteria to do what I want. I tried writing a query of all max date then create another query with all data but removed all the max dates in the 1st query. Then max the remaing entry. But it's...
Back
Top Bottom