|
|
Crosstab Query?-NOT BLANK by
efwerwerr
i want myspace....
"KARL DEWEY" wrote:
You can do it with multiple queries.
PMLogQuery-1
SELECT "X" AS x, Sum(1) AS
FROM TblPMLog
WHERE...
|
|
0 |
120 |
|
|
Annoying String Sorting Problem by
David M C
It seems Access isn't so clever at sorting strings. Each different type of
string requires a different sorting method. For instance, given a field,...
|
|
6 |
166 |
|
|
|
|
4 |
155 |
|
|
|
February 23rd, 2007 06:35 PM
by SandyR
|
3 |
143 |
|
|
Merging data - no duplicates by
Carlee
Hi,
I have two tables with Owner information in each. I want to create a single
data set, without duplicates.
Can anyone suggest an approach?
--
Carlee
|
|
1 |
140 |
|
|
counting visits by
Jackie L Preston
I have a patient visit table structured as Name, Date, VisitCode, Date1,
VisitCode1, ...Date6, VisitCode6 corresponding to the 7 days of the week.
Name is a...
|
|
3 |
121 |
|
|
Query criteria by
Jim Pockmire
I would like set criteria based on a value from a form, such that if the
value from the form is "1" a specific recordset is returned and if the value
is not...
|
|
3 |
138 |
|
|
Making a max query by
Enrique Rojas
Hello,
I am trying to make a query in which I just want to show the records
with the maximum values. It sounds so simple but my sql is a really
rusty when it...
|
|
4 |
190 |
|
|
|
|
5 |
158 |
|
|
|
|
9 |
140 |
|
|
|
|
1 |
91 |
|
|
|
February 23rd, 2007 03:36 PM
by Matt
|
1 |
124 |
|
|
Date Format by
Chris
Here at my shop we use peoplesoft and peoplesoft uses julian dates that look
like this: 107040. My question is if someone gave me a date in the format
of...
|
February 23rd, 2007 03:36 PM
by Chris
|
6 |
118 |
|
|
|
|
1 |
105 |
|
|
Error 3079 by
yorkielover02
I know that I need to include the table name but it won't let me back into
the query to include the table name that I am referring to.
|
|
0 |
125 |
|
|
IMPORT date from text file by
Lucio
I have a text file that contains a field of the type 'dd-mmm-yy'
When I import, it notices it is a date/time field
It does not load. It returns a conversion...
|
February 23rd, 2007 03:04 PM
by Dale Fye
|
1 |
118 |
|
|
Legth of all columns in db by
JR
I am trying to get a list of each column name in a particular table,
and the maximum data element within each of the columns. So if one
column had two...
|
|
4 |
125 |
|
|
Trace records through a table by
Mike4171
I have a table of checks. The PK on the table is the CheckNum field. The
table also has a column ReissuedCheckNum to indicate if the CheckNum was
reissued...
|
February 23rd, 2007 02:20 PM
by Mike4171
|
6 |
109 |
|
|
User interface via Net by
Matti Koski
Hi,
I would like to study of how to make an easy user interface via Net to
Access database. Please give your recommendation.
Matti
|
|
1 |
119 |
|
|
|
February 23rd, 2007 02:10 PM
by Robert T
|
0 |
101 |