|
|
Dup Entry Query by
Peter Carlson
All of my records should have a unique ID (imported from a text file so
it's NOT a key). I am looking for duplicate ID#'s
My select should look something...
|
|
4 |
92 |
|
|
Change data name by
Alex Martinez
Hello - Sorry for the double posting
I am using Access 2002 and I need some help on my query. I have a field
name "claim examiners", which I use the first...
|
|
1 |
97 |
|
|
Problem with Nested IIF by
Laura_Christian
I am trying to set up a query with a calculated field (let's call it
) that contains a number of conditions.
The query includes the following fields: , ,
,...
|
|
2 |
133 |
|
|
Update query using Sum function by
chilvs
Hi,
I have a databse with a customer table and three seperate account tables all
linked by CustID.
Each account table contains a field called profit. I am...
|
|
4 |
94 |
|
|
Query by
Jologs
Hi:
I have 2 tables that have common structure. Both have 2 colums, (1) Account
Title
(2) Amount.
I want to sum the Amount colums of the 2 tables. How will...
|
September 21st, 2005 10:17 AM
by Dennis
|
1 |
149 |
|
|
Field contains no character by
Steve Crowther
Trying to find out how to Query a field that doesn't contain any characters,
alpha or numeric.
I'm using 'Like "*"' for find records that do contain...
|
|
2 |
87 |
|
|
Primary Key re-setting to "0" by
Richard Sunderland
I have a form with an underlying query for data input. It is brought up by
entering the primary key in a search parameter box. All works fine, except
when...
|
|
4 |
83 |
|
|
Add records if do not exist? by
SusanV
Hi all,
I have a table with the following fields:
PlanID
PlanName
LOM
(plus other fields to be copied into the missing records, and a couple
fields to be...
|
September 21st, 2005 01:16 PM
by SusanV
|
7 |
141 |
|
|
Cross table Query by
Paramasivan
Hi All,
I have created a cross table query and exported the results manually to
the other table.
Can any one please help me to write a cross table query which...
|
|
2 |
106 |
|
|
generate a temporary table by
Darryl
Greetings,
I am using Access 2000. Can a query be created that generates a temporary
table, and then
a report uses that temp table for input ? How about a...
|
September 21st, 2005 02:28 PM
by Darryl
|
3 |
114 |
|
|
Format A Field In A SQL UNION Query by
William Horton
Could anybody please instruct me on how to format a field in a SQL UNION
query? My SQL statement is like the following:
SELECT
#1/1/2005# As...
|
|
4 |
103 |
|
|
postcode search, lookup, finder by
michael duncan
Anyone looking for an address finder or postcode search?
Try postcode anywhere for a great range of online address...
|
|
1 |
199 |
|
|
Trim Spaces by
Garry
Hi
I need to trim some reference numbers in the form of
B D AAA
D A BCD etc
too
BD AAA
DA BCD i.e. removing the first space
|
September 21st, 2005 03:41 PM
by Dennis
|
1 |
114 |
|
|
Finding First, Last, Second Records by
r. howell
Each job has a variable number of consultants (ranging from 0 to 5)
The names and addresses of these consultants have to be printed out across
the bottom of...
|
|
2 |
97 |
|
|
|
|
6 |
244 |
|
|
|
|
2 |
165 |
|
|
Autonumber in specified format by
DD
I'm creating a table with the help of a make-table query.One of the fields in
the table REP_ID needs to have a start value of 1000 and should be
incremented...
|
|
1 |
125 |
|
|
help with error-new user by
sigm
I'm trying to pull the max values within a certain field, but I need to keep
the max values with the respective values in another table. I've got a device
name...
|
September 21st, 2005 06:49 PM
by sigm
|
1 |
73 |
|
|
|
September 21st, 2005 06:51 PM
by Rick B
|
1 |
189 |
|
|
Charting with Access by
Ana
Hello u all,
Were can I learn on Howto draw charts from query data?
TIA
Ana
|
|
1 |
80 |