|
|
Access 97 Query Advise by
John
Hi
I need to use a query as follows;
SELECT *
FROM (SELECT * From Table1 staff WHERE Table1.Field2 = "A") AS T1
WHERE T1.Field1 = "X"
The problem is that I...
( 1 2)
|
|
10 |
113 |
|
|
Access 97 Query Field Name Truncation by
Kevin Seerup
I am having a problem that only occurs on one PC.
On this PC, when one of the queries is run it complains
about a duplicate field name. In the query design...
|
|
3 |
408 |
|
|
|
August 6th, 2006 04:56 PM
by tina
|
3 |
106 |
|
|
|
|
6 |
157 |
|
|
|
|
0 |
72 |
|
|
Access 97 to Access 2002 conversion by
KK
Hi all,
I have an app in VB which contains Acc97 as backend. I need to convert this
to Acc2002.
I think there are some data type differences in the two...
|
|
3 |
128 |
|
|
Access 97 using a saved query in MS Query by
Eric
Hello all,
I am hoping someone can shead some light here. I am using the ODBC Client
Access driver to access some information from the iSeries. I have set up...
|
June 1st, 2005 09:52 PM
by Eric
|
0 |
195 |
|
|
|
May 17th, 2006 07:30 PM
by Mr B
|
0 |
56 |
|
|
Access a query without opening Access by
Tired and Confused
I have a db with several dozen queries. I need a non-technical person, who
is also not authorized to see all the info in the db, to run one query each...
|
January 10th, 2010 04:47 AM
by VWP1
|
3 |
223 |
|
|
Access a subform in a query by
Nigel
What is the sysntax to refer to a subform in the conditions statement of a
query I tried the following
!!.!
but that doesn't work
thanks
|
|
2 |
143 |
|
|
|
|
3 |
56 |
|
|
ACCESS ADDITION by
gambler
I have a number of fields in my query that i would like to add up and put
that total in my report. My friend said i would first have to write IIF
statements...
|
|
3 |
318 |
|
|
Access ADO parameter query by
michael971
I have a form with a text box and button and want to run an Access
query that takes an input parameter.
I have the following code for the button:
I get an...
|
|
1 |
98 |
|
|
|
July 29th, 2009 07:21 PM
by chrise
|
0 |
114 |
|
|
Access Advisor Summit (Miami) by
Dale Fye
Is anyone attending that Advisor Magazine Conference the week of 30 Sept - 4
Oct? If so, I'm looking for someone to share a ride (limo, cab, whatever)
from...
|
|
4 |
187 |
|
|
|
September 20th, 2005 12:57 PM
by iq
|
2 |
93 |
|
|
|
|
4 |
145 |
|
|
|
March 24th, 2009 10:58 PM
by Lucson
|
4 |
145 |
|
|
Access and ODBC Drivers by
TheBea
I just installed Office 2007. I have ODBC links to FoxPro 6.0. After I
installed 2007 my queries that are linked to Foxpro will fail in the design
mode if I...
|
July 10th, 2007 03:14 PM
by TheBea
|
0 |
57 |
|
|
Access and servers question by
Dupatt
I am getting resistance to using Access databases at work because some
people who I believe don't know what they are talking about. I am told that
when...
|
|
9 |
148 |