Data not carrying over from Form to Table

[Guest]

I have 2 expressions that I am using on a form to find certain data. How do
I get the table to show that data.

Here are the expressions:
=IIf(IsNull([Complete Date]),Date()-[Order Date],[Complete Date]-[Order Date])
&
=[Orig Appraised Value]-[Reviewed Value]

The problem that I am having is writing queries to show the data produced by
expressions.

Queries:
Find all files that are older than 10 days

Find all files that are less than "0"

Also on the first expression is there a way to get it to count only Mon - Fri?

The whom ever answers Thank You a great deal!

 

[Arvin Meyer [MVP]]

Hi Casey,

Generally, (and specifically in the case you've shown) you do not need to
store the results of calculations. Since you have all of the elements of
those calculations, you can re-calculate at any time. Even an old 486 could
do thousands of calculations a second.

For the queries you are showing, in the first one enter in the criteria box
of the date field:

< Date() - 10

The second query:

< 0

Question 3 on queries, yes but you need to write a custom function (which
I've already done):

http://www.mvps.org/access/datetime/date0006.htm

 

[Guest]

Do you have a regular email that I can send you a screen shot of the query.
I believe I am doing something wrong.

Hi Casey,

Generally, (and specifically in the case you've shown) you do not need to
store the results of calculations. Since you have all of the elements of
those calculations, you can re-calculate at any time. Even an old 486 could
do thousands of calculations a second.

For the queries you are showing, in the first one enter in the criteria box
of the date field:

< Date() - 10

The second query:

< 0

Question 3 on queries, yes but you need to write a custom function (which
I've already done):

http://www.mvps.org/access/datetime/date0006.htm
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

I have 2 expressions that I am using on a form to find certain data. How
do
I get the table to show that data.

Here are the expressions:
=IIf(IsNull([Complete Date]),Date()-[Order Date],[Complete Date]-[Order
Date])
&
=[Orig Appraised Value]-[Reviewed Value]

The problem that I am having is writing queries to show the data produced
by
expressions.

Queries:
Find all files that are older than 10 days

Find all files that are less than "0"

Also on the first expression is there a way to get it to count only Mon -
Fri?

The whom ever answers Thank You a great deal!

 

[Arvin Meyer [MVP]]

I do. Go to either of the 2 websites below. At datastrat, there is no link,
but the email address is on the home page to copy. Ate the Access Web, click
on contact me and it will take to to a working email. Send an email telling
me that the one immediately following it has an attachment with that
attachment's name and size. I only accept zipped attachments.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access

Do you have a regular email that I can send you a screen shot of the
query.
I believe I am doing something wrong.

Hi Casey,

Generally, (and specifically in the case you've shown) you do not need to
store the results of calculations. Since you have all of the elements of
those calculations, you can re-calculate at any time. Even an old 486
could
do thousands of calculations a second.

For the queries you are showing, in the first one enter in the criteria
box
of the date field:

< Date() - 10

The second query:

< 0

Question 3 on queries, yes but you need to write a custom function (which
I've already done):

http://www.mvps.org/access/datetime/date0006.htm
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

I have 2 expressions that I am using on a form to find certain data.
How
do
I get the table to show that data.

Here are the expressions:
=IIf(IsNull([Complete Date]),Date()-[Order Date],[Complete Date]-[Order
Date])
&
=[Orig Appraised Value]-[Reviewed Value]

The problem that I am having is writing queries to show the data
produced
by
expressions.

Queries:
Find all files that are older than 10 days

Find all files that are less than "0"

Also on the first expression is there a way to get it to count only
Mon -
Fri?

The whom ever answers Thank You a great deal!