|
|
|
|
1 |
129 |
|
|
|
|
2 |
107 |
|
|
Query Combobox Problems by
UnderSeven
This is the code of my query:
SELECT Table.Column
FROM Table INNER JOIN Othertable ON Table.Column = Othertable.Column
WHERE (((Table.Column)=!!.))
ORDER BY...
|
|
2 |
108 |
|
|
CONVERSION DATE PROBLEM by
Lucio
I have a txt file where the field is of the format 'dd-mmm-yy'. For example
04-MAY-04
When I import the file, it automatically detects that the field should...
|
|
1 |
120 |
|
|
non-match query by
johnny vino
I'm comparing two tables and I would like to see all the records where first
and last name DON'T match. I know there are several instances where names...
|
|
6 |
130 |
|
|
Query OVERFLOW Error by
John D
I've tried as best I can to follow suggestions in this forum about "fixing"
the Overflow error I'm getting in my query, but so far no good.
I have a table of...
|
|
6 |
173 |
|
|
Weighted Averages by
Casa
Hello everyone;
I have a query which links drilling sample intervals and geochemical
results. I would like to average these results so that I highlight...
|
February 23rd, 2007 01:28 AM
by Smartin
|
1 |
136 |
|
|
Calculating expressions between two dates by
JCowell
(!) Between Date()-14 And Date()-8
I'm using the above statement as a criteria in a Query. It is not working
and I'm getting errors.
What I want to do is...
|
|
2 |
105 |
|
|
Append Queries by
ray
I have an Append query that counts members.
I have a table preset with a 0 count.
If my append query finds no records, it deletes the row in the table with...
|
February 23rd, 2007 12:57 AM
by ray
|
4 |
115 |
|
|
Query help by
Bec_FS
I have run a query, but it took me multiple steps to get the answer I wanted.
I was wondering if there was a way I could of gotten the answer in one
simple...
|
February 23rd, 2007 12:41 AM
by Dale Fye
|
3 |
103 |
|
|
IMPORT date from text file by
Lucio
I have a text file that contains a field of the type 'dd-mmm-yy'
When I import, it notices it is a date/time field
It does not load. It returns a conversion...
|
February 22nd, 2007 11:39 PM
by Lucio
|
0 |
86 |
|
|
Excluding by
gmore
Hello,
I've got a table containing suppliers (two fields: supplier_code and
supplier_name) and another one containing suppliers' codes to exclude from...
|
February 22nd, 2007 11:30 PM
by gmore
|
2 |
101 |
|
|
Searching mdbs for queries by
Harry V
Is there a way to search mdb files for query names from Windows Explorer?
--
Harry E Vermillion
IT2
Division of Wildlife
State of Colorado
|
|
3 |
151 |
|
|
iif statement in query by
Joel Allen
Hello,
I'm trying to use an "OR" in this iif statement and it's not working. Can
somebody please help?
My goal is: if ProductResultBDHC contains C or P,...
|
|
4 |
159 |
|
|
Subqueries and ranking by
Gina K
I'm ranking records in a query, but I'm having a little trouble getting the
ties to display the way I want.
Here's the sql:
SELECT tblEventResults.fkAthlete,...
|
February 22nd, 2007 10:01 PM
by Gina K
|
3 |
104 |
|
|
parameter message by
Alan
Hi folks,
In my query, I created a field to pass a value into to use for a calculation
elsewhere. Everything works fine but when you run the query, it comes...
|
February 22nd, 2007 09:59 PM
by Alan
|
2 |
129 |
|
|
|
|
2 |
117 |
|
|
crosstab query and main table by
doran_doran
Here is the db with sample data.
http://download.yousendit.com/AAA18BC7520F196E
I want to use qryCrosstab and table "ALL" to achieve the result that...
|
|
3 |
152 |
|
|
Format the query results by
Caledonia
I'm currently using Access 2k; I probably was using an earlier version at my
last job. I thought that I used to be able to click on the field properties
in...
|
|
2 |
114 |
|
|
Update Query Question Need Help by
totallyconfused
I have an update query that I use to update a table with data from another
table. However, my "Finish" table is a checkbox (0 and -1). When I run the
query...
|
|
6 |
128 |