I've got a Union Query that pulls data from two different tables for
chemistry and micro testing. The tables containing very similar data but
for reasons not necessary here, cannot be put into one table (differing
types of results mainly)
However, both have date entry fields for varying time stations from an
initial, 2 weeks, 1 month, 2 months through to 24 months. I've written a
Union Query that pulls the dates into a sort of "overall" schedule for each
batch being tested.
What I'd love to do, is run something off this Union Query to allow me to
sort what testing is due for the next (or current) month. My hope is to
have the query ignore any date not within the next month time frame and just
come up with one due date for each test type and batch number. Right now I
need to physically eye ball each date column to see what's due. Right now
there are 17 date columns to show what's either been done or coming up.
Any suggestions ?? 1 2000
On Fri, 4 Feb 2005 17:41:47 +1000, "PATGMorris "
<pa*********@op tusnet.com.au> wrote:
It appears you are reaping the results of a bad database design. 17
date fields! Why not one, perhaps assisted with a DateType field.
Then you could write a simple and elegant query like:
select MyDateField
from MyUnionQuery
group by DateType
where MyDateField between Date and DateAdd("m",1,D ate)
Remember, a relational database is not a glorified spreadsheet.
-Tom. I've got a Union Query that pulls data from two different tables for chemistry and micro testing. The tables containing very similar data but for reasons not necessary here, cannot be put into one table (differing types of results mainly)
However, both have date entry fields for varying time stations from an initial, 2 weeks, 1 month, 2 months through to 24 months. I've written a Union Query that pulls the dates into a sort of "overall" schedule for each batch being tested.
What I'd love to do, is run something off this Union Query to allow me to sort what testing is due for the next (or current) month. My hope is to have the query ignore any date not within the next month time frame and just come up with one due date for each test type and batch number. Right now I need to physically eye ball each date column to see what's due. Right now there are 17 date columns to show what's either been done or coming up.
Any suggestions ?? This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Alan |
last post by:
I'm just about to start a project that needs to combine the results of a SQL
Server query with the results of an Index Server query. The basic idea is
that the user enters/selects a bunch of search criteria on a form. Most of
the criteria selected by the user will be used to select records from the
database - standard WHERE clause stuff - but the user can also enter
free-text that should be searched for in associated uploaded documents. The...
|
by: s_gregory |
last post by:
The mdb is considerable size 70 +- mb. A complex union query was
working well, but when an additional union select... was added into
the query, selecting identical fields from a different source, it
began to have problems.
Failure was observed only in a few PC's at first. For example, in an
NT 4.0 SP6 PC, it continued to work OK. But in my Win 2k laptop, it
failed. As the union query was gradually simiplified in testing, the
failure...
|
by: M.Stanley |
last post by:
Hi,
I'm attempting to create a query that will combine 2 columns of
numbers into one. The followng comes from 1 table with 4 fields
(A,B,C,D)
A B RESULT
700 000 700000
700 001 700001
700 002 700002
..
|
by: Jason |
last post by:
I have a primary form which is used to enter/edit data in a table
named Test_Results. On this primary form there is a subform which
displays site addresses. This subform is linked to the primary form
by field named TestID. The subform is used just for displaying site
address data, data which is stored in another table named
Total_Site_Address. In the Total_Site_Address table there are
numerous fields that form the site addresses...
|
by: Omey Samaroo |
last post by:
Dear Access Gurus,
Can anyone provide me with some much needed assistance.
I would like to combine the contents of 3 text fields into one field. Can
someone provide some code or a method to do so.
Please and Thanks
Omey
| |
by: justin tyme |
last post by:
Hello Experts!
I would like to combine (which may not be the correct technical term) two
text fields from the same table in a query. Specifically, text field A and
text field B are both lists of names. My goal is to have one long list of
all the names, not A next to B like one gets when you use the & operator.
The eventual goal is to be able to print labels of all the individuals. I
have no problem creating a label-Report from the Query....
|
by: Macbane |
last post by:
Hi,
I really hope you can help. I have a databse which records
interventions in patients drug therapy. Each record in the main table
contains 3 fields to capture the 3 main drug names involved in the
intervention and they are called PrimDrug, SecondaryDrug1,
SecondaryDrug2. The drug names are selected from another table called
Drug. What I want to do is to have a graph illustrate the top ten
drugs involved. While it is easy to do...
|
by: Don Barton |
last post by:
I have 2 tables, Table 1 has Name, NameID, and A, B, C fields.
Table 2 has Name, NameID, and D, E fields.
Several of the Names/NameID are the same in both databases. I want my
merged the tables so each record looks like; Name, NameID, A, B, C, D,
E. I have merged them successfully but I am getting two records for
each name, one record for A, B, C fields, and another record for the
D, E fields.
Example,
Name NameID A ...
|
by: Ken Fine |
last post by:
This is a question that someone familiar with ASP.NET and ADO.NET DataSets
and DataTables should be able to answer fairly easily. The basic question is
how I can efficiently match data from one dataset to data in a second
dataset, using a common key. I will first describe the problem in words and
then I will show my code, which has most of the solution done already.
I have built an ASP.NET that queries an Index Server and returns a...
|
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: 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: 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: 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: 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: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |