|
|
How to calculate a period of time by
AmandaP
Hi, I really need some help on this one, I cannot seem to
be able to get it right.
I have this query which returns dates when an inspection
is due called . I...
|
|
2 |
310 |
|
|
|
|
2 |
956 |
|
|
|
May 27th, 2004 02:41 PM
by Sandy
|
6 |
329 |
|
|
Problem with pass-through insert query by
Karen
I am trying to run this pass-through insert query but
everytime I try I keep getting ODBC connection Failed and
then when I click OK I get an Oracle error ...
|
May 27th, 2004 04:40 PM
by Karen
|
0 |
877 |
|
|
Count of contents in field by
hermie
In my table I have 20 field which can contains a value from A to F or Blank
In a query I want to count the total of the fields for instance:
Field1 = A
Field2...
|
|
6 |
493 |
|
|
Activation on a New Computer by
I have Microsoft Office XP Standard, Version 2002 that I
bought separately.
I bought a third computer and I want to activate this
product so I can use Excel...
|
|
1 |
359 |
|
|
Query is too complex by
Mike
Hi, I am a relative amateur at this. I have 5 queries
each of which relies on the one before for a number.
query5 looks up a field in query4, query4 looks up...
|
|
3 |
650 |
|
|
Update Query Question by
Edward
Hello. I have a table where I want to change the data in a specific field based on what that field contains using another table as a cross reference.
I could...
|
May 27th, 2004 09:26 PM
by edward
|
4 |
306 |
|
|
pass through parameter query into Oracle by
teri
I'm trying to do an interactive parameter pass through query into an Oracle 8i database. The following query works all day long with the ACCOUNTNO hardcoded in...
|
|
1 |
779 |
|
|
Query help by
Steve
Hello,
I have imported a databae into access. Essentially I have
a database of names and addresses. all of the names in
the databae have multiple records with...
|
|
5 |
308 |
|
|
Taking the Top Three by
Frank
I have a query that prints out all individuals and the amount of footage they produced for a given date range. I would like it to print out just the top three....
|
May 28th, 2004 12:33 AM
by Mark D
|
1 |
390 |
|
|
Most Recent Date by
Michael Noblet
I have a linked table that has 3 fields.
fldName
fldHours
fldDate
This table is poulated by and external program designed to
give hours of usage by month and...
|
|
5 |
478 |
|
|
Format for phone number by
Sandy
Hello:
I have a table with a phone column having a 999999-9999 format.
I need (999)999-9999 or at least even a 999 999-9999.
Any help will be greatly...
|
May 28th, 2004 01:31 AM
by Sandy
|
3 |
689 |
|
|
|
|
1 |
366 |
|
|
IIF Limitation by
JA
I am using IIF statement to specify weeks as shown below.
Unfortunately it does not allow me to go beyond 13 weeks.
How can I overcome this...
|
May 28th, 2004 11:46 AM
by Dann
|
3 |
343 |
|
|
What's wrong with this query? by
Craig
SELECT ,
SWITCH(=,2,TRUE,1) AS Expr1
FROM
qry_Detail_Transactions
LEFT JOIN
qry_OpeningBalance_ClearDate
ON
qry_Detail_Transactions....
|
|
4 |
590 |
|
|
Importing Query results to Excel by
ChuckW
Hi,
I am running a query and would like the results to
populate certain cells in an excel spreadsheet. Is there
a way to have a field in my query be sent to a...
|
|
3 |
656 |
|
|
|
|
2 |
996 |
|
|
field manipulation by
Steve
Hello,
I have a mailing list i created in access from an
external file. I am trying to figure out how to create a
new field from part of the data in another...
|
|
2 |
1,337 |
|
|
Hold it, we found SQL view.... by
1.156
Fred, we now can see the code -- don't know how we didn't run into it
earlier.
The SQL code looks understandable for the original simple query with no
drop...
|
May 28th, 2004 03:20 PM
by 1.156
|
2 |
1,008 |