DATE CRITERIA FAILURE

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

problem statement: i have a query consisting of the following fields: client
id, amount, insertion date. i want to create a query that allows me to view
data after a particular date. at the same time i want to create a separate
field that sums data (amount) before the date of choice.
the problem is that the query is not working properly. it returns only half
of the clients and the date i enter in the criteria returns no data if there
is not at least one insertion at that date.

could you help me?
 
Dear Angie,

I would create two different queries and one form to carry out this task.
On the form create an unbound object to insert the date.
In the first query add the needed fields (data after a particular date), the
criteria of the date should be your unbound object in your form
(>=theUnboundObject).
In the second query (which should sum up the data) the criteria of the date
<=theUnboundObject.
Does this help?

Ο χÏήστης "angie" έγγÏαψε:
 
How about posting you SQL statement so we can get an idea of what you're
talking about/

Sam
 
Back
Top