|
|
SQL help needed please by
cinnie
greetings gurus
I am having trouble with the syntax of a query I'm trying to write. Here is
the situation, simpified to its essence:
C:/DB/A.mdb has...
|
|
5 |
241 |
|
|
Modiify Records by
Carl_B[_2_]
I recall reading about limitations in Access regarding modifying records in a
form which is based upon a query of more than two tables. I have searched
for...
|
|
2 |
279 |
|
|
Tabbed Pages Not Refreshing by
PA
Access 2007, with two tables. Table A has field1 as the primary key field
Table B has field1(same as field1 in table A) and field2 as a dual primary
key. ...
|
|
1 |
208 |
|
|
Update Link Tables from Excel by
BlairH
I recently got an update from Office 97 to Office 2003. We're just slightly
behind the times.
Anyway, I had an access database in 97 that would link to an...
|
February 15th, 2010 06:57 PM
by BlairH
|
1 |
207 |
|
|
|
|
2 |
226 |
|
|
Year(Date()) not working by
johnlute
Access 2003 Win 2000.
SELECT tblCustomerComplaints.DateReceived
FROM tblCustomerComplaints
WHERE (((tblCustomerComplaints.DateReceived)=Year(Date())));
The...
|
February 15th, 2010 03:49 PM
by johnlute
|
9 |
280 |
|
|
|
February 15th, 2010 03:04 PM
by lmiller
|
0 |
189 |
|
|
|
|
1 |
233 |
|
|
COMBINING QUERIES INTO 1 by
lmiller
I have posted a similar question earlier today, I am trying to combine a
couple of queries into one. I keep getting a syntax error in the joined...
|
February 15th, 2010 02:07 PM
by lmiller
|
3 |
198 |
|
|
3 queries into 1 by
lmiller
Hello, I am going to try this again starting fresh from my other posts. I am
trying to develop an all inclusive query on our inventory. Each fical term
we...
|
February 15th, 2010 01:25 PM
by lmiller
|
8 |
248 |
|
|
combining queries into 1 by
lmiller
Daryl S,
Here is the query, I believe you suggested:
SELECT ., ., ., .,
nz(.,0)+nz(.,0) AS
FROM ( LEFT JOIN ON
. & .) LEFT
JOIN ON .=.;
|
February 15th, 2010 12:58 PM
by lmiller
|
8 |
171 |
|
|
|
|
2 |
218 |
|
|
UNION question by
terry w
lets say there is a union query like this;
SELECT tblP.* FROM tblP WHERE ...etc.
UNION
SELECT tblQ.* FROM tblQ WHERE ...etc.
UNION
SELECT tblR.* ...
|
|
3 |
244 |
|
|
'NOT IN' vs ' ALL' by
Sarah
greetings to all
An SQL fragment I use is... WHERE tblValues NOT IN (SELECT ...
The query runs properly. I have noticed that I can get the very same output...
|
February 14th, 2010 10:00 PM
by Sarah
|
4 |
167 |
|
|
Split address field by
Sandspur
I have an field that has one (1) or two (2) lines.
i need to split current field into two (2) fields
and
Thank you
|
|
3 |
181 |
|
|
|
|
1 |
174 |
|
|
getting max value by
John Spencer
SELECT TrainDetails.ch_TrainDetailsID_pk
, TrainDetails.ch_TrainDetailsID_fk
, TrainDetails.ch_CurrentYrNo
, TrainDetails.ch_CurrentWkNo
,...
|
|
2 |
190 |
|
|
|
|
4 |
175 |
|
|
External db in sql FROM by
Becky
I need help with some sql. What is the proper syntax for the following? I'm
in one database, but trying to get data from an external another one.
FROM...
|
|
4 |
214 |
|
|
Using a parameter by
PeterM
I have a form (FormA) which has a subform(FormB). One of the listboxes on
FormB uses a query using a field from FormB as part of the where statement.
I've...
|
|
2 |
154 |