by: Tim Morrison |
last post by:
MSSQL2000
I have a table that contains customer transactions
CustomerID
Transaction
TransactionDate
....
I need to select the most recent record that matches a specific CustomerID.
|
by: Shaiguy |
last post by:
I have a table containing the following fields:
ProjectUpdateID (PrimaryKey)
ProjectID
UpdateDate
I would like to create a Query in Ms Access 2000 which will return me
the most recent 2...
|
by: doublej0 |
last post by:
I have the following issue when trying to write a SQL statement to
accomplish my goal. I have done a lot of research, but have been
unsuccessful in creating the query. I have two tables, one with...
|
by: evenprimes |
last post by:
Here's the table setup:
table1:
-key
-name
table2:
-key
-modification_date
-phone_number
|
by: mlwils2 |
last post by:
I'm working with a report that uses three views. There are duplicate records because the 'priority' which comes from one view has changed and SELECT DISTINCT sees it as a separate record. The users...
|
by: Jonathan |
last post by:
I have the following query which is retrieving a set of data it is
almost what I want but I can not manage to get the result I desire.
SELECT r1, r1_dev, r2, r2_dev, date, time
FROM output...
|
by: psuaudi |
last post by:
i have a table with dates that events occured. it looks something like this:
11/18/2006 1:00PM Open
11/18/2006 1:25PM Close
I created a select query that selects the last (most recent)...
|
by: brewer95 |
last post by:
I use a form to enter data into a table. The user then has the opportunity to recall the data in the form based on a search to review and update the info. For example, on my menu there is a combo...
|
by: jpgoeth |
last post by:
What I'm trying to do is select the most recent record for each customer who created an account between 2004-01-01 and 2007-01-01. I'm using MSQuery.
I have this so far:
SELECT OrderOrAdjust,...
|
by: luciegiles |
last post by:
Hi,
I would like to order the records in a subform frmSub by the field 'ReferralDate' (short date) so that the most recent record appears first. I'm sure this must be fairly simple but I can't get...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
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,...
|
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...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
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...
|