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
jeramie bellmay by jeramie francis[_2_]
not mach no find area [email protected] hill ,S?s photos myspace images thnik you
December 9th, 2009 02:36 AM
by jeramie francis[_2_] Go to last post
0 373
Transpose Access Table / Query by Corey Ryan
Hi Duane, Thanks for your reply. I have been trying to get this to work for a few days without success so I have broken it down to a simple problem. I have a 3...
December 9th, 2009 12:06 AM
by John Spencer Go to last post
1 180
IIf statement in query criteria by Proko
I am having a problem with the iif statement when I use it in the criteria for a query for a combo box (Combo2) that is based on the selection of another...
December 8th, 2009 11:36 PM
by Proko Go to last post
5 205
Transpose Access Table / Query by Corey Ryan
Hi Duane, Thanks for your reply. I have been trying to get this to work for a few days without success so I have broken it down to a simple problem. I have a 3...
December 8th, 2009 10:54 PM
by Corey Ryan Go to last post
0 341
update query by Ian Burton[_2_]
Hi, I thnk I am missing something obvious, but I an stuck, and seem to need help getting some fields in a table updated. Table 1: R_BSA_M This has fields for...
December 8th, 2009 10:19 PM
by Ian Burton[_2_] Go to last post
2 166
Boolean expressions in the where statement by Paul Washburn[_2_]
Im trying to build a form with multiple check boxes that each apply a filter to the records displayed. I need for the user to be able to select any...
December 8th, 2009 09:32 PM
by vanderghast Go to last post
4 213
classify by Miriam
After calculating an average, I need to classify each member as 1, 2, 3, ... 10. 1 = an average of 3.99 or lower, 2 = an average of 4.0 - 4.75, etc. How can...
December 8th, 2009 09:17 PM
by vanderghast Go to last post
4 185
date format lost in UNION query by Marge
I've merged the results of 2 queries into a UNION query, however I suspect that one of the fields has lost it's date format. The reason I think so is that...
December 8th, 2009 08:10 PM
by Dale Fye Go to last post
4 223
Change Form/Report Query Based on User Selection by Wayne[_13_]
I have a form and report based on a query. I need to change the query based on what the user selects on a form. Using VBA in MS Access 2002, can I change a...
December 8th, 2009 07:26 PM
by John Spencer Go to last post
3 244
Wildcards by Emma Hope
Hi all, I have a query where i want to pick all the records with 'denied access' in them, the records could be as follows; denied access denied me...
December 8th, 2009 05:27 PM
by KARL DEWEY Go to last post
2 214
Calculated Query by Mike
I have a query with a field called Balance Due. I need to add 5% to the Balance Due which I know how to write the expression Interest Payment: *0.05+ BUT,...
December 8th, 2009 04:22 PM
by Mike Go to last post
4 175
Query from Multiple Checkboxes by Paul Washburn[_2_]
I have a form with 4 seperate checkboxes on it. Each check box is supposed to apply a filter for the query results, so that if none of the boxes are checked...
December 8th, 2009 03:56 PM
by Duane Hookom Go to last post
1 219
Making null by golfinray
In the number field of a table, I have some numbers and some nulls. I would like the entire field to be null. NOT zeros. Just blank. Do I need a delete query...
December 8th, 2009 03:52 PM
by John Spencer Go to last post
3 177
Creating a parameter in a Union Query by John
I have, with the help of this newsgroup, created a union query. However I now need to add a parameter to have it only show me the data for a specific period...
December 8th, 2009 02:43 PM
by Dale Fye Go to last post
2 205
Query Parameters error of the Upsized database by Niroshana
I have upsized my Access 2007 database to SQL server 2005 database (Front end Access Database and Back end SQL server Database). Following Adp query does not...
December 8th, 2009 02:42 PM
by Niroshana Go to last post
0 192
Conversion Problem - Text to Exponential by Commish[_2_]
I know that the Subject might be a little off, but here's my issue. I am importing data from a spreadsheet into an Access database. In this particular column...
December 8th, 2009 02:10 PM
by Tom van Stiphout[_2_] Go to last post
1 203
Double Results in Query by Keiron_Dole
New to Access I am trying to create a query that returns data from 2 tables. one table can have multiple entries on one day per person and the other table...
December 8th, 2009 02:08 PM
by Tom van Stiphout[_2_] Go to last post
2 181
ADODB.Connection to Teradata Timesout by Ross
Hi All, I am running Teradata queries from MS Access using a ADODB.Connection. The queries run directly unsing Teradata in about 3 Min. I can't keep the...
December 7th, 2009 11:54 PM
by Bob Barrows Go to last post
1 241
Crosstab query and Lookup field problem by Andy C Matthews
Hi there, I'm trying to create a Crosstab query that shows a Class of Business on the rows, Status along the columns and a total number of Projects as the...
December 7th, 2009 07:12 PM
by Duane Hookom Go to last post
3 203
Parameter query with expressions and calculations by Linda \(RQ\)
Hi Everyone, I am using Access 2003. I have been working on this query for a few weeks using my Access book, examples from this group and google searches. ...
December 7th, 2009 05:56 PM
by Dale Fye Go to last post
1 199
Post New Thread


Display Options
Showing threads 2001 to 2020 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 08:25 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 OfficeFrustration.
The comments are property of their posters.