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 Reverse Sort Order Last Post Replies Views
Select record External Source by John
Hi: I would like to insert a record and the record is extracted from Excel file in Access 2003. I know I can write the SQL command as: insert into...
December 7th, 2007 03:54 PM
by [email protected] Go to last post
4 197
'Not In' query not seem to be working by John
Hi Access 2000 SP3. I have a Clients table which has 5400 records.When I run the below query to return all records in Clients table that have matching keys...
September 7th, 2008 10:33 PM
by Ken Sheridan Go to last post
6 110
Repeating a Total in Mutiple Records. by John
I have a table with several months of monthly reports (One for each month.), I have a planned percent complete in another table. The planned percent...
October 4th, 2008 01:00 AM
by John Go to last post
2 98
Oldest date by John
I want to build a query to return a list of employees and the dates they reached a certain level. In simple terms My table looks like...
October 9th, 2008 04:00 AM
by Lord Kelvan Go to last post
2 80
Date calculation in query by John
Hello. I'm having a bit of a problem with a query. First of all, let me just emphasize that the final result of the query I want to build would be...
October 24th, 2008 04:09 PM
by Allen Browne Go to last post
3 88
Rounding Time? by John
Hello, I am needing some assistance with the following: I want to take someones hours for the day and round them with the following rule = If you work 5.01...
November 19th, 2008 11:11 PM
by John Go to last post
4 149
List controls on a tab page? by John
Hi, I have a form that has a tab strip with 4 or 5 tabs on it. I'm trying to write some code that will list all the controls on a specific tab page. I can...
November 26th, 2008 04:23 AM
by tina Go to last post
4 107
removing spaces by John
I have a query that has a date and time field. What I would like to do is read the only the date, for example; 11/12/2008 12:34:67pm. I tried this test1:...
November 25th, 2008 06:59 PM
by fredg Go to last post
2 68
current month by John
I have a query that has the date and time as 11/26/2008 12:42:33pm, what I want to do is pull the current months data using the system date/time. I've tried...
November 27th, 2008 09:35 AM
by KatyTK Go to last post
9 120
Subquery Assistance by John
-- Thanks - John
August 12th, 2008 10:47 PM
by John Go to last post
0 58
Rolling 3 Month Average by John
I have been working on this all day and can't seem to make it work. I have a crosstab query that shows a cost code and description and monthly period cost. ...
August 11th, 2008 07:31 PM
by John Go to last post
1 111
Finding the date of last pay rise by John
Hi I have a Jobs table with Staff ID, Job Rate and Job Date. Staff start at a rate and their jobs from that day onwards have that rate. Then they get a...
January 7th, 2008 12:07 AM
by Bob Quintal Go to last post
8 99
Date issue by John
I have a sql database that access is using to do some queries on, in the queries there is a date/time field. I've used the datevalue() function to remove...
January 31st, 2008 02:26 AM
by Jeff Boyce Go to last post
9 124
Assigning ID by group by John
Hi I have a table of contacts with their associated companies. How can I assign numeric company ids in sequence to these records such any records with the...
March 26th, 2008 11:49 AM
by Brendan Reynolds Go to last post
1 109
simple select query variable question by John
I haven't used Access in a couple of years but I used to know how to do this. Very simply I have one table of Products and I want to enter Criteria into the...
June 6th, 2008 11:52 PM
by John Go to last post
4 125
A97 - Query from a Form not working by John
I have a table with about 70 "skills" which are based on an employee survey (to be used for an emergency) such as Electrician or Roofer or many others Each...
June 10th, 2008 07:10 PM
by Ken Sheridan Go to last post
1 130
Dinamically Build a CrossTab by John
I have a form with the following selections a user may select: 1. Date format: "Ordinal" or "Calendar" 2. Group By: "JV ID","CMIS ID", or "Craft" 3. Value to...
July 11th, 2008 07:18 PM
by John Go to last post
2 118
CrossTab Help! by John
I have a query that uses a subquery to calculate a prior period cost, so I can calculate the difference between a total todate cost this month and the total...
July 16th, 2008 09:51 PM
by John Go to last post
6 169
Update Query - One Field, Mutiple Posibilities... by John
I have a field in one table that must have one of 18 (string) different values deplending on the value of a cost code. The table fields a ! - The cost...
July 18th, 2008 11:49 PM
by John Go to last post
4 116
How to count records w/o counting duplicates by week, month, or ye by John
I have a table with payroll data. I have an employe ID, a week ending date (Sunday), and hours worked on Sun, Mon, Tue, ... Sat. What I need is a query...
April 17th, 2009 10:28 PM
by John Go to last post
4 86
Post New Thread


Display Options
Showing threads 20001 to 20020 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:33 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.