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
FILTER by accessvoter
How do you filter numbers? ex. 1 through 200 in order?
June 7th, 2010 06:00 AM
by Tom van Stiphout[_2_] Go to last post
1 1,242
calculating average days by JohnL
I am trying to develop a report where in the PartNum footer the average number of days between orders is calculated. I have created the...
June 7th, 2010 02:12 AM
by Marshall Barton Go to last post
2 1,416
date and time query by domaze
hello, this is my first post in this forum. I have the following problem and i really need some help because i am about to go crazy. I cannot understand why...
June 6th, 2010 11:35 PM
by domaze via AccessMonster.com Go to last post
6 1,297
JOIN Query very slow by Tally.NET
Hello, I have the following Input tables Table1 Serial Item Date SerialandDate 123 Item1 01-04-2007 12339173 123 Item2 01-06-2010...
June 6th, 2010 09:07 PM
by John Spencer Go to last post
4 1,148
Optimization of Between Clause Queries by Kevin Myers
I have some sql queries involving the use of between clauses, similar to the following: select Colors1.*, sum(Colors2.freq) as TFreq from OldColors as...
June 6th, 2010 08:45 PM
by Bob Barrows Go to last post
3 878
Serious Problem with Access 2010 "Query to complex" by JimG
I just installed Office 2010 (May 2010 version from Technet download) and many queries that worked in 2003 and 2007 now will not open and produce the error...
June 6th, 2010 07:52 PM
by JimG Go to last post
0 854
Sum and DateDiff by Kelly
Hi, I doing a calculation in a query of the difference in times. I'm wondering if I can control the decimal precision to be just (2) places. The number I end...
June 6th, 2010 04:58 AM
by Kelly Go to last post
2 831
AVG BETWEEN DAYS by Lucy
Hello, Within my qry I would like to calculate the average daily production for the month. The data Im working with is: production volume, dates (which is a...
June 5th, 2010 10:53 PM
by KenSheridan via AccessMonster.com Go to last post
1 757
A field (string) is into other field (string) by Victor2020
Using 2 tables I want to get the rows that match where the content of the field (string) is equal or is into other field (string) from other table.
June 5th, 2010 02:15 PM
by Marshall Barton Go to last post
2 1,010
Querying for most recent value by dhinton
I am rather much of a novice when it comes to developing Access databases, but have found myself in a situation at work where I have had to develop two...
June 5th, 2010 01:43 AM
by PieterLinden via AccessMonster.com Go to last post
1 808
DatePart by Keith
I'm trying to convert "mm/dd/yyyy hh:nn:ss" date format to just time using DatePart function. I've used DatePart("hh:nn",) and it returns "Error". I've used...
June 4th, 2010 09:03 PM
by Keith Go to last post
2 674
querying unrelated tables by Keith
I have two tables - Employee_PunchTime table and Holidays Table. The PunchTime table contains three fields representing EmployeeID, Time-in and Time-out;...
June 4th, 2010 07:13 PM
by Keith Go to last post
7 940
Switch Last Name First Name to First Name Last Name by Iram
Hello, Access 2003. I have a single field called "Name" in a table called "Members". There is about 300 records in a Last Name First Name format,...
June 4th, 2010 04:22 PM
by Iram Go to last post
2 728
Storing time as integers by SSi308
I have a call database that includes a field for length of call. I have created a query that includes employee, date, and length of call. I need to calculate...
June 4th, 2010 04:09 PM
by KenSheridan via AccessMonster.com Go to last post
6 918
create a form that collects parameters by Kalai
Hi, i need a form where we search for a detail and the result should be published in the bottom, based on the result the user will decide what to do next in...
June 4th, 2010 02:15 PM
by Marshall Barton Go to last post
1 1,100
Changing constants in a query to user input values by PamB
Access 2007 I have a table that contains (among other things) Start Date TimeDown End Date TimeUp All of these are Date/Time type Example data:
June 4th, 2010 05:52 AM
by PamB Go to last post
2 859
Total by certain time period by nadesico
I have three fields in a table, and want to determine the total of the occurrences by a certain time period. The data I have looks like...
June 4th, 2010 04:58 AM
by PieterLinden via AccessMonster.com Go to last post
1 768
Maybe Update Query? by AccessKay
I’m floundering about and need someone to point me in the right direction. I have two...
June 3rd, 2010 11:06 PM
by AccessKay Go to last post
2 764
Default Dates by Ampridge
I have a query that calculates records between two dates as Between And Is there a way to show a default value for the beginning and ending dates in the...
June 3rd, 2010 06:49 PM
by John Spencer Go to last post
2 836
COUNT number of times text in records by gator
I have a field of names where there are multiple records of the same name. I want to run a query on this showing a field of the name and a field of the...
June 3rd, 2010 06:25 PM
by gator Go to last post
3 680
Post New Thread


Display Options
Showing threads 21 to 40 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:27 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.