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 Query by PPerry
I have a query (thanks to this group) which works like a charm. This query finds the last date for an event. I now want to produce a report which displays this...
June 5th, 2004 03:01 PM
by PPerry Go to last post
2 289
Date query by snappl3
I need to get a query to pull from my database any date 6 months or less into the future (ex. The query would pull up any orders which have a date of 10/2/08...
April 2nd, 2008 07:57 PM
by fredg Go to last post
3 67
Date query by hem
Hi! I would like to know how to incorporate a criteria or code in a query that checks the date field if its already been =3months from the present date to a...
September 22nd, 2008 07:49 AM
by hem Go to last post
2 54
Date Query by DSmith
I know in the criteria of a birth field I can use 7/??/?? to find everyone born in July. Is there something I can do to find everyone born in July but only...
September 19th, 2008 09:41 PM
by DSmith Go to last post
3 82
Date Query by VirginiaR
I have a database that I use to inventory items for a small store. Each item has a posting date. I want to perform a query that has the earliest posting...
November 23rd, 2008 12:54 AM
by Lou[_5_] Go to last post
1 86
Date Query by dazoloko via AccessMonster.com
Dear All Heres hoping someone can help me. I have a field which contains a due date for an inspection. This date can be between now and a year from...
December 20th, 2008 07:12 PM
by John Spencer Go to last post
5 93
Date query by Dudley
Is it possible to create a query field which will yield the last day of the month in the year following a specified date? For example if the date is (British...
October 26th, 2009 12:18 AM
by Dudley Go to last post
3 141
Date query by Iago
I have a table which contains a field called "DUEDATE", data type is DATE/TIME, formatted as LONGDATE. I use it to enter in dates when projects are due. How...
January 21st, 2010 07:52 PM
by John W. Vinson Go to last post
2 121
Date query by dhoover via AccessMonster.com
I need to run a query that picks up a particular date no matter how it's formatted. For example if a date is 02/02/2010 or 2/2/2010 or 02/2/2010, ect, I need...
February 8th, 2010 07:10 PM
by dhoover via AccessMonster.com Go to last post
6 167
Date Query by Les
Hello I'm trying to build a query that shows me all records where a field is older than 90 days from today or are null. I've tried using Now()-"90" Or Is...
December 7th, 2007 02:35 PM
by Les Go to last post
2 107
Date Query by Scottie
I have created a table with the following fields ID (autonumber) RID (Lookup) Weight (number,Single, 1 decimal place) Date of (Date) I need to create a query...
October 20th, 2007 02:08 AM
by John Spencer Go to last post
4 115
Date Query by PPerry
I have a table which records the dates students received their latest karate belt. The fields are BID (Belt ID), SNAME (Student Name), PRANK (Promotion Rank)...
June 8th, 2004 01:21 AM
by PPerry Go to last post
4 451
Date Query by Sue
I have created a database to keep track of our equipment (laptops and tablets)that are "checked out" to be used to train other departments in our organization....
June 16th, 2004 07:52 PM
by John Vinson Go to last post
2 111
Date Query by Angie K.
Good Afternoon, I created a deadline list (an access report)for our department based on a query. The information, based on the week it is due, is sorted by...
September 9th, 2004 12:35 AM
by John Spencer (MVP) Go to last post
2 150
Date query by rokjock
I have a table that keeps track of interview data (dates times locationsetc). Could anyone tell me how I could build a simple query that will allow me to...
October 10th, 2004 04:38 AM
by rokjock Go to last post
2 90
Date Query by Larry
In my db I have a field called Date Entered Training. I want to query all records that show everyone who has been in training for more than 12 months. Help?
(Multi-page thread 1 2)
December 1st, 2004 06:25 PM
by John Vinson Go to last post
13 217
Date query by Juan Gallego
Could someone help me with a query to report a result of searching which codes in a table exists in the last three months. I have columns in my table of Code...
February 17th, 2005 10:47 PM
by Ken Snell [MVP] Go to last post
1 93
date query by Lauren B
I am attempting to write a query where the user can chose to view entries that were created between a "start" date and an "end" date. The only way that I know...
March 9th, 2005 10:55 PM
by Per Larsen Go to last post
2 93
Date query by naiveprogrammer
I'm trying to run a query for a table named employees. In this table are 6 different columns that contain dates (01/01/2005). I need to run a query that will...
(Multi-page thread 1 2)
May 17th, 2005 08:55 PM
by tina Go to last post
10 194
Date Query by SamMexico via AccessMonster.com
Hi all, I was wondering if anyone could please help me? I have a database table that has a column allocated to the date a person consented to have their...
(Multi-page thread 1 2)
April 15th, 2010 02:31 PM
by ghetto_banjo Go to last post
13 274
Post New Thread


Display Options
Showing threads 10121 to 10140 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 04:01 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.