|
|
Text To Columns in Access by
Ernie Sersen
Does Access have a Text-To-Columns function like Excel?
I have a field in access that contains AAA-BBBB-CCC-DDDD or
AAAA-BBB-CCCC-DDD. I need to be able to...
( 1 2)
|
|
18 |
354 |
|
|
Query sort not working after NULL column by
mscertified
I have a query that has an order by e.g.
ORDER BY A,B,C,D,E
For this particular subset of data, columns A, B and C are all the same,
column D is NULL in each...
( 1 2)
|
|
18 |
211 |
|
|
Parameters problem in Query by
Lisa
I have a query that creates a crosstab query. I want to be able to use the
parameter between (date) and (Date), however it will not allow me to the
query...
( 1 2)
|
March 26th, 2008 08:51 PM
by Lisa
|
18 |
208 |
|
|
Random Selection by
FrankM
I have a Table (Q1) with several fields (Site, Rep, Cust, ID, Prod, Serv,
Date, Act). I need to randomly make a couple of selections. There are three
"Prod"...
( 1 2)
|
April 4th, 2008 03:45 PM
by FrankM
|
18 |
243 |
|
|
Query for Left(String,5) - Access 2007 by
JohnH
I found this response in a post regarding a query I'm trying to do. It looks
like it's what I need but I don't know how/were to implement it in the...
( 1 2)
|
May 1st, 2008 10:36 PM
by JohnH
|
18 |
222 |
|
|
Case or IIF? by
NBullock
Might there be a better way? I am trying to pull text from a field in one
table and then assign those records to that result. For example, if the
printer...
( 1 2)
|
|
18 |
322 |
|
|
|
|
18 |
181 |
|
|
|
February 6th, 2009 11:27 PM
by Jon M
|
18 |
209 |
|
|
SQL - Query count not working by
QB
Hello,
I have a first query which creates a base list from which I then base a
second query (the one I'm having trouble with) which does a basic count which...
( 1 2)
|
|
18 |
207 |
|
|
|
|
18 |
309 |
|
|
Matching Dates by
ashg657
Ok guys fairly complicated one here...
I have a single table with 20,000 transactions within it. Each transaction
has a date attached to it.
I have another...
( 1 2)
|
|
18 |
216 |
|
|
Query SQL not working.. by
Zack Barresse
Hello everyone, working with a database where I'm trying to produce a query
that will list all records that meet a certain condition. Here is my...
( 1 2)
|
|
18 |
125 |
|
|
Vacation Query by
Julie
What I need to figure out now is how to get a query to look at their
anniversary date and add in what amount they get awarded and also to deduct
what they...
( 1 2)
|
|
18 |
190 |
|
|
Design View by
BBran
Hello,
I am using Access 2007 B2T2. I am trying to open a query in design view but get an error. The same query opens fine in design view in Access...
( 1 2)
|
January 4th, 2007 06:50 PM
by BBran
|
18 |
232 |
|
|
Why can't I update this query by
BruceM
This is the SQL for a query that cannot be updated:
SELECT tblPO.*, tblVendor.*, tblPhone.Phone, tblPhone.MainPhone
FROM (tblVendor INNER JOIN tblPO ON...
( 1 2)
|
December 11th, 2006 01:35 PM
by BruceM
|
18 |
181 |
|
|
|
|
18 |
380 |
|
|
Trim Data by
Finger Tips
I know this may be answered somewhere but I am new at this and need very
specific steps. Screen shots also help.
I am running a query. In one of the fields...
( 1 2)
|
|
18 |
217 |
|
|
Query Not Working by
CT[_2_]
Hello,
I have set up a query for 1 table.
The field I'm trying to run the query on is a text field. I enter a name
(="smith, john") I get zero results. ...
( 1 2)
|
|
18 |
184 |
|
|
Return to form if query unmatched by
Richard
I have this query.
SELECT BOOKS.Number
FROM BOOKS
WHERE (((BOOKS.Number)=))
GROUP BY BOOKS.Number
ORDER BY BOOKS.Number DESC;
What I want to do now is if...
( 1 2)
|
June 18th, 2007 09:02 AM
by Kozaw
|
18 |
152 |
|
|
|
September 29th, 2009 04:47 PM
by Erick C
|
18 |
312 |