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
ÄÜô°É by denghan38
¶ÔÁË
May 27th, 2005 10:18 AM
by denghan38 Go to last post
0 70
[Select] the results of 2 queries by Engels
I have two queries that produce lists of "Course Speakers" and "Course Registrations". I want to combine the lists to produce a list of all attending my...
January 30th, 2007 10:31 AM
by Engels Go to last post
2 81
[Run-Time Paramters] and Crosstab Queries by Michael Reinhardt
I have a crosstab query that I want to use a run-time parameter (i.e. ) in one of the fields that happens to be a Row Heading. When I run the query, I get an...
December 9th, 2005 06:25 PM
by Michael Reinhardt Go to last post
2 68
[mysql 3.23] Sum in Queries wrong by [email protected]
Hi, Well the following query is not the one i will use but it's the same prob : SELECT sum(country_id ) , count( country_id ) FROM Tbl_Country,...
April 21st, 2006 01:15 PM
by John Spencer Go to last post
1 55
[missing operator] by Nassir
I've Inserted these fields from a FORM except the AgentID which is the primary key for the table. The AgentID equal the first letter of the firstname,...
April 18th, 2007 07:50 PM
by Jerry Whittle Go to last post
1 84
[microsoft][odbc visual foxpro driver]function sequence error (#0) by Dundoan
Hi All, I am trying to connect to a free table Foxpro 2.6 table from access 2003 using ODBC, Visual Forpro Driver 6.01.8629.01 and I get the above error. If I...
January 18th, 2006 04:37 PM
by Cindy Winegarden Go to last post
3 142
[Microsoft][ODBC Microsoft Access Driver] Invalid procedure call by andrew
Getting this error message in Excel when creating a pivottable by pointing to an Access query using IIF function. Received undefined function error...
August 2nd, 2005 09:32 PM
by [MVP] S.Clark Go to last post
1 259
[help] Query with 1 or n parameter by [email protected]
a student know one ore more programming language in a mask i select from a list_box one or more language and i send ad parameter to a query that extract the...
October 6th, 2006 04:52 PM
by John Spencer Go to last post
5 130
[Forms]![frmNameOfForm].[cboControlName] -- need help w/ exception by Tom
In a login form with 2 cascading combos. Their selected values will be used in a query to subselect matching records. I use the following strings in my...
April 28th, 2005 02:46 PM
by [MVP] S.Clark Go to last post
1 99
[Forms]![frmNameOfForm].[cboControlName] by Tom
In a login form with 2 cascading combos. Their selected values will be used in a query to subselect matching records. I use the following strings in my...
April 28th, 2005 02:56 PM
by [MVP] S.Clark Go to last post
2 73
[Forms]![clients]![filter]? by JethroUK©
i need to pass a form filter (Clients.filter), to a query as criteria i tried: !! ! !
October 27th, 2005 06:28 PM
by JethroUK© Go to last post
6 96
[Ender Date]+1 Query Problem by Don
I am having an issue with a microsoft access query. I am trying to attempt the following. I have a table with a field that shows the Date and time in the...
November 13th, 2006 09:07 PM
by Don Go to last post
2 74
[Ask Me Parameters] Access 2007 by Ron
I have a query where I Ask for Parameters i.e. This works OK if I want Year "2007" If I want All Years, In previous version of Access, I could Enter Wildcard...
August 4th, 2008 09:03 PM
by John W. Vinson/MVP Go to last post
4 153
[acess2003][yupyupxav] Grouping low values in a sum by yupyupxav
Hello all, I have a table with a field designator : text total : date (where I store a duration, always smaller than 24h) I want to do a sum by designator,...
December 14th, 2008 08:20 PM
by yupyupxav Go to last post
4 91
[ACCESS] Query and IF THEN ELSE....is possible? by tranky
Hi Boys, i'm italian and i need your help! Is there the possible to realize an access query like this? IF SELECT ETC...ETCCC.... IS BLANK THEN DO ANOTHER...
April 22nd, 2006 11:46 AM
by Douglas J. Steele Go to last post
1 98
[ Parameter Queries ] - Multiple Values for One Parameter by Robbie Baquiran
I'm trying to make a query to fetch records from a table based on a parameter given at run time. It works fine if I only want to run the query against one...
December 9th, 2005 03:23 AM
by Duane Hookom Go to last post
8 199
[ Autofill datatable columns with increasing numbers ] by [email protected]
How to autofill datatable columns with increasing numbers - like the way in Excel? Given a datatable with 2 columns : ID & Data. (a) How to fill the column...
November 28th, 2006 04:20 AM
by [email protected] Go to last post
0 94
Zoom by Spammastergrand
Is there a way to mess with the Zoom of a form based on screen resolution? So that it could go down to 85% for example if the resolution is...
October 6th, 2004 02:29 AM
by Spammastergrand Go to last post
2 109
Zipcode table by Tony
Does anyone now code to link a zipcode database to another database were the user will be able to choose the city and state when they enter the zipcode?
January 11th, 2005 03:41 PM
by Go to last post
1 130
Zip Codes Help! by Chris
Hey everyone, I need to make a database that contains customer numbers and their zip codes. some zip codes look like 48315-4552 and others that look lik...
January 23rd, 2007 04:46 PM
by Chris Go to last post
4 94
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 04:30 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.