Recent content by cmc2005

  1. C

    Record source problem on form

    Hello, I'm having a strange problem and was wondering if anyone can help me out. I have a form that is for inputting and modifying data in one table. It used to work when you opened the form you would see x amount of records. Now it's opening to 1 blank record. If you hit filter it fliters like...
  2. C

    Need to make a change in a linked table

    This question will surely show my amateur Access skills... I have to add a field to a linked table. However, the table doesn't save my changes. Is there something I need to do before I make my change? I get the error message "Table 'name' is a linked table with some properties that can't be...
  3. C

    Help with an expression

    thanks izy, this worked!! :D
  4. C

    Help with an expression

    I left that last " in there by accident. It's really: =IIf([SeriesTitle]=[Mediscope],([Euro]/1.4),[Euro]/1.2)
  5. C

    Help with an expression

    FoFa, I had it in there without the SUM but it wasn't working. So I looked up some expressions and thought I needed it there. The second one is supposed to perform a calculation, so I'll take the quotes off. So if I do: =IIf([SeriesTitle]=[Mediscope],([Euro]/1.4),[Euro]/1.2") This should...
  6. C

    Help with an expression

    Hi, I'm trying to write an expression that performs one "/" expression based on a certain exception, and if else peforms something else. I can't get it to work. I'm sure something is wrong here -- does anyone know? =IIf([SeriesTitle]=[Mediscope],Sum([Euro]/1.4),"[Euro]/1.2") So basically if...
See more
Back
Top Bottom