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
Return top record by Bren
I am tracking river levels for three rivers. I have set up a query to give me the latest reading for each river. However, it is giving me the first readings,...
May 28th, 2004 03:31 PM
by Bren Go to last post
2 396
Date Search by Shawn
I have a query and I would like to look up the record with the most current date. Is there a way to do this? Thanks in Advance Shawn
May 28th, 2004 04:13 PM
by Brian Camire Go to last post
1 404
Option group selection as query criteria by Tara
I'm pretty familiar with a lot of the basics of Access, but have never worked with an option group before. I have one on a data entry form and am using it for...
May 28th, 2004 04:18 PM
by Duane Hookom Go to last post
1 804
Select Query by Pago
Whenever I design a select query, I have to enter the parameter twice before the query runs. It seems like the first time I run the query after I saved the...
May 28th, 2004 04:56 PM
by Pago Go to last post
2 588
comparing two tables by ADAK
I would like to comparing two tables. The results to be a side by side comparisions of each record from the two dbs. If the record in db-1 does not have a...
May 28th, 2004 06:07 PM
by John Vinson Go to last post
1 512
Absolute value of a checkbox in a query by MarkD
Using Access 2000 I have a query based on a table with a bunch of check boxes. I want to sum the checkboxes based on a field then transfer that to an Excel...
May 28th, 2004 06:09 PM
by MarkD Go to last post
4 292
Log10 function by Andy
In Access 2000 there was a Log10 function, this seems to have disapeared in the 2002 version. The Log function in 2002 returns the Natural Log. Does anyone...
May 28th, 2004 07:49 PM
by Dan Artuso Go to last post
1 741
Creating a wildcard search for a form. by Peter Knight
Hello, I have a form called "Guest Search" where the user is asked to enter a guest name, which can appear in three different fields in a table. It is also...
May 28th, 2004 08:04 PM
by Peter Knight Go to last post
4 704
Insert contents of Col in one table into another table by Sandy
Hello: Is it possible in Access to insert the contents of a column from one table into another table? When I run a Sql statement, it pretends to be inserting...
May 28th, 2004 09:31 PM
by Sandy Go to last post
2 604
comparing multiple fields by Fish
I am trying to compare a database with a dept. and shift field to another database with that has the same two fields to see if they match. It will then return...
May 28th, 2004 10:00 PM
by Rick B Go to last post
1 366
Last functions in Total Row by Jordan
The way I understand these functions, they will return the last value entered chronologically from a group of records. So if I have a autonumber field in this...
May 28th, 2004 10:52 PM
by Douglas J. Steele Go to last post
5 271
Adding Up Hours by Jackie
I need to track the number of hours a student accumulates while taking various courses. These hours will then need to be added, by query, to produce a total...
May 28th, 2004 11:29 PM
by Jackie Go to last post
2 336
Multiple ranks per record based on different fields. by Looney
OK, I have a table of clients, the primary key is their FilerID, then Name, Address, City, State, Zip, and Volume. I need to rank their volume based on...
May 28th, 2004 11:31 PM
by Looney Go to last post
4 513
Union Select sorting by JR
I'm having trouble sorting a Union Select query. I would like to sort on a hidden field, but from what I've read in help the only 'order by' field that I can...
May 29th, 2004 02:12 AM
by Van T. Dinh Go to last post
2 326
Select vs update Query by Joyce
I'm trying to create a form that I can use to update individual records. I created a select querty to identify the record, but I can't seem to update the...
May 29th, 2004 02:19 AM
by Van T. Dinh Go to last post
1 649
What is wrong with this WHERE clause ? by David
WHERE CloseDate is not Null AND CloseDate Between "#" & Format$(varStart(), 'mm/dd/yyyy hh:nn:ss AM/PM') & "# And #" & Format$(varEnd(), 'mm/dd/yyyy hh:nn:ss...
May 29th, 2004 03:01 AM
by Van T. Dinh Go to last post
2 251
Query with multiple fields and one form by Evan McCutchen
Hello, I have a database that has a form "Bluebook" and a corresponding table "Bluebook". On the form, i have a button that says Query and when clicked, it...
May 29th, 2004 03:06 AM
by Van T. Dinh Go to last post
1 741
Query criteria doesnt use year input by Donna Brooks
I have created a query in my HR database to pull all employees due for their 90 day evaluation. Fields are as follows:...
May 29th, 2004 03:57 AM
by Van T. Dinh Go to last post
3 728
Using IIF to return a zero value for a null by Muraii
Hi, This is not so much a question as a sharing of something I've come across. It won't be earthshattering nor epiphanous, but it might prove helpful. I...
May 29th, 2004 04:06 AM
by Van T. Dinh Go to last post
2 486
Compare multiple fields in record by Can
I have 5 different date fields in a record, I need to compare them to see which date is the most current. Some fields may be null. I have a module, then I...
May 29th, 2004 04:27 AM
by Duane Hookom Go to last post
1 547
Post New Thread


Display Options
Showing threads 121 to 140 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 02:51 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.