Search results

  1. G

    IIf Statement Multi select

    You the man. That worked perfect. Thank you
  2. G

    IIf Statement Multi select

    I have multiple codes assigned to records in a table. I want to be able to say IIf [code] = "FMIX",[qty]*2.2046/7.1, IIf [code] = "Liqd", [qty]*2.2046 and everything else can just equal [qty]. I have tried this statment Expr1: IIf([family-code]="FMIX",[SumOfqty-on-hand]*2.2046...
  3. G

    Import a text file

    I need to import/append multiple files from 1 folder into 1 table in Access. All the files have the same last word.ex.051703-Reconcile. Can anyone help? G
  4. G

    Updatable Active X Calander

    Is there a calander that I can put on my form that will update to current date when I open form Gary
  5. G

    Seperate multiple data in 1 feild

    Seperate data I can't change the table, because it is a linked Progress table. I thought there might be a function I could use in a query to take the one field and make it ex. (50;100;200;300;500) and make 5 feilds like (brk1)50,(brk2)100 and so on. Is there any advanced formula for the "Left"...
  6. G

    Seperate multiple data in 1 feild

    I have a table that has price breaks seperated by semi-colons in 1 field. (ex.) 100;200;1000 I need to seperate them in a query to create a price list. Can anyone HELP? gary
Back
Top Bottom