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
Current Date, MTD, YTD, Last Year's MTD by Gina
Say I have a date (05/29/04). Using this date: How do I get the MTD date range (which should be 05/01/04 - 05/29/04)? How do I get the YTD date range (which...
May 29th, 2004 11:05 PM
by Duane Hookom Go to last post
3 620
Undefined function 'Date' in expression by Doug
I get the above error message when I use Date() in a query criteria to retrieve records. This used to work in access 97. I am very dependant on being able to...
May 29th, 2004 04:20 PM
by Douglas J. Steele Go to last post
2 628
sql view by charles osborne
Does anyone know why the SQL view may not be available to use for a table of form? I have read that you can get the SQL view by clicking on the view button...
May 29th, 2004 04:16 PM
by Joan Wild Go to last post
4 866
Expression (Checkbook) by Tom
Just like in a checkbook, I want to create a query that contains 1 field plus 1 expression: - Expenses (field) - Remaining Balance (expression) Naturally, I...
May 29th, 2004 02:38 PM
by Tom Go to last post
0 443
rounding making result of calculations look incorrect by Helen
Hi all, I've got a bound form on which some text boxes are populated by a query. Other textboxes contain calculations. The results from the calculations are...
May 29th, 2004 02:29 PM
by Wayne Morgan Go to last post
6 708
creating relations with sql by Jonas
Hi how can I create relations between tables with sql ? Regards Jonas
May 29th, 2004 01:48 PM
by Jonas Go to last post
2 427
Can Access make a transaction query? by Christina
Hi There, I am wondering if Access can do a transaction query like SQL server. For example, I'd like to insert records to serveral tables, if one insertion is...
May 29th, 2004 12:44 PM
by Gary Walter Go to last post
2 332
Query design - select fields always default to "group by" by Tripp Knightly
When designing queries (happen to be on ODBC tables) I'll select fields and then by default "Group By" is selected under the total / aggregation row. Is there...
May 29th, 2004 11:56 AM
by Gary Walter Go to last post
2 720
IsLoaded by Maureen
I have copied the IsLoaded module from the Northwind DB into my own DB. I have successfully used this code in a macro condition. Can I use the IsLoaded...
May 29th, 2004 04:28 AM
by Van T. Dinh Go to last post
1 324
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
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
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
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
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
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
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
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
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
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
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
Post New Thread


Display Options
Showing threads 43141 to 43160 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 11:04 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.