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
MS ACCESS 2003 Report by A64+
Im using a Report in MS ACCESS 2003. Ive 2 tables. One named 'Candiate_Table' and the other named 'Votes_Table'. 'Candidate_Table' has the id of each...
April 4th, 2008 10:02 AM
by A64+ Go to last post
0 80
MS ACCESS 2003 Report + SQL by A64+
Im using a Report in MS ACCESS 2003. Ive 2 tables. One named 'Candiate_Table' and the other named 'Votes_Table'. 'Candidate_Table' has the id of each...
April 6th, 2008 12:08 PM
by NoodNutt Go to last post
1 132
ACCESS 2003 Report & SQL Query by A64+
Im using ACCESS 2003. Ive created two queries using Query Design wizard. Now what the problem is that, i want to bring the result of those two queries as...
April 4th, 2008 09:15 AM
by strive4peace Go to last post
1 91
add an integer to Date the get Date? by aa
I have a table "Invoices" containing, among other things, the date of the invoice, as type Date I have another table "Customers" containing, among other...
July 23rd, 2004 05:32 AM
by Tom Ellison Go to last post
7 235
msquery with ansi database by AA
Hi every body Is it possible to get data with msquery from an ANSi database Informix IDS 9.4. Tryed to do but get a msg error " the specified table ...
October 24th, 2005 08:47 AM
by AA Go to last post
2 195
query for a bank statement by aa
I have a table which shows activity on a bank accouint for a certain period. There is a field "amount" where withdrawals are shown as negative and money...
January 24th, 2006 03:25 PM
by Allen Browne Go to last post
1 117
nested AND loop query by aaaagc
I have this Table : ID Course Det1 Det2 Det3 St_1 Curse1 1 2 3 St_1 Curse2 1 2 3 St_1 Curse3 1 2 ...
April 4th, 2008 01:04 AM
by aaaagc Go to last post
2 108
nested AND loop Qery Question by aaaagc
i have this table : ID Course Detail1 Detail2 Detail3 St_1 Curse1 1 2 3 St_1 Curse2 1 2 3 St_1 Curse3 1 2 ...
April 1st, 2008 08:01 PM
by akphidelt Go to last post
1 116
HOW DO I GROUP BY A TEXT FIELD AND SUM THE AMT.. by aaae36
HOW DO I GROUP BY A TEXT FIELD AND SUM THE AMT.. :)
April 6th, 2005 01:59 PM
by aaae36 Go to last post
2 96
Passing Active Form Name to Report Input Parameter (ADP) by Aad v via AccessMonster.com
Hi Access Profs, I create a report which has a stored procedure as control source. To select the right record for the report, the ID of the active record...
September 6th, 2005 09:32 PM
by Aad v via AccessMonster.com Go to last post
3 166
How to show fund with most current performance by AAE
Please help. I am trying to run a query from a table with fund names and monthly performance for each fund. Each fund has a unique ID number. I only want to...
April 9th, 2009 02:22 PM
by AAE Go to last post
2 93
Most recent update by AAE
I have a table that has historical monthly performance for each fund ID #, shown below: ID Date 1 10/2008 1 11/2008 1 12/2008 2 ...
February 11th, 2009 02:47 PM
by Allen Browne Go to last post
1 90
Troubles with "OR" by aaearhart
SELECT tbl_Projects., tbl_Projects., tbl_Projects., tbl_Projects., tbl_Projects. FROM tbl_Projects WHERE (((tbl_Projects.) Like OR (tbl_Projects.) Like OR...
July 1st, 2005 11:03 PM
by Van T. Dinh Go to last post
5 127
INSERT INTO query involving Dates by aaearhart
I have this table: WORKWEEKS.WeekID (auto number primary key) WORKWEEKS.WeekNumber double WORKWEEKS.WeekStart medium...
June 22nd, 2005 08:51 PM
by aaearhart Go to last post
0 86
Deleting Empty(Null) Records by aaearhart
I have imported some data from Excel into a new Access table. I now have several records that are null (from empty rows in Excel). How can i write an SQL...
May 13th, 2005 01:10 AM
by aaearhart Go to last post
2 97
WHERE clause returns A and B, but not A and C by aaearhart
Hello. Here is my current query*: SELECT .JobName & "-" & .JobNumber AS FullJob, .JobType FROM WHERE (((.EndDate)Now()-360) AND IS NOT ((.JobType)="Show"...
January 5th, 2006 01:39 PM
by John Spencer Go to last post
4 110
Expr1002 by aak
I have a query something like this. I want to order it by total. Everything else works OK only ordering doesn't work. It displays me window - 'Enter Parameter...
September 13th, 2005 09:20 PM
by Marshall Barton Go to last post
1 184
Query based on selection in form (Datasheet view) by [email protected]
I would like to make a query based on a selecion (more than one selection) in a subform in datasheet view. the point is to be able to use this query as a base...
August 17th, 2007 01:55 AM
by Ofer Cohen Go to last post
1 82
Subject: Need help on Iff Statement by Aamer
I want to use IFF statement in a querry but so far am unable to figure out how to do it. If someone could guide me I will be greatful. following are the...
September 26th, 2009 08:54 PM
by Duane Hookom Go to last post
1 95
Help Me Fix This Querry by Aamer
am trying to create a querry to use in making an invoice following is the querry in SQL view SELECT Challan., Challan., .CompanyName, ., ., .Price,...
October 1st, 2009 01:50 AM
by smartin Go to last post
3 154
Post New Thread


Display Options
Showing threads 161 to 180 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 11:49 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.