Quintiles
Mon, 15 Dec 2008 16:39:35 GMT
I have a query "LastCustomerPurchaseDate" that returns the last Purchase date
of our customers .
Two field Names BILLNAME and MaxOfDocDate.
I want to place each customer "BILLNAME" into a quintile based on their most
recent purchase "MaxOfDocDate".
The most recent quintile would be 5, the last 1.
Thanks ...
|
Query based on Query
Mon, 15 Dec 2008 08:28:28 -0800
I have a query that returns my patent records. I used that query, Query1,
and created a new query using another table, Assignment Information, Query2.
The primary key for both tables is PatentID. The join is all records from
Query1 and those from Assignment Information where the fields are equal. The
pr ...
|
how to compare 2 nested parent-child hierarchies..
Mon, 15 Dec 2008 08:27:01 -0800
I'm working on a system with extensive data validation and status checking.
It essentially matches up sellers with potential buyers, by checking through
all seller data to see if item meets their minimum purchase criteria.
Both seller and client purchase criteria are in parent-child hierarchy,
often with m ...
|
At most one record can be returned...
Mon, 15 Dec 2008 07:44:00 -0800
Hello everyone. I am trying to run a query with an imbedded subquery but
continue to get the error "At most one record can be returned from this
subquery."
I have checked and rechecked that the subquery returns only one record based
on the criteria specified. Does anyone have any idea as to why this query
...
|
Moving the last numbers of a field
Mon, 15 Dec 2008 07:26:14 -0800
Hello in table ADDRDATA we have the field ODOS and the field NOUMERO. The
field ODOS has many entries that end with numbers. I need those numbers
erased from the ODOS field and entered in the NOUMERO field. So if the ODOS
field has for example Smith 55 entered, I want the "Smith" to remain there
and the "55" ...
|
Overdue month, but not on a date field
Mon, 15 Dec 2008 08:24:35 -0500
I have a form that the user wanted to have a drop down list of the months
(not a date field formatted as a date, simply a list of the months) they
then want a report based off this field to show overdue reports. How can I
get this to work? I am sure if it was a date field it would be much easier,
but with it ...
|
Picking up particular data from flat file
Mon, 15 Dec 2008 11:41:48 GMT
Following is the sample txt file.I want to pick following values in a table
with same column names.
1.ND = 2310000 to 2319999
2.L1
3.L2
4.L3
5.L4
6.L5
7.L6
8.L7
9.L8
TXT File =>
Pls Note=> For each ND value there are individual L1 to L8 values.
@ESAB:
CEN=1/08-12-10/18 H 27 MN 29/TEST ON A SUBS ...
|
|
|
(Trans)action ID to group records
Mon, 15 Dec 2008 02:50:20 -0800 (PST)
Hi, I have a VB.NET app that writes 'usage logging' to an Access DB
via OleDb. There are applications all over the plant that log to the
same DB, so we can have a bit of insight in how the application is
being used. Some logged actions are a single entry ("user did this or
that"), others actions belong together ...
|
Zip Code Lookup
Sun, 14 Dec 2008 21:48:03 -0800
I am trying to look up a territory for a given zip code. Can someone please
help?
I have one table with a list of about 10,000 stores including their
zipcodes. I have another table with about 3,000 zip codes and their
corresponding territories. I'd like to return the territory that corresponds
to each of ...
|
Send parameters from form to query
Sun, 14 Dec 2008 18:38:00 -0800
I would like to create a form that asks for start date and end date (with
defaults) that will then send these values to a report that starts with a
query. I know how to create the form, I just don't know how to call the
report(with query front end) with the inputted values. Thank you. ...
|
