Topics Search

Modify query to display data that ends on or after a certain date?

Modify query to display data that ends on or after a certain date?
Views: 76
I dont know if this question has been asked before but I need a quick answer to this problem:

The database is complete and I am in the query but I need to display contracts with a specific contract date ending on or after a certain date.

the actual step is this:
"Modify the Current lessons query to display all contracts that end on or after 7/1/2010."

I dont know why but I cannot seem to think straight right now
Sponsored Links:

More topics

 

Display records if updated on 2 days ago, 3 days ago or 4 days

Preview
I have a query which is based on a table which has 4 fields in which if a customer has been called within a certain date range it presents it.

So the 4 fields are:

Call 1 Date
Call 2 Date
Call 3 Date
Call 4 Date

I want it to present these records if call 1 Date is More than 2 days ago. If call 2 Date is more than 2 days ago, and the same with 3 or 4. However I also want it to only look at the call date on the most recent field. Otherwise if they have already have a call 1 date, its always going to be 2 days after that for any future calls. However, I want it tocall them after 2 days since the last call.

So it ends up being a system whereby The customer gets a call every 2 days until the issue is finally resolved (unless it has happened 4 times), in which we will close it.
 

Combos working together

Preview
Thus if I select Buy and a particular year in the second combo I get a display in my continuous form of all the stock I bought in that financial year and similarly with Sell.

The Year data for the date combo is derived from a Select statement at Row Source in the combo.

However no matter what I do I cannot get the display to fire off the buy sell combo (when I switch between Buy and Sell) If I set this combo to"Buy" the display responds to any year date I select in the other and also if I set the combo to"Sell" the display is also good.

But if I select a year date in combo 2 the display will not shift when selecting between either Buy or Sell in the first combo.

The data I am working with via a query relates to buying and selling shares and the record keeping of these transactions - in the table/query there are two dates a Buy date and a Sell date thus whilst there is always a buy date there may not be a sell date giving a legitimate null in the sell date field.
 

Display Text Date as MM/DD Unique Issue

Preview
I am linked to a protected table which I can't modify and I am trying to create a report based off of it. The field is birthday and it is a text field. Unfortunately the data in the table is 12/12/1973. I am trying to display the field in a report with only the month/date. I have tried formatting the field in the report with no success
 

Cross tab query solution

Preview
I have table Named OutStationTab having the data as below field

EName - Text Field
OsDate - Date Field
OsAmt - Numeric field

I want to make a cross tab query in which
RowHeading- EName
Column Heading- Expr1: Format([OsDate],"dd-mm-y")
Value- OsAmt

Note the data is entered from 15th Date of a month to 14th date of next month. One Employee take 1 outstation charges only in a day.

I am able to make the crosstab query and its working perfect. Like I filter the query (From 15-02-2010 to 14-03-2010), then made the CrossTab

query. It works perfect.
It does not display the date on column in which no one is on outstation. BUT my requirement is that to display like all the day like - 15/02 16/02 17/02 till.14/03 . It should NOT miss any day inbetween the

period.

so that all the date inbetween the start and end date should display.

And also how to handle report. As the month changes and date count/column also changes (like decrease/increase)
 

Modify query

Preview
How can I modify this query showing the results of 3 months data :

SELECT District.Id, District.Name, Data_SDP.[First Date of 3month period], Format$([First Date of 3month period],"\Qq yyyy",0,0) AS TreMonth, Sum(Data_SDP.Mg3) AS [Low Dose], Sum(Data_SDP.Mcv3) AS Pop, Sum(Data_SDP.Depo3) AS Depot, Sum(Data_SDP.DIU3) AS IUD, Sum(Data_SDP.Cn3) AS Apples
FROM District INNER JOIN Data_SDP ON District.Id=Data_SDP.Ref_District
GROUP BY District.Id, District.Name, Data_SDP.[First Date of 3month period], Format$([First Date of 3month period],"\Qq yyyy",0,0)
ORDER BY District.Emer, Data_SDP.[First Date of 3month period];

to a query showing 6month period date.
 

Query for Received and Closed Date Range

Preview
I built a report request menu to dynamically build a SQL query for Access to run a report. The user selects the parameters and the form builds the query on the fly and then changes therecord set for the report to pull the right data.

The query building was coming along swimmingly until the users requested a date range. I have a date range selection that can look at any cases within the date range. This part is not working currently.

This is what the form generates. Get all cases with these specific parameters within this date range.

[CODE]

The problem ends up being that I get cases with received dates within the range and closed dates outside of the range or vice versa.

2) Any thoughts on how to fix this?
 

Time Query Question

Preview
I have a query which is based on a table which has 4 fields in which if a customer has been called within a certain date range it presents it.

So the 4 fields are:

Call 1 Date
Call 2 Date
Call 3 Date
Call 4 Date

I want it to present these records if call 1 Date is More than 2 days ago. If call 2 Date is more than 2 days ago, and the same with 3 or 4. However I also want it to only look at the call date on the most recent field. Otherwise if they have already have a call 1 date, its always going to be 2 days after that for any future calls. However, I want it tocall them after 2 days since the last call.

So it ends up being a system whereby The customer gets a call every 2 days until the issue is finally resolved (unless it has happened 4 times), in which we will close it.
 

Query Yes/No data via Forms

Preview
I want to create a form that a user can use to query my database. The user will choose a date range (BeginDate, EndDate), then choose which checkbox items to query for, TR11, TR12 or TR13.

Here's my table:
Date - Date
TR11 - Yes/No
TR12 - Yes/No
TR13 - Yes/No

Here's my form:
Begin Date ____
End Date _____

I created a form that properly queried the chosen date range but I can't figure out how to modify the query so that when the user checks TR11 on the form, and only the records that fall within the date range and contain a Yes value in TR11 will be displayed
 

capturing the input date

Preview
I am trying to capture the date parameter of my query.
you enter a start date and end date to display monthly cheques.
what I want to do is take the dates entered and display them in a textbox labeled invoice period on my form
 

Select query

Preview
I would like a query to display only the latest entry for a particular object but can't figure out the code.

e.g.

object 1 - date 1
object 1 - date 2
object 1 - date 3
object 1 - date 4
object 2 - date 1
object 2 - date 2
object 2 - date 3
object 3 - date 1
object 3 - date 2
object 3 - date 3
object 3 - date 4

From this I want to only display object 1 - date 4, object 2 - date 3 & object 3 - date 4