lookup between dates

[Annette]

I'm making a query to look up parts purchased between different dates. It
doesn't pull up the information. This is what I have done so far.

SELECT [Purchasing Log Query].[Part#], [Purchasing Log Query].[NAI #],
[Purchasing Log Query].[Quantity Received], [Purchasing Log Query].[Date In],
[Purchasing Log Query].Description, [Purchasing Log Query].Comments
FROM [Purchasing Log Query]
WHERE ((([Purchasing Log Query].[Date In]) Between [Enter Start Date] And
[Enter End Date]));

Any suggestion would be greatly appreciated. Thank you in advance.

 

[KARL DEWEY]

Try this for WHERE --
WHERE DateValue([Purchasing Log Query].[Date In]) Between CVDate([Enter
Start Date]) And CVDate([Enter End Date]);

This will remove any time component and convert your text to date.

 

[Annette]

Hi Karl,
I entered the information and I get a error message. "This expression is
typed incorrectly, or it is too complex to be evaluated. For example, a
numeric expression may contain too many complicated elements. Try
simplifying the expression by assigning parts of the expression to
variables." This is how I changed it.

SELECT [Purchasing Log Query].[Part#], [Purchasing Log Query].[NAI #],
[Purchasing Log Query].[Quantity Received], [Purchasing Log Query].[Date In],
[Purchasing Log Query].Description, [Purchasing Log Query].Comments
FROM [Purchasing Log Query]
WHERE DateValue([Purchasing Log Query.[Date In])Between CVDate([Enter Start
Date])And CVDate([Enter End Date]);
Thanks in advance.

Try this for WHERE --
WHERE DateValue([Purchasing Log Query].[Date In]) Between CVDate([Enter
Start Date]) And CVDate([Enter End Date]);

This will remove any time component and convert your text to date.

--
KARL DEWEY
Build a little - Test a little

I'm making a query to look up parts purchased between different dates. It
doesn't pull up the information. This is what I have done so far.

SELECT [Purchasing Log Query].[Part#], [Purchasing Log Query].[NAI #],
[Purchasing Log Query].[Quantity Received], [Purchasing Log Query].[Date In],
[Purchasing Log Query].Description, [Purchasing Log Query].Comments
FROM [Purchasing Log Query]
WHERE ((([Purchasing Log Query].[Date In]) Between [Enter Start Date] And
[Enter End Date]));

Any suggestion would be greatly appreciated. Thank you in advance.

 

[KARL DEWEY]

Let's go back to your orignal problem - 'It doesn't pull up the information.'
Does pull some or none? Does it pull wrong records?
Is your [Date In] field a DateTime datatype?
What is the format that you enter on prompt by [Enter Start Date] And
[Enter End Date]?

--
KARL DEWEY
Build a little - Test a little

Hi Karl,
I entered the information and I get a error message. "This expression is
typed incorrectly, or it is too complex to be evaluated. For example, a
numeric expression may contain too many complicated elements. Try
simplifying the expression by assigning parts of the expression to
variables." This is how I changed it.

SELECT [Purchasing Log Query].[Part#], [Purchasing Log Query].[NAI #],
[Purchasing Log Query].[Quantity Received], [Purchasing Log Query].[Date In],
[Purchasing Log Query].Description, [Purchasing Log Query].Comments
FROM [Purchasing Log Query]
WHERE DateValue([Purchasing Log Query.[Date In])Between CVDate([Enter Start
Date])And CVDate([Enter End Date]);
Thanks in advance.

Try this for WHERE --
WHERE DateValue([Purchasing Log Query].[Date In]) Between CVDate([Enter
Start Date]) And CVDate([Enter End Date]);

This will remove any time component and convert your text to date.

--
KARL DEWEY
Build a little - Test a little

I'm making a query to look up parts purchased between different dates. It
doesn't pull up the information. This is what I have done so far.

SELECT [Purchasing Log Query].[Part#], [Purchasing Log Query].[NAI #],
[Purchasing Log Query].[Quantity Received], [Purchasing Log Query].[Date In],
[Purchasing Log Query].Description, [Purchasing Log Query].Comments
FROM [Purchasing Log Query]
WHERE ((([Purchasing Log Query].[Date In]) Between [Enter Start Date] And
[Enter End Date]));

Any suggestion would be greatly appreciated. Thank you in advance.

 

[Annette]

The enter start date and enter end date works fine but no records are coming
up.

Let's go back to your orignal problem - 'It doesn't pull up the information.'
Does pull some or none? Does it pull wrong records?
Is your [Date In] field a DateTime datatype?
What is the format that you enter on prompt by [Enter Start Date] And
[Enter End Date]?

--
KARL DEWEY
Build a little - Test a little

Hi Karl,
I entered the information and I get a error message. "This expression is
typed incorrectly, or it is too complex to be evaluated. For example, a
numeric expression may contain too many complicated elements. Try
simplifying the expression by assigning parts of the expression to
variables." This is how I changed it.

SELECT [Purchasing Log Query].[Part#], [Purchasing Log Query].[NAI #],
[Purchasing Log Query].[Quantity Received], [Purchasing Log Query].[Date In],
[Purchasing Log Query].Description, [Purchasing Log Query].Comments
FROM [Purchasing Log Query]
WHERE DateValue([Purchasing Log Query.[Date In])Between CVDate([Enter Start
Date])And CVDate([Enter End Date]);
Thanks in advance.

Try this for WHERE --
WHERE DateValue([Purchasing Log Query].[Date In]) Between CVDate([Enter
Start Date]) And CVDate([Enter End Date]);

This will remove any time component and convert your text to date.

--
KARL DEWEY
Build a little - Test a little


:

I'm making a query to look up parts purchased between different dates. It
doesn't pull up the information. This is what I have done so far.

SELECT [Purchasing Log Query].[Part#], [Purchasing Log Query].[NAI #],
[Purchasing Log Query].[Quantity Received], [Purchasing Log Query].[Date In],
[Purchasing Log Query].Description, [Purchasing Log Query].Comments
FROM [Purchasing Log Query]
WHERE ((([Purchasing Log Query].[Date In]) Between [Enter Start Date] And
[Enter End Date]));

Any suggestion would be greatly appreciated. Thank you in advance.

 

[KARL DEWEY]

Try opening the query in design view, delete criteria, and without saving run
the query to see if it pulls any records.

If it does then enter this in criteria row using a date of a record it
produced above but one day less and one day greater --
Between #7/21/2007# AND #8/30/2008#

--
KARL DEWEY
Build a little - Test a little

The enter start date and enter end date works fine but no records are coming
up.

Let's go back to your orignal problem - 'It doesn't pull up the information.'
Does pull some or none? Does it pull wrong records?
Is your [Date In] field a DateTime datatype?
What is the format that you enter on prompt by [Enter Start Date] And
[Enter End Date]?

--
KARL DEWEY
Build a little - Test a little

Hi Karl,
I entered the information and I get a error message. "This expression is
typed incorrectly, or it is too complex to be evaluated. For example, a
numeric expression may contain too many complicated elements. Try
simplifying the expression by assigning parts of the expression to
variables." This is how I changed it.

SELECT [Purchasing Log Query].[Part#], [Purchasing Log Query].[NAI #],
[Purchasing Log Query].[Quantity Received], [Purchasing Log Query].[Date In],
[Purchasing Log Query].Description, [Purchasing Log Query].Comments
FROM [Purchasing Log Query]
WHERE DateValue([Purchasing Log Query.[Date In])Between CVDate([Enter Start
Date])And CVDate([Enter End Date]);
Thanks in advance.




:

Try this for WHERE --
WHERE DateValue([Purchasing Log Query].[Date In]) Between CVDate([Enter
Start Date]) And CVDate([Enter End Date]);

This will remove any time component and convert your text to date.

--
KARL DEWEY
Build a little - Test a little


:

I'm making a query to look up parts purchased between different dates. It
doesn't pull up the information. This is what I have done so far.

SELECT [Purchasing Log Query].[Part#], [Purchasing Log Query].[NAI #],
[Purchasing Log Query].[Quantity Received], [Purchasing Log Query].[Date In],
[Purchasing Log Query].Description, [Purchasing Log Query].Comments
FROM [Purchasing Log Query]
WHERE ((([Purchasing Log Query].[Date In]) Between [Enter Start Date] And
[Enter End Date]));

Any suggestion would be greatly appreciated. Thank you in advance.

 

[Annette]

Thanks Karl I checked and my date field was a test. I changed it to
Date/time field and my query works. Thank you so much. The records that I'm
pulling also as a quantity of parts. Is there a way to total the quantity
when I pull these records?

Try opening the query in design view, delete criteria, and without saving run
the query to see if it pulls any records.

If it does then enter this in criteria row using a date of a record it
produced above but one day less and one day greater --
Between #7/21/2007# AND #8/30/2008#

--
KARL DEWEY
Build a little - Test a little

The enter start date and enter end date works fine but no records are coming
up.

Let's go back to your orignal problem - 'It doesn't pull up the information.'
Does pull some or none? Does it pull wrong records?
Is your [Date In] field a DateTime datatype?
What is the format that you enter on prompt by [Enter Start Date] And
[Enter End Date]?

--
KARL DEWEY
Build a little - Test a little


:

Hi Karl,
I entered the information and I get a error message. "This expression is
typed incorrectly, or it is too complex to be evaluated. For example, a
numeric expression may contain too many complicated elements. Try
simplifying the expression by assigning parts of the expression to
variables." This is how I changed it.

SELECT [Purchasing Log Query].[Part#], [Purchasing Log Query].[NAI #],
[Purchasing Log Query].[Quantity Received], [Purchasing Log Query].[Date In],
[Purchasing Log Query].Description, [Purchasing Log Query].Comments
FROM [Purchasing Log Query]
WHERE DateValue([Purchasing Log Query.[Date In])Between CVDate([Enter Start
Date])And CVDate([Enter End Date]);
Thanks in advance.




:

Try this for WHERE --
WHERE DateValue([Purchasing Log Query].[Date In]) Between CVDate([Enter
Start Date]) And CVDate([Enter End Date]);

This will remove any time component and convert your text to date.

--
KARL DEWEY
Build a little - Test a little


:

I'm making a query to look up parts purchased between different dates. It
doesn't pull up the information. This is what I have done so far.

SELECT [Purchasing Log Query].[Part#], [Purchasing Log Query].[NAI #],
[Purchasing Log Query].[Quantity Received], [Purchasing Log Query].[Date In],
[Purchasing Log Query].Description, [Purchasing Log Query].Comments
FROM [Purchasing Log Query]
WHERE ((([Purchasing Log Query].[Date In]) Between [Enter Start Date] And
[Enter End Date]));

Any suggestion would be greatly appreciated. Thank you in advance.

 

[KARL DEWEY]

You can total in a form or report footer.
Otherwise you use a totals query but you can not total and at the same time
view individual records.
--
KARL DEWEY
Build a little - Test a little

Thanks Karl I checked and my date field was a test. I changed it to
Date/time field and my query works. Thank you so much. The records that I'm
pulling also as a quantity of parts. Is there a way to total the quantity
when I pull these records?

Try opening the query in design view, delete criteria, and without saving run
the query to see if it pulls any records.

If it does then enter this in criteria row using a date of a record it
produced above but one day less and one day greater --
Between #7/21/2007# AND #8/30/2008#

--
KARL DEWEY
Build a little - Test a little

The enter start date and enter end date works fine but no records are coming
up.

:

Let's go back to your orignal problem - 'It doesn't pull up the information.'
Does pull some or none? Does it pull wrong records?
Is your [Date In] field a DateTime datatype?
What is the format that you enter on prompt by [Enter Start Date] And
[Enter End Date]?

--
KARL DEWEY
Build a little - Test a little


:

Hi Karl,
I entered the information and I get a error message. "This expression is
typed incorrectly, or it is too complex to be evaluated. For example, a
numeric expression may contain too many complicated elements. Try
simplifying the expression by assigning parts of the expression to
variables." This is how I changed it.

SELECT [Purchasing Log Query].[Part#], [Purchasing Log Query].[NAI #],
[Purchasing Log Query].[Quantity Received], [Purchasing Log Query].[Date In],
[Purchasing Log Query].Description, [Purchasing Log Query].Comments
FROM [Purchasing Log Query]
WHERE DateValue([Purchasing Log Query.[Date In])Between CVDate([Enter Start
Date])And CVDate([Enter End Date]);
Thanks in advance.




:

Try this for WHERE --
WHERE DateValue([Purchasing Log Query].[Date In]) Between CVDate([Enter
Start Date]) And CVDate([Enter End Date]);

This will remove any time component and convert your text to date.

--
KARL DEWEY
Build a little - Test a little


:

I'm making a query to look up parts purchased between different dates. It
doesn't pull up the information. This is what I have done so far.

SELECT [Purchasing Log Query].[Part#], [Purchasing Log Query].[NAI #],
[Purchasing Log Query].[Quantity Received], [Purchasing Log Query].[Date In],
[Purchasing Log Query].Description, [Purchasing Log Query].Comments
FROM [Purchasing Log Query]
WHERE ((([Purchasing Log Query].[Date In]) Between [Enter Start Date] And
[Enter End Date]));

Any suggestion would be greatly appreciated. Thank you in advance.

 

[Annette]

Thank you very much for all your help.

You can total in a form or report footer.
Otherwise you use a totals query but you can not total and at the same time
view individual records.
--
KARL DEWEY
Build a little - Test a little

Thanks Karl I checked and my date field was a test. I changed it to
Date/time field and my query works. Thank you so much. The records that I'm
pulling also as a quantity of parts. Is there a way to total the quantity
when I pull these records?

Try opening the query in design view, delete criteria, and without saving run
the query to see if it pulls any records.

If it does then enter this in criteria row using a date of a record it
produced above but one day less and one day greater --
Between #7/21/2007# AND #8/30/2008#

--
KARL DEWEY
Build a little - Test a little


:

The enter start date and enter end date works fine but no records are coming
up.

:

Let's go back to your orignal problem - 'It doesn't pull up the information.'
Does pull some or none? Does it pull wrong records?
Is your [Date In] field a DateTime datatype?
What is the format that you enter on prompt by [Enter Start Date] And
[Enter End Date]?

--
KARL DEWEY
Build a little - Test a little


:

Hi Karl,
I entered the information and I get a error message. "This expression is
typed incorrectly, or it is too complex to be evaluated. For example, a
numeric expression may contain too many complicated elements. Try
simplifying the expression by assigning parts of the expression to
variables." This is how I changed it.

SELECT [Purchasing Log Query].[Part#], [Purchasing Log Query].[NAI #],
[Purchasing Log Query].[Quantity Received], [Purchasing Log Query].[Date In],
[Purchasing Log Query].Description, [Purchasing Log Query].Comments
FROM [Purchasing Log Query]
WHERE DateValue([Purchasing Log Query.[Date In])Between CVDate([Enter Start
Date])And CVDate([Enter End Date]);
Thanks in advance.




:

Try this for WHERE --
WHERE DateValue([Purchasing Log Query].[Date In]) Between CVDate([Enter
Start Date]) And CVDate([Enter End Date]);

This will remove any time component and convert your text to date.

--
KARL DEWEY
Build a little - Test a little


:

I'm making a query to look up parts purchased between different dates. It
doesn't pull up the information. This is what I have done so far.

SELECT [Purchasing Log Query].[Part#], [Purchasing Log Query].[NAI #],
[Purchasing Log Query].[Quantity Received], [Purchasing Log Query].[Date In],
[Purchasing Log Query].Description, [Purchasing Log Query].Comments
FROM [Purchasing Log Query]
WHERE ((([Purchasing Log Query].[Date In]) Between [Enter Start Date] And
[Enter End Date]));

Any suggestion would be greatly appreciated. Thank you in advance.