Date function

  • Thread starter Thread starter Aurora
  • Start date Start date
A

Aurora

I am using Access 2000

In a query, I have the following formula
DateSSigned: IIf([IASupv-Sign] Is Null," ",Date())

to insert the current date when a signature is put in to
the IASupv-Sign field. But this date is changing each
time we bring up the record, I believe because " Date()"
brings up the current (today's) date. What should I be
using to bring up the current date when the appropriate
field is signed but keep that date in the field without
changing?

Please help!
Aurora
..
 
I must not of understood what you were telling me because
I changed the formula to what you said --
DateSSigned: IIf([IASupv-Sign] Is Null," ",IIf
([DateSSigned] Is Null,Date(),[DateSSigned]))

[DateSSigned] = automatic date when the supervisor
signs [IASupv-Sign]

But I get the following message: "Circular reference
caused by alias [DateSSigned] in query definition's SELECT
List.

I am not sure what this means - Aurora
-----Original Message-----
see reply in other newsgroup where you posted this same question.

--

Ken Snell
<MS ACCESS MVP>

I am using Access 2000

In a query, I have the following formula
DateSSigned: IIf([IASupv-Sign] Is Null," ",Date ())

to insert the current date when a signature is put in to
the IASupv-Sign field. But this date is changing each
time we bring up the record, I believe because " Date()"
brings up the current (today's) date. What should I be
using to bring up the current date when the appropriate
field is signed but keep that date in the field without
changing?

Please help!
Aurora
.
Click to expand...


.
Click to expand...
 
It means that you're naming the calculated field the same name as the field
in the table -- DateSSigned. If you want to use the same "name", then modify
the table field name by adding the tablename to the reference:

DateSSigned: IIf([IASupv-Sign] Is Null," ",IIf
([DateSSigned] Is Null,Date(),[TableName].[DateSSigned]))

But it'll be better if you change the name of the calculated field:

XDateSSigned: IIf([IASupv-Sign] Is Null," ",IIf
([DateSSigned] Is Null,Date(),[DateSSigned]))


--

Ken Snell
<MS ACCESS MVP>

Aurora said:
I must not of understood what you were telling me because
I changed the formula to what you said --
DateSSigned: IIf([IASupv-Sign] Is Null," ",IIf
([DateSSigned] Is Null,Date(),[DateSSigned]))

[DateSSigned] = automatic date when the supervisor
signs [IASupv-Sign]

But I get the following message: "Circular reference
caused by alias [DateSSigned] in query definition's SELECT
List.

I am not sure what this means - Aurora
-----Original Message-----
see reply in other newsgroup where you posted this same question.

--

Ken Snell
<MS ACCESS MVP>

I am using Access 2000

In a query, I have the following formula
DateSSigned: IIf([IASupv-Sign] Is Null," ",Date ())

to insert the current date when a signature is put in to
the IASupv-Sign field. But this date is changing each
time we bring up the record, I believe because " Date()"
brings up the current (today's) date. What should I be
using to bring up the current date when the appropriate
field is signed but keep that date in the field without
changing?

Please help!
Aurora
.
Click to expand...


.
Click to expand...
Click to expand...
 
I think I understand what you are saying, but I am still
confused.
[IASupv-Sign] is the field that the supervisor signs when
he has completed the information required.
I also have an [IASupv-Date] field that I originally
created for the date the supervisor signed the [IASupv-
Sign] but have not used it because I thought I had to use
the formula field [DateSSigned] in the form.

Can you tell me where I am confused at?

ps - I really appreciate your help with this problem.

Aurora


-----Original Message-----
It means that you're naming the calculated field the same name as the field
in the table -- DateSSigned. If you want to use the same "name", then modify
the table field name by adding the tablename to the reference:

DateSSigned: IIf([IASupv-Sign] Is Null," ",IIf
([DateSSigned] Is Null,Date(),[TableName].[DateSSigned]))

But it'll be better if you change the name of the calculated field:

XDateSSigned: IIf([IASupv-Sign] Is Null," ",IIf
([DateSSigned] Is Null,Date(),[DateSSigned]))


--

Ken Snell
<MS ACCESS MVP>

I must not of understood what you were telling me because
I changed the formula to what you said --
DateSSigned: IIf([IASupv-Sign] Is Null," ",IIf
([DateSSigned] Is Null,Date(),[DateSSigned]))

[DateSSigned] = automatic date when the supervisor
signs [IASupv-Sign]

But I get the following message: "Circular reference
caused by alias [DateSSigned] in query definition's SELECT
List.

I am not sure what this means - Aurora
-----Original Message-----
see reply in other newsgroup where you posted this same question.

--

Ken Snell
<MS ACCESS MVP>

I am using Access 2000

In a query, I have the following formula
DateSSigned: IIf([IASupv-Sign] Is
Click to expand...
Null," ",Date
())
to insert the current date when a signature is put in to
the IASupv-Sign field. But this date is changing each
time we bring up the record, I believe because " Date ()"
brings up the current (today's) date. What should I be
using to bring up the current date when the appropriate
field is signed but keep that date in the field without
changing?

Please help!
Aurora
.




.
Click to expand...
Click to expand...


.
Click to expand...
 
Add me to the confused list.

Let's start at the beginning. Is this query being used as the Record Source
for a form? If no, what is the query's purpose? If yes, what is being done
on the form? How does the IASupv-Sign field get its value? How does the
IASupv-Date field get its value? How are you using the IASupv-Date field?

I don't have a firm picture of your setup in my mind yet....

--

Ken Snell
<MS ACCESS MVP>


Aurora - Again said:
I think I understand what you are saying, but I am still
confused.
[IASupv-Sign] is the field that the supervisor signs when
he has completed the information required.
I also have an [IASupv-Date] field that I originally
created for the date the supervisor signed the [IASupv-
Sign] but have not used it because I thought I had to use
the formula field [DateSSigned] in the form.

Can you tell me where I am confused at?

ps - I really appreciate your help with this problem.

Aurora


-----Original Message-----
It means that you're naming the calculated field the same name as the field
in the table -- DateSSigned. If you want to use the same "name", then modify
the table field name by adding the tablename to the reference:

DateSSigned: IIf([IASupv-Sign] Is Null," ",IIf
([DateSSigned] Is Null,Date(),[TableName].[DateSSigned]))

But it'll be better if you change the name of the calculated field:

XDateSSigned: IIf([IASupv-Sign] Is Null," ",IIf
([DateSSigned] Is Null,Date(),[DateSSigned]))


--

Ken Snell
<MS ACCESS MVP>

I must not of understood what you were telling me because
I changed the formula to what you said --
DateSSigned: IIf([IASupv-Sign] Is Null," ",IIf
([DateSSigned] Is Null,Date(),[DateSSigned]))

[DateSSigned] = automatic date when the supervisor
signs [IASupv-Sign]

But I get the following message: "Circular reference
caused by alias [DateSSigned] in query definition's SELECT
List.

I am not sure what this means - Aurora

-----Original Message-----
see reply in other newsgroup where you posted this same
question.

--

Ken Snell
<MS ACCESS MVP>

message
I am using Access 2000

In a query, I have the following formula
DateSSigned: IIf([IASupv-Sign] Is Null," ",Date
())

to insert the current date when a signature is put in to
the IASupv-Sign field. But this date is changing each
time we bring up the record, I believe because " Date ()"
brings up the current (today's) date. What should I be
using to bring up the current date when the appropriate
field is signed but keep that date in the field without
changing?

Please help!
Aurora
.




.
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top