|
|
|
|
1 |
240 |
|
|
DLookUp criteria help - involved one! by
Teri
I have a report based on a crosstab query. It queries the results of ad sales by sales reps. Sales Reps is a row heading and the Issue is a column heading. ...
|
June 4th, 2004 12:11 AM
by Teri
|
1 |
522 |
|
|
Carriage Returns - remove by
Phil Jones
Hey Guys,
Anyone know how I can check for carriage rerurns in a memo field and if
thier are any strip them out?
I am only a basic user of access and use the...
|
June 4th, 2004 12:38 AM
by fredg
|
1 |
127 |
|
|
access 2000 odbc in asp by
David
this is going to drive me to drink...again, could someone put thier evil eye
on this query and let me know what is wrong.
trackingnumber =...
|
|
5 |
197 |
|
|
Operation must use an updatable query by
EyeSpec
Query will not run I get the error: "Operation must use
an updatable query"
UPDATE PHSCO_Elig INNER JOIN dbo_Tbl_Co_Refraction_Plans
ON PHSCO_Elig. =...
|
|
3 |
433 |
|
|
String Sort / Unicode problem by
Mr Sir
Hi Folks,
I'm sorting a bunch of codes in Access2000 that are stored in a text
field and contain a good number of dashes (-). As I understand it Unicode
data...
|
June 4th, 2004 04:25 AM
by Mr Sir
|
2 |
409 |
|
|
|
June 4th, 2004 06:21 AM
by Rick
|
2 |
169 |
|
|
|
|
1 |
144 |
|
|
Get Result 1 Stdev Away From Mean by
Amande Strode
The following is what I have managed to put together so far, but it doesn't seem to quite work, It generates a list of all users of certain equipment and some...
|
|
1 |
289 |
|
|
Problem with IIF Statement by
Confused
Hi,
I currently have a query with a list of calls from a call
log database. Within this query i have LocationDesc and
Practice. I want to group the...
|
June 4th, 2004 02:56 PM
by Rob
|
2 |
497 |
|
|
Filtering last 24 hours Records by
Craig Fellows
Hello,
I have a query that collects data based upon date and
time. I can drop the date element if I can always obtain
the last 24 hours worth of records.
Our...
|
|
3 |
386 |
|
|
Showing only non matching items by
CD Tom
This is probably very simple but I can't figure it out. I want to create a query that will show only the items that don't match between two tables. Thanks...
|
June 4th, 2004 03:24 PM
by JulieD
|
1 |
184 |
|
|
Converting zero to Null value by
gal
Hi group,
I have a field that has numbers includig zeroes(0). How
can I covert the zeroes to NUll( blank to be displayed).
Thanks group
|
June 4th, 2004 04:05 PM
by Matt
|
1 |
118 |
|
|
Create Table Statement by
nagesh
Hi all
i am getting Problem with default word in Create Table
statement
Create Table test2
(Id autoincrement,
name text(255) ,
age int not null default...
|
|
1 |
196 |
|
|
|
|
1 |
388 |
|
|
|
June 4th, 2004 04:27 PM
by
|
2 |
338 |
|
|
urgent help for build sql statement in vba by
terry
My assignment's due date is approaching. I'm nervous now!
How can I build this sql statement in a function:
SELECT LAST(fieldName)
FROM (SELECT TOP p PERCENT...
|
|
1 |
569 |
|
|
|
June 4th, 2004 05:16 PM
by SMac
|
2 |
628 |
|
|
Find Max Values and Return Null Value Too by
Josiah
I'm trying to create a query that will find the maximum value for a field and if that field is null it will still display the record but the max will be blank....
|
|
1 |
426 |
|
|
circular reference error message... by
Jacqueline
In my Access 2000 mdb I am trying to create a report that
must choose the correct mailing address to send the
letter to...
The database holds 3 sets of mailing...
|
|
2 |
287 |