Manipulate Date Ranges In a Query

  • Thread starter Thread starter WStoreyII
  • Start date Start date
W

WStoreyII

Hello,

I sell mattress's and am attempting to make a database of
all of my sales. Now the problem is this I only get paid
on sales that are finalized in the fiscal period for that
given month. So what i am attempting to do is set up a
query that will produce all order that were finalized
(which is one field) during set dates like sept 29th -
november 1st.

any help would be appreaciated
 
You have not provided details of your tables.
Lets assume, your table tblOrders inlcudes the following
fields:
OrderID
OrderAmount
FinalisedDate
OrderDescriotion
etc;

SELECT OrderID,OrderDescription,OrderAmount,FinalisedDate
FROM tblOrders
WHERE FinalisedDate BETWEEN [Enter Start Date] AND [Enter
end Date]

Jacinto
 
Sorry about not providing enough info
ok i have to fields one is status (whether the sale is
finalized open or void) and another field that is the
date of status i want to make a query that will find all
records that are finalized and between a certain date
range like for instance sept 29th - nov 2nd cuz that is
the fiscal month that i will be getting paid on

thank you for your help and your patience

william storey ii


-----Original Message-----
You have not provided details of your tables.
Lets assume, your table tblOrders inlcudes the following
fields:
OrderID
OrderAmount
FinalisedDate
OrderDescriotion
etc;

SELECT OrderID,OrderDescription,OrderAmount,FinalisedDate
FROM tblOrders
WHERE FinalisedDate BETWEEN [Enter Start Date] AND [Enter
end Date]

Jacinto
-----Original Message-----
Hello,

I sell mattress's and am attempting to make a database of
all of my sales. Now the problem is this I only get paid
on sales that are finalized in the fiscal period for that
given month. So what i am attempting to do is set up a
query that will produce all order that were finalized
(which is one field) during set dates like sept 29th -
november 1st.

any help would be appreaciated
.
Click to expand...
.
Click to expand...
 
Use a criterion in the query similar to this:

WHERE [SaleFinal] <> False AND [SalesStatusDate] Between #9/29/2003# And
#11/2/2003#

(the above assumes that [SaleFinal] is a boolean field, and that
[SalesStatusDate] is a date/time field).
--
Ken Snell
<MS ACCESS MVP>

Sorry about not providing enough info
ok i have to fields one is status (whether the sale is
finalized open or void) and another field that is the
date of status i want to make a query that will find all
records that are finalized and between a certain date
range like for instance sept 29th - nov 2nd cuz that is
the fiscal month that i will be getting paid on

thank you for your help and your patience

william storey ii


-----Original Message-----
You have not provided details of your tables.
Lets assume, your table tblOrders inlcudes the following
fields:
OrderID
OrderAmount
FinalisedDate
OrderDescriotion
etc;

SELECT OrderID,OrderDescription,OrderAmount,FinalisedDate
FROM tblOrders
WHERE FinalisedDate BETWEEN [Enter Start Date] AND [Enter
end Date]

Jacinto
-----Original Message-----
Hello,

I sell mattress's and am attempting to make a database of
all of my sales. Now the problem is this I only get paid
on sales that are finalized in the fiscal period for that
given month. So what i am attempting to do is set up a
query that will produce all order that were finalized
(which is one field) during set dates like sept 29th -
november 1st.

any help would be appreaciated
.
Click to expand...
.
Click to expand...
Click to expand...
 
error: data type mismatch in criteria expression
-----Original Message-----
Use a criterion in the query similar to this:

WHERE [SaleFinal] <> False AND [SalesStatusDate] Between #9/29/2003# And
#11/2/2003#

(the above assumes that [SaleFinal] is a boolean field, and that
[SalesStatusDate] is a date/time field).
--
Ken Snell
<MS ACCESS MVP>

Sorry about not providing enough info
ok i have to fields one is status (whether the sale is
finalized open or void) and another field that is the
date of status i want to make a query that will find all
records that are finalized and between a certain date
range like for instance sept 29th - nov 2nd cuz that is
the fiscal month that i will be getting paid on

thank you for your help and your patience

william storey ii


-----Original Message-----
You have not provided details of your tables.
Lets assume, your table tblOrders inlcudes the following
fields:
OrderID
OrderAmount
FinalisedDate
OrderDescriotion
etc;

SELECT OrderID,OrderDescription,OrderAmount,FinalisedDate
FROM tblOrders
WHERE FinalisedDate BETWEEN [Enter Start Date] AND [Enter
end Date]

Jacinto
-----Original Message-----
Hello,

I sell mattress's and am attempting to make a
Click to expand...
database
of
all of my sales. Now the problem is this I only get paid
on sales that are finalized in the fiscal period for that
given month. So what i am attempting to do is set up a
query that will produce all order that were finalized
(which is one field) during set dates like sept 29th -
november 1st.

any help would be appreaciated
.

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


.
Click to expand...
 
by boolean i assume that you mean a yes or no rigth? cuz
i dont see an option for boolean
-----Original Message-----
Use a criterion in the query similar to this:

WHERE [SaleFinal] <> False AND [SalesStatusDate] Between #9/29/2003# And
#11/2/2003#

(the above assumes that [SaleFinal] is a boolean field, and that
[SalesStatusDate] is a date/time field).
--
Ken Snell
<MS ACCESS MVP>

Sorry about not providing enough info
ok i have to fields one is status (whether the sale is
finalized open or void) and another field that is the
date of status i want to make a query that will find all
records that are finalized and between a certain date
range like for instance sept 29th - nov 2nd cuz that is
the fiscal month that i will be getting paid on

thank you for your help and your patience

william storey ii


-----Original Message-----
You have not provided details of your tables.
Lets assume, your table tblOrders inlcudes the following
fields:
OrderID
OrderAmount
FinalisedDate
OrderDescriotion
etc;

SELECT OrderID,OrderDescription,OrderAmount,FinalisedDate
FROM tblOrders
WHERE FinalisedDate BETWEEN [Enter Start Date] AND [Enter
end Date]

Jacinto
-----Original Message-----
Hello,

I sell mattress's and am attempting to make a
Click to expand...
database
of
all of my sales. Now the problem is this I only get paid
on sales that are finalized in the fiscal period for that
given month. So what i am attempting to do is set up a
query that will produce all order that were finalized
(which is one field) during set dates like sept 29th -
november 1st.

any help would be appreaciated
.

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


.
Click to expand...
 
ok i figured that out now one more thing i on this query
i am including the commission made field how do i get a
sum of that showed at the bottom to see what i made
-----Original Message-----
Use a criterion in the query similar to this:

WHERE [SaleFinal] <> False AND [SalesStatusDate] Between #9/29/2003# And
#11/2/2003#

(the above assumes that [SaleFinal] is a boolean field, and that
[SalesStatusDate] is a date/time field).
--
Ken Snell
<MS ACCESS MVP>

Sorry about not providing enough info
ok i have to fields one is status (whether the sale is
finalized open or void) and another field that is the
date of status i want to make a query that will find all
records that are finalized and between a certain date
range like for instance sept 29th - nov 2nd cuz that is
the fiscal month that i will be getting paid on

thank you for your help and your patience

william storey ii


-----Original Message-----
You have not provided details of your tables.
Lets assume, your table tblOrders inlcudes the following
fields:
OrderID
OrderAmount
FinalisedDate
OrderDescriotion
etc;

SELECT OrderID,OrderDescription,OrderAmount,FinalisedDate
FROM tblOrders
WHERE FinalisedDate BETWEEN [Enter Start Date] AND [Enter
end Date]

Jacinto
-----Original Message-----
Hello,

I sell mattress's and am attempting to make a
Click to expand...
database
of
all of my sales. Now the problem is this I only get paid
on sales that are finalized in the fiscal period for that
given month. So what i am attempting to do is set up a
query that will produce all order that were finalized
(which is one field) during set dates like sept 29th -
november 1st.

any help would be appreaciated
.

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


.
Click to expand...
 
You can't do this easily in a single query. Normally, you would use a report
or form to show the results of the query. On the report or form, put a
textbox in the footer section, and set its control source to this
expression:

=DSum("CommissionFieldName", "tblOrders", "[SaleFinal] <> False AND
[SalesStatusDate] Between
#9/29/2003# And #11/2/2003#")
--
Ken Snell
<MS ACCESS MVP>



WStoreyII said:
ok i figured that out now one more thing i on this query
i am including the commission made field how do i get a
sum of that showed at the bottom to see what i made
-----Original Message-----
Use a criterion in the query similar to this:

WHERE [SaleFinal] <> False AND [SalesStatusDate] Between #9/29/2003# And
#11/2/2003#

(the above assumes that [SaleFinal] is a boolean field, and that
[SalesStatusDate] is a date/time field).
--
Ken Snell
<MS ACCESS MVP>

Sorry about not providing enough info
ok i have to fields one is status (whether the sale is
finalized open or void) and another field that is the
date of status i want to make a query that will find all
records that are finalized and between a certain date
range like for instance sept 29th - nov 2nd cuz that is
the fiscal month that i will be getting paid on

thank you for your help and your patience

william storey ii



-----Original Message-----
You have not provided details of your tables.
Lets assume, your table tblOrders inlcudes the following
fields:
OrderID
OrderAmount
FinalisedDate
OrderDescriotion
etc;

SELECT OrderID,OrderDescription,OrderAmount,FinalisedDate
FROM tblOrders
WHERE FinalisedDate BETWEEN [Enter Start Date] AND
[Enter
end Date]

Jacinto
-----Original Message-----
Hello,

I sell mattress's and am attempting to make a database
of
all of my sales. Now the problem is this I only get
paid
on sales that are finalized in the fiscal period for
that
given month. So what i am attempting to do is set up a
query that will produce all order that were finalized
(which is one field) during set dates like sept 29th -
november 1st.

any help would be appreaciated
.

.
Click to expand...


.
Click to expand...
Click to expand...
 
Thank you for all of your help you have been a big help

william storey
-----Original Message-----
You can't do this easily in a single query. Normally, you would use a report
or form to show the results of the query. On the report or form, put a
textbox in the footer section, and set its control source to this
expression:

=DSum("CommissionFieldName", "tblOrders", "[SaleFinal]
Click to expand...
[SalesStatusDate] Between
#9/29/2003# And #11/2/2003#")
--
Ken Snell
<MS ACCESS MVP>



WStoreyII said:
ok i figured that out now one more thing i on this query
i am including the commission made field how do i get a
sum of that showed at the bottom to see what i made
-----Original Message-----
Use a criterion in the query similar to this:

WHERE [SaleFinal] <> False AND [SalesStatusDate]
Click to expand...
Between
#9/29/2003# And
#11/2/2003#

(the above assumes that [SaleFinal] is a boolean
Click to expand...
field,
and that
[SalesStatusDate] is a date/time field).
--
Ken Snell
<MS ACCESS MVP>

Sorry about not providing enough info
ok i have to fields one is status (whether the sale is
finalized open or void) and another field that is the
date of status i want to make a query that will find all
records that are finalized and between a certain date
range like for instance sept 29th - nov 2nd cuz that is
the fiscal month that i will be getting paid on

thank you for your help and your patience

william storey ii



-----Original Message-----
You have not provided details of your tables.
Lets assume, your table tblOrders inlcudes the following
fields:
OrderID
OrderAmount
FinalisedDate
OrderDescriotion
etc;

SELECT
Click to expand...
OrderID,OrderDescription,OrderAmount,FinalisedDate
FROM tblOrders
WHERE FinalisedDate BETWEEN [Enter Start Date] AND
[Enter
end Date]

Jacinto
-----Original Message-----
Hello,

I sell mattress's and am attempting to make a database
of
all of my sales. Now the problem is this I only get
paid
on sales that are finalized in the fiscal period for
that
given month. So what i am attempting to do is set up a
query that will produce all order that were finalized
(which is one field) during set dates like sept 29th -
november 1st.

any help would be appreaciated
.

.



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


.
Click to expand...
 
Back
Top