|
|
"if -- then" criteria in querys. by
crossofG
I have a data base that contains family information (address, phone, family last name) and then is related to individuals of that family (first name, last name...
|
July 21st, 2004 04:43 PM
by Mike
|
1 |
137 |
|
|
|
|
2 |
187 |
|
|
"IF" expression in a query by
Duncan Edment
I have a query that returns the Annual Leave days recorded for a specific
employee. This query is as follows:
SELECT tblEmp.EmpFname, tblEmp.EmpLname,...
|
|
1 |
428 |
|
|
"Init: Left([Firstname],1)" in Access Qry by
DFA
I need to take first letter of Firstname to provide Initial to add to
Surname. Have entered above in the field row of a query which has Firstname.
Have tried...
|
|
2 |
110 |
|
|
|
|
3 |
126 |
|
|
|
|
8 |
259 |
|
|
|
September 9th, 2004 07:10 PM
by Jeff
|
2 |
670 |
|
|
"Invalid SQL Statement" message from union query by
Alison Downing via AccessMonster.com
Hi there,
I've read the Access help files on union queries and trawled the threads on
the forum but I'm still stuck and hoping someone can help me out. ...
|
|
2 |
242 |
|
|
"Less Than" Query Problem by
JTF
I have a form that contains a drop down list, from which the user can
select a "period" - from 1-13.
I have two update queries that I need to run based on...
|
August 18th, 2005 05:43 PM
by JTF
|
3 |
101 |
|
|
"Like" operator in a query by
genojoe
In "SQL Server Compatible Syntax" setting in Options dialog; Table/Queries
tab, I do not check "This database".
In this database the following query returns...
|
|
1 |
118 |
|
|
"LIKE" query problem... by
AlexT
Folks
I'm having a rather strange problem with a query to an Access file
from Excel.
My query looks like
SELECT qLookups.lkSubkey, qLookups.lkValue FROM...
|
July 8th, 2005 12:38 PM
by AlexT
|
2 |
94 |
|
|
"Minus" keyword by
Earl Takasaki
I can't seem to get the MINUS keyword to work in Access SQL view. Is this a
limitation of using the SQL View to create a query? If so, what other keyword
do...
|
|
3 |
179 |
|
|
"not enough space on the temp disk" by
Jazz
Access query fails saying out of temp space
running a query that will create an Excel spreadsheet of 17,000 lines or so.
However, after about 20 minutes, it...
|
August 19th, 2005 03:56 PM
by Jazz
|
1 |
163 |
|
|
"NOT" criteria by
Liz Hansen
Hello,
I need to compare two tables. When compared, if an employeeID is missing
from the tblDemographics, it should be added using an append query. ...
|
September 13th, 2004 09:48 PM
by JL
|
2 |
90 |
|
|
"Null" by
DBC
when a numerical query returns empty how do you make it show as 0?
|
August 26th, 2004 12:44 PM
by
|
4 |
129 |
|
|
"nz,0" by
Todd
I'm using Access 2.0. The query I'm writing requires the
sum of 2 fields. If I use the "nz,0" command to make sure
the fields add up even if one of the...
|
|
1 |
97 |
|
|
|
May 10th, 2005 07:30 PM
by Ofer
|
1 |
137 |
|
|
|
|
1 |
330 |
|
|
"Overflow" by
Art
I get an "overflow" message when running an Access Query, what does it mean?
and what do I need to do?
Thank you
|
|
1 |
171 |
|
|
"pivoting" data with a querry by
jay
All,
I've got a table as follows:
I need to generate a combo-box listing each of the five suppliers for an
Item Number. I've considered...
|
August 24th, 2005 12:56 AM
by jay
|
4 |
144 |