|
|
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 |
724 |
|
|
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 |
|
|
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 |
636 |
|
|
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 |
|
|
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 |
487 |
|
|
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 |
848 |
|
|
|
May 27th, 2004 02:41 PM
by Sandy
|
6 |
308 |
|
|
|
|
2 |
921 |
|
|
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 |
290 |
|
|
Joining Queries: Problem by
Tom
Hi all,
I am trying to join two queries together, but the join is
on a normal field in one query to a calculated field in
another. The join is working fine,...
|
May 27th, 2004 11:54 AM
by Tom
|
0 |
505 |
|
|
Adding new record to query by
Roy Goldhammer
Hello there
I have table of citys with two fields
CityID autonumber, city text(20)
I've bilt the current query for adding new city:
PARAMETERS prmCity...
|
|
1 |
312 |
|
|
COMPARE THE TWO TABLES by
Rick
PLEASE HELP!!!
I HAVE TWO TABLES WITH THE SAME FIELDS, BUT TWO DIFFERENT
SOURCES. ONE IS MY BROTHER'S ADDRESS BOOK AND ONE IS MY
MOTHER'S BOTH TABLES HAVE...
|
|
3 |
462 |
|
|
Using a custom function in a query by
BobRoyAce
Let's say I have a function in a global module called
GetNames (which returns something like 'ARM','CAT') and I
want to run a query like the following:
SELECT...
|
|
5 |
681 |
|
|
Un matched query on more than one field by
Mary
Gary, Thank you so much, it worked beautifully. I had
fiddled around in SQL but didn't really know what I was
doing. Your reply helped me understand a bit...
|
|
1 |
317 |
|
|
Subtract in the same field by
Jenna
How can I subtract the first row data to second row data
within a column, for example: I have this columns
Effective Date
5/1/04
5/3/04
5/4/03
I want to...
|
|
1 |
445 |
|
|
|
May 27th, 2004 03:00 AM
by Muraii
|
3 |
362 |
|
|
Multiple Drop Down by
Dennis
I have a combo box that displays three related pieces of
data. Grade1, Grade2 and Rate. I update the Rate field in
my form with this combo box. What I would...
|
May 27th, 2004 01:52 AM
by Dennis
|
2 |
322 |
|
|
Updating 2 tables with 1 form - Access 2003 by
Linger1974
Hello,
I'm using Access 2003 with an Access 2000 database. I've got 1 form which is correctly pulling data from 2 tables. I'm having problems updating both...
|
|
4 |
863 |
|
|
Criteria for make table Query by
Allison
I would like to use the Nz()function but your suggestion
below is not working??? Here are the names of each field
in my make table query.
DIFF1: -
tblIMPACT ...
|
|
3 |
546 |
|
|
Newbie: Using Left in query for report? by
Ed
A co-worker and I are muddling our way through Access to try and build a
report. I do Word, Excel, and VBA, and have tied myself in knots with
Access before;...
|
May 26th, 2004 11:26 PM
by Ed
|
3 |
933 |