|
|
For Klatuu by
Gerard
You sent me this code:
Public Function GetLetters(strBookCode As String) As String
Dim lngCtr As Long
Const conAlphabet As String =...
|
|
9 |
139 |
|
|
Data From Multiple Records by
Novice2000
Hi,
We receive an excel workbook of information from an outside source. Within
this table the customer may have several record lines assigned to their...
|
|
0 |
62 |
|
|
|
September 28th, 2006 04:11 PM
by Warrio
|
1 |
77 |
|
|
Wildcards by
Kerry Purdy
Hi
I have created a query from form, I am able to use the * wildcard if I wish
so all is well so far.
What I would like to do is have the * as the default...
|
|
5 |
87 |
|
|
Query Criteria by
Tara
I'm hoping someone can help me with this. I have a table that holds basic
contact information as well as what part of our organization the person is a
part...
|
September 28th, 2006 04:31 PM
by Tara
|
0 |
55 |
|
|
Part query, null query by
Dreamstar_1961
been trying to work out how to do this I've worked out the part query, but
trying to work out the null section, this query is running from a form, with
a...
|
|
1 |
65 |
|
|
Query corrupts itself... by
centre21
Perhaps someone has seen this - I have a client who uses MS Access to
keep track of vendors and booths for trade shows. What happens is that
the data in the...
|
September 28th, 2006 05:15 PM
by centre21
|
5 |
82 |
|
|
Access 2003 Transform Queries?? by
news.microsoft.com
Hi all,
I'm trying to create a transform query with VB6, ADO 2.8 and Access 2003.
I'm basically
doing the following:
'Create catalog connection
Set...
|
|
9 |
104 |
|
|
Queries after migration by
Krutika
I'm trying to migrate the following queries to T-SQL for SQL Server 2005, but
getting errors.
SELECT
tblCurrent.AutoNumber,
tblCurrent.TaxYear,...
|
September 28th, 2006 05:37 PM
by Krutika
|
0 |
51 |
|
|
Retreive Only the Y results in a query by
TKM
My results without the Y look like this..Notice there is no N in that column
and it is either Y or nothing in the BYPASS Column it only has the Y. In the...
|
|
3 |
63 |
|
|
Null to Zero in Crosstab Query by
Alan
Can anyone explain how to convert Null values to Zero in the Value field in a
Crosstab Query? I know how to use the Nz function but I don't know where to
use...
|
|
1 |
74 |
|
|
Singular by
Tracy McClarnon
Hello,
Is this possible in Access 97?
DELETE *
FROM Offers AS A
WHERE Not Singular (Select 1 From As B Where ((B. =
A.) AND
...
|
|
1 |
60 |
|
|
|
|
1 |
100 |
|
|
|
|
2 |
83 |
|
|
Relating data in 2 fields by
I''ve a feeling I''m not in Unix Anymore
In my query I am trying to relate a PRStaff field containing an alpha list of
names and a DayNum field containing the numeric value of the days of a
selected...
|
|
4 |
94 |
|
|
Criteria in multi table update query by
jenngreff via AccessMonster.com
I am trying to created an update query that will update all nulls for 2
fields in 1 table when the project # in both tables is equal. So far the sql
view of...
|
|
1 |
58 |
|
|
|
|
1 |
57 |
|
|
Union Query WHERE clause by
ALEX
I'm trying to create a union query with the following SQL. I keep getting a
parameter prompt for all the fields in the WHERE clause except for Model,
which...
|
September 28th, 2006 08:50 PM
by ALEX
|
4 |
62 |
|
|
Count Expression by
Alexandra504
I have several fields in a querry. These fiels have either 'Yes' or 'No'
values. I need an expression that counts all the 'yes' in the previous
fields.
|
|
3 |
62 |
|
|
Query ability by
Tami
Does a query ONLY pull from tables & other querys? Is it possible for the
query to request a beginning date from the user & use that information to
list the...
|
|
2 |
92 |