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
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
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
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
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
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
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
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
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
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 724
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...
May 27th, 2004 10:11 PM
by Gerald Stanley Go to last post
5 307
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 Go to last post
1 389
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...
May 28th, 2004 01:16 AM
by Cheryl Fischer Go to last post
5 457
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 Go to last post
3 668
Query List Doesn't Display by [email protected]
Hello out there! Presently I am using Windows XP with MS Access 2002. My situation is that after Access opens, the system does not display the list of...
May 28th, 2004 07:06 AM
by John Vinson Go to last post
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 Go to last post
3 342
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....
May 28th, 2004 12:36 PM
by Gary Walter Go to last post
4 549
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...
May 28th, 2004 12:46 PM
by Gary Walter Go to last post
3 648
Text field causing trouble in query (continued) by KaiRich
Hi, This is a continuation of a post a few days ago. Apologies about the time lag, but the question is from a contract I am working on only 1 day per week,...
May 28th, 2004 01:03 PM
by Gary Walter Go to last post
2 965
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...
May 28th, 2004 03:12 PM
by Cheryl Fischer Go to last post
2 1,301
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 Go to last post
2 984
Post New Thread


Display Options
Showing threads 101 to 120 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 03: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.