if



please help with following question

two tables A and B

A has 2 fields: A.id, A.content
B has 3 fields: B.id, B.content, B.if

B.content is a calculation field that tests whether B.if- = "yes". If
it does, it fills B.content with A.content where B.id = A.id

I can't work out what functions to use in the calculation field setup.

Where B.if ="no", I want to be able to input data into B.content
manually, as it were.

marmot

.



Relevant Pages

  • Question
    ... this yellow table is the source data: ... the green numbers are my input data and blue one are output data: ... A-Design ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Re: M.M.M or a mac mini mystery ....
    ... marmot wrote: ... > plus the screen goes dark randomly in the case of the CRT ... Peter ... Prev by Date: ...
    (uk.comp.sys.mac)
  • Input to populate report worksheet
    ... I am trying to figure the best way to allow a user to input data into ... Excel and then have the data inserted as rows into a worksheet. ... victorcab's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=13675 ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Large customizable input form using WordML
    ... Can I present a WordML form as Webpage ... properly and users should be able to input data. ... Jobi K Joy ... Prev by Date: ...
    (microsoft.public.dotnet.xml)
  • Re: Indispensable safety gadgets to save your life on the hill...
    ... >>Has anyone seen this amazing jacket from Marmot? ... Colin ... Prev by Date: ...
    (uk.rec.walking)