date calculation

[Business analyst williams]

1. how do I code to prompt just to enter one date?
2. Once this date is entered how do I code it to subract 20 days from that
date entered.
3.Next, I have another date field that I do not want data pulled greater
than 45 days out.

I want to work like this:
Employee enters date..and the querie will pull on field all data greater
than 20 days, but another field no <= 45 days

 

[Jerry Whittle]

You need a parameter in the query. This parameter must be defined. The SQL
statement would look something like this with the correct table and field
names.

PARAMETERS [Enter Date] DateTime;
SELECT tblDates.*
FROM tblDates
WHERE tblDates.[wa_date]>[Enter Date]-20
AND tblDates.[ex_date]<=[Enter Date]-45;

 

[Business analyst williams]

what is the wa_date and ex_date. I am assuming tblDates are the fields where
the calculations are coming from.

You need a parameter in the query. This parameter must be defined. The SQL
statement would look something like this with the correct table and field
names.

PARAMETERS [Enter Date] DateTime;
SELECT tblDates.*
FROM tblDates
WHERE tblDates.[wa_date]>[Enter Date]-20
AND tblDates.[ex_date]<=[Enter Date]-45;
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

1. how do I code to prompt just to enter one date?
2. Once this date is entered how do I code it to subract 20 days from that
date entered.
3.Next, I have another date field that I do not want data pulled greater
than 45 days out.

I want to work like this:
Employee enters date..and the querie will pull on field all data greater
than 20 days, but another field no <= 45 days

 

[KARL DEWEY]

I do believe they are Wanted_Date and Excluded_Date fields.

--
Build a little, test a little.

what is the wa_date and ex_date. I am assuming tblDates are the fields where
the calculations are coming from.

You need a parameter in the query. This parameter must be defined. The SQL
statement would look something like this with the correct table and field
names.

PARAMETERS [Enter Date] DateTime;
SELECT tblDates.*
FROM tblDates
WHERE tblDates.[wa_date]>[Enter Date]-20
AND tblDates.[ex_date]<=[Enter Date]-45;
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

1. how do I code to prompt just to enter one date?
2. Once this date is entered how do I code it to subract 20 days from that
date entered.
3.Next, I have another date field that I do not want data pulled greater
than 45 days out.

I want to work like this:
Employee enters date..and the querie will pull on field all data greater
than 20 days, but another field no <= 45 days

 

[John W. Vinson]

what is the wa_date and ex_date. I am assuming tblDates are the fields where
the calculations are coming from.

Since you chose to post a question without mentioning either your table names
or your fieldnames, Jerry had to make some reasonable guess at what those
might be. Remember, neither he nor any of us can see your database!

 

[Jerry Whittle]

tblDates is the table that I used for my testing. wa_date and ex_date are
fields in my table.

You will need to replace the table name and field names with those in your
database.

After doing so, open up a new query, but don't select a table. Next go to
SQL view the paste the revised SQL statement into that SQL view window. Run
it and see if ti works.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

what is the wa_date and ex_date. I am assuming tblDates are the fields where
the calculations are coming from.

You need a parameter in the query. This parameter must be defined. The SQL
statement would look something like this with the correct table and field
names.

PARAMETERS [Enter Date] DateTime;
SELECT tblDates.*
FROM tblDates
WHERE tblDates.[wa_date]>[Enter Date]-20
AND tblDates.[ex_date]<=[Enter Date]-45;
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

1. how do I code to prompt just to enter one date?
2. Once this date is entered how do I code it to subract 20 days from that
date entered.
3.Next, I have another date field that I do not want data pulled greater
than 45 days out.

I want to work like this:
Employee enters date..and the querie will pull on field all data greater
than 20 days, but another field no <= 45 days