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 Labels by Andy
I am trying to generate a master dates table that holds a number of groups that a date may belong to. Amongst them are some that I can create using date...
February 1st, 2010 12:14 AM
by PieterLinden via AccessMonster.com Go to last post
1 140
Date Last Changed by FA
Please help. I'm trying to produce a product price list from a table that records all the price history for each item. The query should show only the last...
September 14th, 2005 12:37 PM
by FA Go to last post
9 257
Date Limit Criteria - January of Previous Fiscal Year by CMA
I am trying to set a "dynamic" criteria limit for a date field that will limit query results to everything occuring since the January BEFORE the current...
November 28th, 2007 07:15 PM
by Marshall Barton Go to last post
4 129
Date Limit in Crosstab from Union query by Molasses26
Hello! I have a union query that links together multiple tables and it works like a charm, however when I try to run a crosstab query based on it and limit...
October 16th, 2009 12:31 AM
by Molasses26 Go to last post
2 125
Date Limits Query by NeonSky via AccessMonster.com
Good Afternoon, I have a rather challenging question for your consideration. Please consider my existing process/sample data.... ...
February 27th, 2008 08:58 PM
by KARL DEWEY Go to last post
1 115
Date lookup in Table by JGal01
I have two tables. In one table, there are lines with various dates which contain information that I will eventually summarize based on Fiscal Months. In...
January 25th, 2006 08:16 PM
by JGal01 Go to last post
2 63
date manipulation by angie
i have two date fields: expiration date and payment date. i want to create an update query that updates records containing null payment date value to ...
December 17th, 2007 04:05 PM
by Jerry Whittle Go to last post
2 55
Date manipulation by NetworkTrade
This works in a query design view column: WeekOf: IIf((Weekday()=1),(-6),(DateAdd("d",-(Weekday()-2),))) It looks at the date field and assigns it to the...
October 7th, 2007 07:39 PM
by NetworkTrade Go to last post
3 140
Date Match by George
In my data base I have everyones birtdates. How could I write an expression to have a query find all records that match todays month and date only. Here is my...
September 17th, 2004 06:43 PM
by fredg Go to last post
1 117
Date math in query - strange results by David
My query returns: OpenDate, CloseDate, DaysOpen with iif(NZ(T.CloseDate,"")="",Now() - T.OpenDate,T.CloseDate - T.OpenDate) AS DaysOpen It seems to work when...
June 9th, 2004 12:53 AM
by John Spencer (MVP) Go to last post
1 318
Date Math to Milliseonds by Jack
Hello, I noticed the datediff function will provide date math to the nearest second, but how can I perform date math to the nearest millisecond? Thanks in...
January 2nd, 2006 05:18 PM
by Vincent Johns Go to last post
2 90
Date Minues Month by Thorson
I currently have a query that sets the criteria of the records by a date entered into a control on a form. I would like to create another query that has the...
December 19th, 2008 07:46 PM
by John W. Vinson Go to last post
9 89
date mismatch in query..do not know how to solve by tcek
i have a query where the criteria statement has equal to . is in a table and formatted as mm/dd/yyyy. date #2 is formatted as date and time. how do i...
December 21st, 2007 11:19 PM
by KARL DEWEY Go to last post
3 87
Date not coming up! by mem
Hi, I am trying to get results in a query using the between two dates. (ie between 1/1/2008 and 1/31/2008) The date is formated in date plus time. (ie...
February 5th, 2008 09:44 PM
by mem Go to last post
7 77
Date not in list by jdbit2byte
Say an input form stores data in these fields in tbl_Time: EmployeeID Date LaborHours TravelHours What kind of query would I run on tbl_Time to find out which...
March 3rd, 2007 11:28 PM
by John W. Vinson Go to last post
3 168
Date not within range query by Cory
I am working with a database that has a number of related tables. The query I am building only concerns two however. Entities and Last Seen. I have...
September 27th, 2007 05:06 PM
by John Spencer Go to last post
3 131
Date of Edit by Claire
Hi: On my query, I need to have a field that shows the date that a record was updated, however, the date can not change until the record is changed. I...
September 23rd, 2004 05:26 PM
by John Vinson Go to last post
3 222
Date of Local Machine by Babadog
hello My DataBase have one field i use Date/Hour the name is NASCIMENTO In my querie i need return alls birthday using the Date of my local machine. For...
April 5th, 2007 03:16 AM
by Allen Browne Go to last post
1 96
Date of Month vs. Now by Walter Steadman
Greetings again all, I think I figured out where I need to go with the Date thing. In my table tblPilot the Pilots Birthday is listed. His/Her Age is...
(Multi-page thread 1 2)
June 9th, 2005 09:50 PM
by Jeff Boyce Go to last post
10 494
Date or Time range by LtFass
I am building a program for a fire dept to keep trak of thier daily log. I have a form where the daily data is entered. below the form is subform bound to a...
October 4th, 2004 06:23 AM
by LtFass Go to last post
5 103
Post New Thread


Display Options
Showing threads 10041 to 10060 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 10:58 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.