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
The Query Grid Disappeared by Cyndi
The query grid will not display - only the field list. How can I fix? Thanks.
August 31st, 2004 02:30 PM
by Joan Wild Go to last post
2 123
PASS THROUGH QUERY WITH ORACLE BACK END by nique
Hello, having problems using the pass through query to pull data off of an oracle back end. I have created an odbc user data source but I still get an error...
August 31st, 2004 04:09 PM
by Lynn Trapp Go to last post
7 216
How do I limit the number of records in a query. by rnprice
If I have a query that is combining information from two or more tables, one of which has a date field, and I want to limit the query to the most current 20...
August 31st, 2004 04:27 PM
by rnprice Go to last post
2 380
Make Table Query??? by [email protected]
I have several tables, each being a month's worth of data. I need to be able to produce a report spanning a 6 month period, with the user being able to chose...
August 31st, 2004 04:29 PM
by Lynn Trapp Go to last post
1 162
Mtd Question by CR
I have a built queries to give me monthly totals, but the problem is that by using Month(Now()), I get the current month when it is the 1st day of the month...
August 31st, 2004 05:11 PM
by Crown Royal Go to last post
4 185
Autonumber in a query by Fabio
How can I include an autonumber in a field of a query ? Or hoe can I select just the 5 first records of my query?
August 31st, 2004 05:29 PM
by Fabio Go to last post
2 158
criteria for an empty date by June
Hi, History: In my database I fill in a record for a product but not the date field until the product is completed. My reports will not show this...
August 31st, 2004 05:51 PM
by June Go to last post
3 185
Query to delete records by Jk
Hello, I had placed a posting on design group to clean out my 50 test records from my tables so i could get a fresh start on my new database.The response was...
August 31st, 2004 07:10 PM
by Duane Hookom Go to last post
1 296
Select Criteria in a Query by Adding Selected Range into Query
I was wondering if it were possible to add the select criteria into a field in the query. Example: when I run a query that pulls information based on a date...
August 31st, 2004 07:12 PM
by Duane Hookom Go to last post
1 145
Using LookUp tables in sql query,need help by Julia
Hi, I need help with the following query, I have two LookUp tables: Cities Id Name 1 USA 2 UK
August 31st, 2004 07:32 PM
by JG316 Go to last post
7 183
Trim() function not working? by Will
I have the expression: IIf(=Null Or Len(Trim())=Null,"This Manufacturer is not in the system"," ") in an Access2000 report. It's always worked (for over 2...
August 31st, 2004 07:39 PM
by Will Go to last post
2 334
setting "date" criteria by Jeff G
When I set a criteria in a query "between and " to prompt for dates "a" and "b" and then type in "8/16/04" for "a" and "8/31/04" for "b" when prompted, I...
August 31st, 2004 09:30 PM
by Jeff G Go to last post
2 387
MakeTable QRY output (need zero's) by Maxwell
Hello, I am having difficulty with the following...Hope you can follow what I did.... Created a 'MakeTable' query from a Crosstab query to give me sales for...
August 31st, 2004 09:40 PM
by Douglas J. Steele Go to last post
1 168
SQL view of messed up action queries by Kendra
I really appreciate your kindness in helping me out. Here is the SQL for the action queries (if it clarifies things): SQL of append query...
August 31st, 2004 09:53 PM
by John Spencer (MVP) Go to last post
2 1,914
more important---meant to include in last post--part of the same by Josh Henry
in that same SQL query i just provided, how would i go about asking the query to sort on the tenants last name? UNION Select Tenants.OccFNAme &...
August 31st, 2004 10:06 PM
by John Spencer (MVP) Go to last post
1 188
Create a "running total" field in a query in Access so I can use . by rhingomills
I am trying to create a running total in an Access query. An example would be to have a table that I entered Date, Time, Buy or Sell, Price, and Shares for...
August 31st, 2004 10:10 PM
by Michel Walsh Go to last post
1 527
Ranking by Richardson
I have a query with a member listing. They have all previously been assigned scores which are integer values ranging from 1-1200 but they are not sesquential...
August 31st, 2004 10:31 PM
by Tonín Go to last post
3 144
Comparison query by Su Cooper
Hi, I'm new to queries and I'm trying to work out (without success) how to do the following. I have two tables: tbl1 (the key of which is employeeID) tbl2...
August 31st, 2004 10:33 PM
by Gerald Stanley Go to last post
2 125
Access "behind the scenes" by Tcs
Is there any way to see what Access is REALLY doing, "behind the scenes" so to speak? I need help with translating what Access is doing, so I get it to...
August 31st, 2004 11:41 PM
by MGFoster Go to last post
1 114
Update query based on different conditions by Vincdc
Hello: I have 3 queries and 1 table (ID as primary key). Is there any way that a update query can deal with 3 conditions and update "Status"? if a.ID=b.ID,...
August 31st, 2004 11:54 PM
by MGFoster Go to last post
1 120
Post New Thread


Display Options
Showing threads 2001 to 2020 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 09:07 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.