A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Running & Setting Up Queries Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
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...
May 27th, 2004 09:33 PM
by Ragnar Midtskogen Go to last post
1 723
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 Go to last post
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...
May 27th, 2004 08:25 PM
by John Vinson Go to last post
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...
May 27th, 2004 06:40 PM
by Michel Walsh Go to last post
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...
May 27th, 2004 05:08 PM
by Duane Hookom Go to last post
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 Go to last post
0 848
Help with query. Must have D and have either E>=2000 OR etc. by Sandy
Hello: I'm having trouble with a query wherein I need e.g., all rows returned that are not null in Col D AND have either E=2000 OR F=1 OR G=1 OR H=1. I keep...
May 27th, 2004 02:41 PM
by Sandy Go to last post
6 308
Filter by Form query will not populate fields by Brigitte P
I just converted from A97 to 2002. When a user runs a query, she was able in A97 to do a Filter by Form on the query, and the fields would populate with the...
May 27th, 2004 12:59 PM
by Brigitte P Go to last post
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...
May 27th, 2004 12:39 PM
by AmandaP Go to last post
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 Go to last post
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...
May 27th, 2004 11:33 AM
by Michel Walsh Go to last post
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...
May 27th, 2004 11:22 AM
by Michel Walsh Go to last post
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...
May 27th, 2004 07:54 AM
by Gary Walter Go to last post
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...
May 27th, 2004 07:29 AM
by Gary Walter Go to last post
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...
May 27th, 2004 04:49 AM
by Ken Snell Go to last post
1 445
Using Several Queries in a Calculated Field by Muraii
Hi there, A bit of background: I have 33 simple select queries, of the form recruit1 recruit2 recruit3
May 27th, 2004 03:00 AM
by Muraii Go to last post
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 Go to last post
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...
May 27th, 2004 12:30 AM
by Ken Snell Go to last post
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 ...
May 26th, 2004 11:59 PM
by Ted Allen Go to last post
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 Go to last post
3 933
Post New Thread


Display Options
Showing threads 43181 to 43200 of 43289
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:26 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.