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 Reverse Sort Order / Thread Starter Last Post Replies Views
Date expressions by Robbie132
I would be grateful for some help in writing a date expression in a query and report (Access 2003). I need the query/report to display all records where the...
December 3rd, 2006 09:11 PM
by Robbie132 Go to last post
2 67
Date Expressions by Alicia[_3_]
Does anyone know how to make an expression pull dates that are greater that two months old? I'm looking at building a database that will allow me to track the...
December 10th, 2008 06:05 PM
by Golfinray Go to last post
2 53
Date Expressions & Calculations by Vylent Fyre[_2_]
Hello, everyone! :) It's me again.. *oh no!* Seriously, I'm having some issues with getting the dates and expressions I'm using to pull the right...
December 17th, 2007 11:44 PM
by Vylent Fyre[_2_] Go to last post
3 78
Date expressions that can exclude weekends by michelle
When using the expressions Date()-1 and - is there anyway I could get them to not count weekends? Date()-1 works well until I need it to show Fridays totals on...
February 14th, 2007 05:29 PM
by Jamie Collins Go to last post
1 182
Date Expressions/Criteria by V_Ernst
I am running a query and basing the results of that query on a Close Date field in one of my tables. I am using the normal expression for date range in my...
January 8th, 2009 06:14 PM
by Douglas J. Steele[_3_] Go to last post
1 87
date extraction by samuel
i have a value in a tbl - 2006022410503300 how do i convert this to a day of the week ?
February 27th, 2006 07:30 PM
by Jerry Whittle Go to last post
2 85
date Field by mccloud
I have a date field in a query pulling from our ERP system. I've used a between statement in the past to get the data I need. I now have a need to calculate...
January 27th, 2006 01:50 AM
by Rick Brandt Go to last post
1 109
DATE FIELD by angie
i have a query that consists of the following fields and corresponding criteria: 1) date field, criteria= between and 2) currency field, which stands for...
February 8th, 2006 01:53 PM
by John Spencer Go to last post
4 106
Date field by John
I need a date field in a digits form so for example 3/12/2004, I need to be 03122004. Does anyone have a formula or way already in a query to be able to take...
August 5th, 2004 05:41 PM
by Gassy Go to last post
3 128
Date field by horseman
I have Access 97. I am doing a database for someone. The database is for travelling allowances. He has a Field called serial no. in this field the serial...
May 18th, 2006 08:28 AM
by horseman Go to last post
2 71
date field - filtering by dls25
This is what I have in a date field: Between And Is there a way I can enter the date simpler, maybe by using the calender add-in, or an other way? When...
August 23rd, 2006 07:43 AM
by Allen Browne Go to last post
1 70
Date field - automation by [email protected]
Version 2002. How can I have the date field automatically adopt the date of the creation of the record? I've checked the help file but I'm either asking the...
December 4th, 2006 08:46 PM
by [email protected] Go to last post
3 66
date field by month in query but want only one year by Sue R via AccessMonster.com
I have a query that reads the date field by month and shows the results by each month for every year. I want it to display only the results from one year,...
February 16th, 2007 06:48 PM
by fredg Go to last post
1 199
date field calculation conditional on input from list box by Felicia R
I have a date field that is entered by user and a date field that needs to calculate a future date (3 mths or 12 mths) based on input from user from a drop...
October 20th, 2008 09:20 PM
by Dale Fye Go to last post
1 98
Date field in a query by PJ
I have two date fields and I need the number of days from one date to the other. My fields are and Date: . I want the number of days between the two. So...
March 11th, 2008 05:54 PM
by John Spencer Go to last post
2 81
Date field in query by klr
I need to add criteria to pull through all records where visit date is current month and next 2 months (i.e. 01.09.06 to 30.11.06). Can anyone advise what I...
September 29th, 2006 03:58 PM
by Jeff Boyce Go to last post
2 73
date field is Null but only if 2 other dates fields are not Null by JamieM
I have the following fields in a query: 2 months, 4 months, and 6 months. What I need to do in a query is to "filter" the 6 months field as Null but the 4...
April 17th, 2006 06:14 PM
by John Spencer Go to last post
5 94
Date Field problem by Lucien
I have a table that I am trying to pull data from in where the table has many fields. In one field my criteria is: In...
(Multi-page thread 1 2)
January 26th, 2006 06:33 PM
by John Spencer Go to last post
10 143
Date field problem by Yanick
I created an Access 97 database a year ago and it always worked fine. Since this morning, it does not work anymore. I received the error : This expression...
March 28th, 2007 01:10 AM
by Yanick Go to last post
2 67
date field question by Database User
is there a criteria that i can put in a query Date() - 1 Years or Date() - 2 Years or Date() - 1 month or Date() - 2 months
March 20th, 2006 04:00 PM
by Database User Go to last post
2 78
Post New Thread


Display Options
Showing threads 9881 to 9900 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 07:32 AM.


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