By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,654 Members | 1,419 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,654 IT Pros & Developers. It's quick & easy.

Table Value Setting..conditiontal

P: n/a
Hi:

I would like to be able to define a table value as equal to another value in the table, IF
the entry is on a friday. I know all the logic to do this, but somehow in the table
definition it wont let me refer to the table itself for a value.

Field A is the original field
B is the one I am setting

I want to set it so that if today is friday then Field B = Field A, if not it is blank.
Field A is an auto incremented record number.

Anyone able to help with this,. I know i could do a query after, but would rather do it
all at initial entry.

best

Jon Baker
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"John Baker" <Ba******@Verizon.net> wrote in message
news:bs********************************@4ax.com...
Hi:

I would like to be able to define a table value as equal to another value in the table, IF the entry is on a friday. I know all the logic to do this, but somehow in the table definition it wont let me refer to the table itself for a value.

Field A is the original field
B is the one I am setting

I want to set it so that if today is friday then Field B = Field A, if not it is blank. Field A is an auto incremented record number.

Anyone able to help with this,. I know i could do a query after, but would rather do it all at initial entry.


Derived values such as this belong in queries, forms, and reports. Not in
tables.

Create a query that calculates this as a new field and use the query in all
places you currently use the table. Drop the field from your table.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.