Collapsing continuous records into one
Fri, 31 Oct 2008 07:07:01 -0700
This seems like it should be doable but I can't figure it out. I want to
reduce multiple records to one where the start date of one record is the day
after the end date of another where EEnum and Bondtype are equal. Thanks in
advance for any help you can provide. Example below.
Current table
EEnum Bondtyp ...
|
MISSING ZEROS IN A QUERY
Fri, 31 Oct 2008 06:24:00 -0700
I have a query that returns 50 counties in the first column. In the second
column, the query returns a count of a two-letter code (ET). In counties
where there are no ETs, the field in the count column is blank instead of a
zero. I need it be a zero. Why is the field blank and what can I do to have
the q ...
|
Pass Through Query
Fri, 31 Oct 2008 06:12:01 -0700
Hello,
How do I get a pass through query to pull data from a column that has date
and time in it?
Thanks in advance for your help. ...
|
QUARTILES in SQL/QUERY
Fri, 31 Oct 2008 05:45:03 -0700
Hey,
MS Access 2003 in XP PRO.
I'm evaluating personel and I need to divide a rating into quartiles,
preferably in a query, not filling a table tiwh VB, though if that's the only
way, then so be it.
Field 1: Driver ID
FIeld 2: Count of Issues
I want Field 3: to be the quartile of the distribution of t ...
|
Between dates criteria
Fri, 31 Oct 2008 03:08:47 -0700
Access 2000. If I put a specific date, or a date <, in one column criteria it
is OK, but if I put crieria in two columns it only shows some of the data or
none at all. I have been unable to get any information up if I put > and <
dates.
...
|
Removing partial character strings
Thu, 30 Oct 2008 22:06:01 -0700
I am using XP and Access 2003. I have 35,000 records in the table, of which
4,500 in text field address2 has characters such as â?? # 101â? (e.g., 123 Main
St. # 101; 456 Elm Ave. # A).
Starting from, and including the space that is on the left of the #, I need
to remove everything to the right (e.g., it ...
|
How do I use a class property as criteria in an Access query?
Thu, 30 Oct 2008 21:44:01 -0700
I have the option of referencing a control on a form for criteria in a query
which is the record source for a report, but would prefer to reference a
property of a class. This will be good practice for creating and using class
modules.
However, the query grid doesn't recognize the "class.property" and insis ...
|
|
|
Not Like
Thu, 30 Oct 2008 18:15:02 -0700
I have a table with a large list of codes.
I need to create a query which will filter out a lot of different codes too
many to really list.
I am thinking I would do multiple criteria Not Like "L*" and Not like "S9*"
etc...
I probably need up to about ten of these filters
What is the best way to code ...
|
Strip field data of quotation marks
Thu, 30 Oct 2008 17:31:00 -0700
I have a csv text data that contains address information that has been
concatenated in an external query and imported into our database using the
TransferText method. The problem is that some of the records include PO box
numbers and Unit numbers so the addr_line2 field value contains a comma. This
ends up s ...
|
find records between two dates
Thu, 30 Oct 2008 17:18:01 -0700
A dataset of patient records includes two fields that define service dates
([from_date] and [thru_date]). I want to create a subset of records that
were active on a specific date, i.e. 7/31/08. The following sql returns no
records:
SELECT [qry Dataset].originl_recipient_id, [qry Dataset].from_date, [qry
...
|
