UnMatched Query
Fri, 15 Aug 2008 19:07:03 -0700
Hi
I want to create an unmatched query that returns unique records.
Explanation:
I want to return records containing the Name, Address and Location fields
only, from Table1 where the combined fields Name, Address and Location are
are not in Table2...and I want each record that is returned to be unique.
...
|
Parameter help
Fri, 15 Aug 2008 13:39:02 -0700
Hi everyone,
Pardon me if this question sounds dumb or makes no sense, but I'm a little
rusty using Access. I've been pressed into service to add a few parameters
to some queries and I'm stuck on one. I have a Banner field that can be P&C,
Quality, and a few other choices. I've got a select query that gets ...
|
is it possible to do a compare in Access 2000
Fri, 15 Aug 2008 13:02:02 -0700
I need to compare 2 data bases in Access 2000. Can it be done? I downloaded
Compare Data Wiz and it doesn show as an add-in. Anyone?
Thanks,
Joanne ...
|
Random sampling of data
Fri, 15 Aug 2008 11:46:51 -0700 (PDT)
I have a database that contains thousands of records but each record
will have one of 300 physician ID's. I am trying to query a random
sampling of 5 records under each physician ID. Any help would be
awesome! ...
|
how can I specify text criteria when querying a memo field
Fri, 15 Aug 2008 09:32:02 -0700
When I use text in query criteria against a Memo field it is ignored. The
same criteria used against a Text field works fine. Is there a way to make
the query work for the Memo field. If not, how can I convert the Memo
field(s) using a Macro or when I import the field from Microsoft Project? ...
|
Help Query to return limited records
Fri, 15 Aug 2008 09:01:02 -0700
Hello,
I am trying to create a query (total) to limits the records so it returns no
more than one records with the same order#, but have no success so far.
I have fields for part#, order#, operation, other.... where there can be
more than one record of multiple operations in an order#.
Sample data:
Part# ...
|
Find Duplicates Query Question
Fri, 15 Aug 2008 07:06:02 -0700
I have a duplicates query counting accts for each of my branch locations. I
need for the query to say zero if the branch location has no accts to count.
Here is a copy of the SQL view of my query
SELECT First([Recency 180 days1].[Correct BranchNumber]) AS [Correct
BranchNumber Field], Count([Recency 180 day ...
|
|
|
Too Many Parameter Prompts
Fri, 15 Aug 2008 06:49:01 -0700
I created a very simply shipping report that Groups by customer_no; Now I
need to create a parameter that allows selecting shipments for a paticular
date.
I created a Query called ShipDate that selects from
Field: ship_date
Table: Shipment
Criteria: [Enter Ship Date]
Query Parameter: StartDate / Date
...
|
Calculate Mileage
Fri, 15 Aug 2008 06:27:01 -0700
I am trying to calculate the mileage from two different fuel transactions.
The previous record has the mileage at the time of fueling and then the
subsequent record has the new mileage. How can I recall the previous mileage
to perform a calculation based upon the new mileage?
--
Bruce ...
|
inserting a dash
Fri, 15 Aug 2008 05:59:03 -0700
I am trying add two dashed line between six numbers. I am using an update
query to change the table but my "Update to" argument must be incorrect.
The field is called MR_# and the data in the field is currently 123456. But
I need it to be 12-34-56. I am using:
Left([MR_#],2) & "-" & Mid([MR_#],3,2) & "-" ...
|
