Sorry to waste everyone's time with a query which is so simple, but as a new
user of Access I have created a client database and one of the fields is
"next contact due" as the name implies, this is a date sometime in the
future when I should contact the client again.
The problem I now have is that I am so ignorant of the actual program that I
do not know how to construct a simple query or report (you see I don't even
know what I want is called) to pull up the records of clients who should be
contacted in a certain week. For example, how would I get a list of all
clients who I should contact during the week 14/12/2003 - 20/12/2003. This
is to say their "next contact due" date would be within that range.
I have tried a number of other recources to try to get this answer including
a book "microsoft office 97, no experience required" and a cd rom "teaching
you microsoft access XP/2000" but neither of these have the answer and a
bloke accross the road who works with computers for a living said I should
just forget Access and put the info into Excel as it is easier to use (only
I wouldn't know how to do it in Excel either".
If anyone has the answer could you please explain it in simple terms (that a
turnip could understand) preferably a step by step approach rather than a
"you just need to" followed by a load of technical jargon answer.
Thanks in advance anyone who can spare the time to solve this problem, or
even give me some pointers
Gary 3 1960
"Gary" <gm*@bluey.co.u k> wrote: Sorry to waste everyone's time with a query which is so simple, but as a new user of Access I have created a client database and one of the fields is "next contact due" as the name implies, this is a date sometime in the future when I should contact the client again.
The problem I now have is that I am so ignorant of the actual program that I do not know how to construct a simple query or report (you see I don't even know what I want is called) to pull up the records of clients who should be contacted in a certain week. For example, how would I get a list of all clients who I should contact during the week 14/12/2003 - 20/12/2003. This is to say their "next contact due" date would be within that range.
I have tried a number of other recources to try to get this answer including a book "microsoft office 97, no experience required" and a cd rom "teaching you microsoft access XP/2000" but neither of these have the answer and a bloke accross the road who works with computers for a living said I should just forget Access and put the info into Excel as it is easier to use (only I wouldn't know how to do it in Excel either".
If anyone has the answer could you please explain it in simple terms (that a turnip could understand) preferably a step by step approach rather than a "you just need to" followed by a load of technical jargon answer.
Thanks in advance anyone who can spare the time to solve this problem, or even give me some pointers
Gary
Gary,
Create a new query and in it include your. Drag the "next contact due"
field onto the grid and in the 'criteria' line type "Between 14/12/2003 And
20/12/2003" (leave out the quotes).
That should do what you want.
If you don't understand any of the above, look in the help for "Queries".
You can base reports on stored queries.
HTH - Keith. www.keithwilby.org.uk
Thanks Keith
"Keith Wilby" <ke*********@Aw ayWithYerCrap.c om> wrote in message
news:Xn******** *************** *@10.15.188.42. .. "Gary" <gm*@bluey.co.u k> wrote:
Sorry to waste everyone's time with a query which is so simple, but as a new user of Access I have created a client database and one of the fields is "next contact due" as the name implies, this is a date sometime in the future when I should contact the client again.
The problem I now have is that I am so ignorant of the actual program that I do not know how to construct a simple query or report (you see I don't even know what I want is called) to pull up the records of clients who should be contacted in a certain week. For example, how would I get a list of all clients who I should contact during the week 14/12/2003 - 20/12/2003. This is to say their "next contact due" date would be within that range.
I have tried a number of other recources to try to get this answer including a book "microsoft office 97, no experience required" and a cd rom "teaching you microsoft access XP/2000" but neither of these have the answer and a bloke accross the road who works with computers for a living said I should just forget Access and put the info into Excel as it is easier to use (only I wouldn't know how to do it in Excel either".
If anyone has the answer could you please explain it in simple terms (that a turnip could understand) preferably a step by step approach rather than a "you just need to" followed by a load of technical jargon answer.
Thanks in advance anyone who can spare the time to solve this problem, or even give me some pointers
Gary Gary,
Create a new query and in it include your. Drag the "next contact due" field onto the grid and in the 'criteria' line type "Between 14/12/2003
And 20/12/2003" (leave out the quotes).
That should do what you want.
If you don't understand any of the above, look in the help for "Queries". You can base reports on stored queries.
HTH - Keith. www.keithwilby.org.uk
Keith Wilby <ke*********@Aw ayWithYerCrap.c om> wrote: Create a new query and in it include your.
D'oh! This should have read "Create a new query and include your table in
it". This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Manton |
last post by:
Access 2000.
I have a field in a table (tbl_data entry) which has a field called Free and
another field called SD (containing 2 options: 5 and 6)
The Free field is a yes/no format.
I'd like to run a query which upon entering a date range ("Enquiry Date")
value -allows the query to choose 170 records (by ticking off the yes/no
field "Free") randomly from tbl_data entry.
Alternatively: It could choose (ticking off the yes/no field "Free)...
|
by: Terry |
last post by:
I have a database that I would like to query for a specific date
range.
I want to create a report based on this query that will pull any
records from the last 7 days.
Is this possible? Can someone tell me how it is done?
Thanks.
|
by: kyosohma |
last post by:
Hi,
I am working on a timesheet application in which I need to to find the
first pay period in a month that is entirely contained in that month
to calculate vacation time. Below are some example date ranges:
December 31, 2006 January 13, 2007 # doesn't earn
January 14, 2007 January 27, 2007 # does earn
January 28, 2007 February 10, 2007 # doesn't
|
by: RussCRM |
last post by:
I need some help getting unique records from our database! I work for a small non-profit homeless shelter. We keep track of guest information as well as what services we have offered for statistical purposes.
I've been using
Here’s the situation:
I have two main tables:
Guest (stores data such as GuestID, First Name, Last Name, etc.) and
Services (stores data such as the type of service the guest used (Shelter Bed, Lunch, Dinner,...
|
by: srusskinyon |
last post by:
I need some help getting unique records from our database! I work for
a small non-profit homeless shelter. We keep track of guest
information as well as what services we have offered for statistical
purposes.
I've been using
Here's the situation:
I have two main tables:
| |
by: jennwilson |
last post by:
Using Access 2000 - I have a query that is suppose to return the records from table within specified time range and find matching data from another table .
Table houses Clinician name, location and rate information
Table houses Clinician name, location and number of units for each type of service rendered on each day. The two tables are connected by field
Please see the code below
SELECT .Clinician, .Location, .Date,...
|
by: jrodcody |
last post by:
Hello:
I am trying to create multiple records in a table named tblTravel based on the input of a date range in two form controls. The inputs for the form are LastName, TravelDate, EndDate, Event, LocationCity, and LocationState. Everything works perfectly, except for the fact that the dates do not correctly enter into the table. For example, if I enter a date range of March 3, 2008 - March 5, 2008 and click OK, 3 records are generated. ...
|
by: Claus Mygind |
last post by:
I have two tables employee and time. Both contain the common field EMPNO.
I want to link the tables on the EMPNO and find all records within a specific date range. But I also want to include any employee who has no time records in the time file.
note - my tables are setup to have "not null" values in the table columns. The default value is ''
here are my attempts to construct the select statement to no avail
select e.*, t.*
from...
|
by: MyWaterloo |
last post by:
'''''''''''''''''''''''''''''''''''''''''''
' The AfterUpdate event procedure used in '
' the Find Customer combo box search. '
'''''''''''''''''''''''''''''''''''''''''''
'Moves to Customer Name text box and
'finds the record of whatever name
'is selected in the combo box
DoCmd.ShowAllRecords
Me.OrderDate.SetFocus
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |