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
Keeping 12 months of records by hoachen
The data i have is: Jan - dec 09 and Jan 10 and Feb 10 and will add each month after that. I don't want to keep all of the months. I just want to keep like...
February 8th, 2010 03:46 PM
by hoachen Go to last post
6 142
Case When statement in Access Frontend with Sql Backend by icccapital
I am trying update my queries to perform better on my recently transferred backend from Access to Sql Server. So I need to change a switch statement in...
February 8th, 2010 03:30 PM
by Microsoft Access Go to last post
6 215
Querying using SQL statement by Joe[_22_]
Hi Using an expression as follows... SELECT IDCustomer AS Code, Name, Address FROM Customers ....the AS clause doesn't work in Access 2007. Running the...
February 8th, 2010 01:40 PM
by John Spencer Go to last post
5 111
How to lock viewing Form Design. by naveen prasad[_2_]
Hi all, In my Access project every thing is perfect... In Startup- main form as starup form. unchecked view database window. ...
February 8th, 2010 01:29 PM
by naveen prasad[_2_] Go to last post
4 132
ODBC--Call failed. by cluckers
I am running a query. One of the field's I am filtering. If I use a "Not Like" criteria the query runs fine, takes a second. However, if a use a "Like"...
February 7th, 2010 07:39 PM
by Hugh Williams Go to last post
4 144
Avg. 1-month, 3-month, 6-month & 12-month Stock Returns by ryguy7272
I don’t know for sure if Access can handle this request, but I know Queries are pretty powerful, so I’m thinking it is possible. As I alluded to in the...
February 7th, 2010 04:28 PM
by ryguy7272 Go to last post
3 155
Comparing dates in columns from linked table by fredo97
Hi, I'm new to Access/SQL and have a problem with a query that I just cant seem to be able to solve. So, I have an Access database containing client number,...
February 7th, 2010 04:10 PM
by fredo97 Go to last post
3 108
Need Min Value from Row and Heading Value that Corresponds to it. by JCowell
I have a table that looks somewhat like this w/o the *'d headings: h1 h2 h3 h4 h5 h6 h7 *Min...
February 7th, 2010 06:53 AM
by Allen Browne Go to last post
1 156
Changing existing data in database to title case by Jack
I have a nonprofit database that I am trying to change cities names to title case instead of all caps. I was sent an empty database that has a an update...
February 7th, 2010 06:31 AM
by John W. Vinson Go to last post
1 141
DLookUp by alhotch
I have two tables - tblEmployees and tblActivities. The tblEmployees table has three fields - fldEmployeeID (number type); fldLastName(text type); and...
February 7th, 2010 05:19 AM
by alhotch Go to last post
4 134
Find Min Value in Row or Selected Cells by JCowell
I have a query where I have product SKU's with various Pgrogram Prices. I want to create an expression to look at these multiple prices and return the...
February 7th, 2010 01:15 AM
by John W. Vinson Go to last post
1 108
sum for past tweleve months by tighe
i feel a little retarded i can’t pull the available information together to get the result i need. i have looked at http://support.microsoft.com/kb/208714...
February 6th, 2010 09:26 PM
by John Spencer Go to last post
7 261
Check for Values by alecgreen
Hi I have 2 tables, requirements and stock on hand. In the requirement table, I have a part number, qty and due date and a related record in the stock on hand...
February 6th, 2010 01:25 AM
by Jeff Boyce Go to last post
1 186
Crosstab Query - Column Heading Dates by Bob
I am running a crosstab query however the column heading with the dates is not in order. Instead of 1-2005, 2-2005.etc, I am getting 1-2005, 1-2006, 1-2007,...
February 6th, 2010 01:21 AM
by Duane Hookom[_4_] Go to last post
4 128
Query behaving differently in VBA than when running as regular Que by bvdahl
Hello, I have been struggeling with this problem the whole day, and I hope some one can give me some insight. I have an INSERT query that I want to run from...
February 6th, 2010 01:18 AM
by Duane Hookom[_4_] Go to last post
1 180
Grouping/Deleting Dates/Times (HELP ANYONE!) by Antney
Hi, I originally posted this a couple of weeks ago but no one has been able to help out on it. I am posting one more time to see if I can get an Access guru...
February 6th, 2010 01:04 AM
by Antney Go to last post
2 146
how do I put these 2 queries into 1 ?? by dannie
What I would like is 1 query that displays the columns Area , CountofArea, CountofArea2. I tried using the design query but it put a LEFT JOIN on the whole...
February 6th, 2010 12:17 AM
by KARL DEWEY Go to last post
3 124
group query by Ian C
I'm trying to create a query that gives me the average price of each product based on the last 10 purchases. The table is called "t_worksheet", with fields...
February 5th, 2010 11:39 PM
by KARL DEWEY Go to last post
1 128
Delete Query by GLT
Hi, I am trying to create a delete query that deletes records older than a specific date, the date is entered by a field on a form by the user. All records...
February 5th, 2010 11:33 PM
by GLT Go to last post
6 138
Subquery by hoachen
I am trying to compare two fields data if there are match. Table 1: item# 123 Table 2: Item# ItemName Edition creator 123 Name1 05 ...
February 5th, 2010 11:11 PM
by KARL DEWEY Go to last post
2 113
Post New Thread


Display Options
Showing threads 1301 to 1320 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 01:20 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.