Can anyway help me write this query? I've created a DB to help me
manage delivery logistics for items I rent out. I have a table that i
use to record delivery date, delivery time, pickup date, pickup time,
and quantity (of items to drop off). All of the items are identical so
i don't need to distinguish by type. I have 80 deliveries and 80
pickups over 7 days. I would like to generate a query that will list
the total number of items out each day. I do not need to account for
the specific times throught the day. 2 1895 au************* @gmail.com wrote:
Can anyway help me write this query? I've created a DB to help me
manage delivery logistics for items I rent out. I have a table that i
use to record delivery date, delivery time, pickup date, pickup time,
and quantity (of items to drop off). All of the items are identical so
i don't need to distinguish by type. I have 80 deliveries and 80
pickups over 7 days. I would like to generate a query that will list
the total number of items out each day. I do not need to account for
the specific times throught the day.
You already posted this - verbatim. We heard you the first time. Do
you mean the items delivered? Or delivered but not picked up? Or? What
_exactly_ do you mean by "out"? (Business rule? "Out" = all the items
that have not been picked up?)
Just wondering why you have delivery date and delivery time in separate
fields...
Sounds like you could just use a totals query.
(Apologies to Albert Kallal for this...)
"Loan"
<---------------------timeline-------------<NOW>------------------------>
o---------------------o
o------------------------o
o-----------------------------------o
IssueDateStamp< NOW AND
(returnDateStam p>NOW or returnDateStamp IS NULL)
right?
Sorry about posting twice. This is really the first time I've used
google groups and I wasn't sure if my first post was in the correct
category. I believe the expression you wrote below is on the right
track. However, what I would like to do is project inventory for the
whole week these deliveries are taking place. In other words, I do not
want to query the inventory that is out currently, but analyze what it
will daily while this event takes place (in the future). Thanks again
for your post! pi********@hotm ail.com wrote:
au************* @gmail.com wrote:
Can anyway help me write this query? I've created a DB to help me
manage delivery logistics for items I rent out. I have a table that i
use to record delivery date, delivery time, pickup date, pickup time,
and quantity (of items to drop off). All of the items are identical so
i don't need to distinguish by type. I have 80 deliveries and 80
pickups over 7 days. I would like to generate a query that will list
the total number of items out each day. I do not need to account for
the specific times throught the day.
You already posted this - verbatim. We heard you the first time. Do
you mean the items delivered? Or delivered but not picked up? Or? What
_exactly_ do you mean by "out"? (Business rule? "Out" = all the items
that have not been picked up?)
Just wondering why you have delivery date and delivery time in separate
fields...
Sounds like you could just use a totals query.
(Apologies to Albert Kallal for this...)
"Loan"
<---------------------timeline-------------<NOW>------------------------>
o---------------------o
o------------------------o
o-----------------------------------o
IssueDateStamp< NOW AND
(returnDateStam p>NOW or returnDateStamp IS NULL)
right?
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: WalterR |
last post by:
This is my first time here, so there may be earlier relevant threads of
which I am unaware. Though my experience with DB2 is not extensive,
such as it is was under OS/390 or equ. My main experience is IMS DB,
which leads to my question.
In IMS, there is an HDAM access method which can find a record without
using an index as such. At initial database load, it first formats the
entire space allocation into blocks of the given size. ...
|
by: Peter Phelps |
last post by:
My problem is as follows:
I need automatically iterate through a single field in a table and use
the values in the field to create an in-statement. Currently, the
character limitation in the "Zoom" feature of the MS Access query
builder limits the number of characters I can enter into my
In-Statement. As a result, I need to iterate through a particular
field (Customer ID Numbers) and use each record as a criteria in a
query. I want to...
|
by: Riegnman |
last post by:
Hey guys, I'm in need of a little help. I am very new to access but
have been trying to learn. My problem is as follows. . .
We have time clocks that dump the badge punches into a .log file on
one of the servers. I then use access to import these .log files and
separate the data into various tables so that I can manipulate it.
The problem is that the time clock just records punches and not "in"
and "out" times. The data that comes...
|
by: Steve Oster |
last post by:
Hi all,
I have to create a query using MS Query, and what I need is beyond my
knowledge.
I am querying from a list of invoices, and each invoice can have several
delivery dates (possibly a different date for each line item on the
invoice).
I need to retrieve the largest delivery date for each invoice that does not
|
by: Seth |
last post by:
I have a table of the structure below:
Delivery Product
101 A
101 B
101 C
102 A
102 E
103 C
104 A
| |
by: justicerulesok |
last post by:
Hello,
I've just started a new job where at interview I said my week point was
MS Access. I got the job & they've asked me to create a DB on Access
97 to log calls to the IT department & keep a record of the action
taken. I thought I was going quite well I have talbes for new call,
call details, caller, equipment, escalation routes, contact details for
escalation routes, I got all the relationships up & runing (I think) &
then did a...
|
by: audiophilechris |
last post by:
Can anyway help me write this query? I've created a DB to help me
manage delivery logistics for items I rent out. I have a table that i
use to record delivery date, delivery time, pickup date, pickup time,
and quantity (of items to drop off). All of the items are identical so
i don't need to distinguish by type. I have 80 deliveries and 80
pickups over 7 days. I would like to generate a query that will list
the total number of items out...
|
by: keri |
last post by:
Hello again,
While I try and solve the calender issue I also have another problem.
I have a form & table (appointments) where the user records
appointments in the future. The fields include date, time and duration.
I would like a pop up box to appear when registering an appointment if
the time / days clash with another appointment.
Somehow I need to create a table or query that blocks out sections of
|
by: rob41 |
last post by:
I'm in the process of converting numerous queries from access 07 to sql server 05 to improve runtime performance. Below is a sample of code and the error I'm getting.
INSERT INTO
( , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , )
SELECT ., ., ., LTrim(.) AS Expr1, LTrim(.) AS , LTrim(.) AS , LTrim(.) AS , LTrim(.) AS , LTrim(.) AS , LTrim(.) AS , LTrim(.) AS , LTrim(.) AS ,...
|
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: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
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: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
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...
| |