|
|
Query with compound joins by
JimS
I am importing a table from another app. It is passed as an excel
spreadsheet. I have a routine that "cleans up" the sheet, then imports it
into a temp...
|
September 10th, 2009 06:49 PM
by MGFoster
|
1 |
157 |
|
|
quandary on selecting certain records Pt.2 by
javablood
Clifford helped me out yesterday with an SQL for selecting all the STATION_ID
records for which there are zero values OR non zero values in the VOC field.
I...
|
|
2 |
115 |
|
|
|
|
4 |
248 |
|
|
remove duplicate records in Access 2007 by
Erik
I have a table that is created by an append query from 4 other tables. When
I use the append query, it creates duplicate records. For a record to be...
( 1 2)
|
September 10th, 2009 05:16 PM
by Erik
|
10 |
366 |
|
|
|
|
9 |
211 |
|
|
Pls correct this query by
subs
SELECT X.*
FROM PPG AS X INNER JOIN PPG AS Y ON (X.BLY.BL) AND
(X.Ship_Date=Y.Ship_Date) AND (X.Consignee=Y.Consignee) AND
(X.Ozip=Y.Ozip) AND...
|
|
8 |
235 |
|
|
Query Help Filtering Multiple Records by
BMC
Hi
I have a query that lists records from three tables.
The query lists all patient visits to a doctor’s office.
Each record has a diagnosis code (i.e....
|
September 10th, 2009 04:54 PM
by BMC
|
0 |
98 |
|
|
|
September 10th, 2009 04:48 PM
by Sean
|
0 |
127 |
|
|
Query with compound joins by
JimS
I am importing a table from another app. It is passed as an excel
spreadsheet. I have a routine that "cleans up" the sheet, then imports it
into a temp...
|
September 10th, 2009 04:33 PM
by JimS
|
0 |
177 |
|
|
Query - Show One of Everything by
Debra Ann
Access 2003:
I have a table with two columns. The first column has the same information
repeated over and over to match up with the unique information in...
|
|
6 |
199 |
|
|
|
September 10th, 2009 04:13 PM
by Alain
|
0 |
151 |
|
|
Does not equal Join (access 2003) by
PerryK
I have 2 tables with data that includes "Part Numbers" in both.
I want to create a Query to list all of the data in the first table, but not
for the "Part...
|
September 10th, 2009 03:54 PM
by PerryK
|
4 |
173 |
|
|
Query - Show One of Everything by
Debra Ann
Access 2003:
I have a table with two columns. The first column has the same information
repeated over and over to match up with the unique information in...
|
|
0 |
95 |
|
|
query for missing value by
Bryce
hi,
i am using access 2003 and have a .csv that i imported into a table.
i need to extract a list of computer names that do NOT have our custom
service...
|
September 10th, 2009 03:15 PM
by Bryce
|
0 |
107 |
|
|
Does not equal Join (access 2003) by
PerryK
I have 2 tables with data that includes "Part Numbers" in both.
I want to create a Query to list all of the data in the first table, but not
for the "Part...
|
September 10th, 2009 03:12 PM
by PerryK
|
0 |
137 |
|
|
List in a Query by
Chris
I have recently name a query and it is working how it should. However one
thing that I would like to add to it is a dropdown list of things to choose
from...
|
September 10th, 2009 03:01 PM
by Chris
|
0 |
90 |
|
|
|
|
6 |
139 |
|
|
Add OR IIF to my statement by
Jon Dibble[_2_]
Hi
Can anyone please help me add to my statement?
Currently it returns text based on data in a string field on our database.
What I need to add is that if...
|
|
2 |
131 |
|
|
Date Criteria Range by
Wes
I'm trying to Make a criteria in a query. Pull today's date and the past 6
months of data.
What i have so far is..
=Date()-180
But this is not working.. ...
|
|
2 |
246 |
|
|
Date Criteria Range by
Wes
I'm trying to Make a criteria in a query. Pull today's date and the past 6
months of data.
What i have so far is..
=Date()-180
But this is not working.. ...
|
September 10th, 2009 12:54 PM
by Wes
|
0 |
110 |