|
|
Make table query won't run but Select will by
apex77
I am using Access 2007 and have created a query using several linked tables
from a different database using ODBC connection. When I run the query as a
SELECT...
|
|
3 |
214 |
|
|
Query for # character not working by
Dawn
To prepare data for an upload, we need to query for illegal characters such
as & ? \ within descriptions and other billing info. This has been successful
for...
|
September 15th, 2009 08:00 PM
by Dawn
|
2 |
127 |
|
|
Concatenate name fields by
DeanLinCPR
I have a 2007 DB with first and last name fields. I am trying to merge them
in a common field I know it is unusual. I have created a select query that...
|
|
2 |
174 |
|
|
Need "Like" Alpha Alpha Digit by
Bonnie A
Hi everyone! Using A02 on XP.
I need to pull records based upon the originator which is either 3 initials
(ABC) or a contract number (GP1234). I could say...
|
|
3 |
130 |
|
|
Previous two years compared, query by
Mary
I am wondering if there is a way to compare data from
August first of the previous year to the present date against
Everything before August first of the...
|
September 15th, 2009 05:11 PM
by Klatuu
|
1 |
124 |
|
|
|
|
4 |
164 |
|
|
Most recent date by
David[_55_]
what criteria can I use in MS Access in design view to only show the most
recent date when multiple dates are resulted? for example if a query results
in a...
|
September 15th, 2009 01:39 PM
by Dale Fye
|
2 |
144 |
|
|
|
September 15th, 2009 05:35 AM
by MGFoster
|
2 |
160 |
|
|
Need Help with Crosstab Query by
Accesshelp
Hello all,
I have the following 3 fields:
Student ID (Row Heading), School Year End (Column Heading) and Data (Value)
I create a crosstab query as indicated...
|
|
4 |
134 |
|
|
|
September 14th, 2009 11:49 PM
by LisaInAz
|
2 |
135 |
|
|
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...
( 1 2)
|
|
10 |
203 |
|
|
finding unique values by
buscher75
Hello, I have a table that holds records of part numbers and also where the
part is used. So, part A123 could be listed in multiple rows if it is used
on...
|
|
3 |
154 |
|
|
Query using two tables by
Melissa
I am trying to create a query with two tables; from one table I'm using the
fields EmpName, DateAbsentFrom (specifying a certain date range),
DateAbsentTo,...
|
September 14th, 2009 09:04 PM
by Melissa
|
8 |
154 |
|
|
|
|
6 |
182 |
|
|
Help with "Serialize" function in query by
Axel via AccessMonster.com
Hello,
I am using the Stephen Lebans / Peter Schoeders serialize function as line
counter in a query. Once I apply a criteria in the query, the line counter...
|
|
7 |
163 |
|
|
|
|
3 |
188 |
|
|
HELP!!! MY HEAD HURTS! by
Randy
Ok so here is the problem....I am using Access to track the keys we issue to
employees from request to issuance to return. I have the employee fill out an...
|
|
3 |
111 |
|
|
|
September 14th, 2009 07:18 PM
by Mike
|
7 |
220 |
|
|
Update Query ODBC --- call failed by
Lez[_6_]
Hi Guys,
I am trying to complete an update query, this is my SQL:
UPDATE dbo_PROD LEFT JOIN dbo_DS_SKU ON dbo_PROD. =
dbo_DS_SKU.SKU_code
SET...
( 1 2)
|
September 14th, 2009 07:10 PM
by Lez[_6_]
|
11 |
481 |
|
|
|
|
3 |
189 |