Search results

  1. I

    wildcard decimals

    both work! thanks for the quick response.
  2. 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
  3. I

    Converting Julian Date

    Thanks, but I was lost.
  4. I

    Converting Julian Date

    I found this NormalDate: CDate(Format(((DateValue("01/01/"+LTrim(Str(1900+Int([Your Field Name]/1000))))+[Your Field Name]-Int([Your Field Name]/1000)*1000))-1,"mm-dd-yy")) Can someone help me add in and iff statement before this for null value? I tried the formula below but kept getting...
  5. 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,
  6. I

    IIF statement

    So in other words, this statement is saying anything in [preferred cost] that is not a null value but is greater than cost1, then the true value would be (((pp 6 month unit sales*cost1)-[preferred cost])*2). but if false then "0". But if [pp6month unit sales] is null, then overall, the...
  7. 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...
  8. I

    Rename data

    Sorry I wasn't specific: I have a table name Account and in that table is a field called Acct #, Amt, Invoice #. For Acct # - I have text 123 For Amt - I have $12 For Invoice # - I have DS123 I want to bring Acct# (123) and Invoice #(DS) together to make a new field call Specials. I use...
  9. I

    Rename data

    Example: Column A AB --> for this data field, want to rename AB to AB Revised BC --> BC Revised
  10. 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.
  11. 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
  12. I

    auto a copy of a table

    Thank you!
  13. I

    auto a copy of a table

    Would this delete all the old data?
  14. 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
  15. I

    adding a new column to existing table

    thank you!
  16. 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.
  17. 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,
  18. I

    DateDiff - for workdays?

    Is this like creating a calendar then rewrite queries to do calculations? Further explanations please. Maybe an example would be great in how the final report would look like. Thanks
  19. I

    last entry compare of record

    How would I rewrite this to make it run faster? Should I do a query first for CarNum, DorDate and SpeedoEnd then join to the Original VehicleMiles table?
  20. I

    last entry compare of record

    This is actually what I want to do. Thank you! But can I but a month set criteria under DorDate for all of May? Would that affect the PrevEnd date being restricted in May only or can it select the previous date even in April?
Back
Top Bottom