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 fridays@don hill ,S?s photos myspace images thnik you
December 9th, 2009 03:36 AM
by jeramie francis[_2_] Go to last post
0 1,269
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 01:06 AM
by John Spencer Go to last post
1 804
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 9th, 2009 12:36 AM
by Proko Go to last post
5 805
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 11:54 PM
by Corey Ryan Go to last post
0 1,032
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 11:19 PM
by Ian Burton[_2_] Go to last post
2 750
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 10:32 PM
by vanderghast Go to last post
4 948
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 10:17 PM
by vanderghast Go to last post
4 813
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 09:10 PM
by Dale Fye Go to last post
4 752
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 08:26 PM
by John Spencer Go to last post
3 825
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 06:27 PM
by KARL DEWEY Go to last post
2 663
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 05:22 PM
by Mike Go to last post
4 672
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 04:56 PM
by Duane Hookom Go to last post
1 736
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 04:52 PM
by John Spencer Go to last post
3 678
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 03:43 PM
by Dale Fye Go to last post
2 661
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 03:42 PM
by Niroshana Go to last post
0 691
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 03:10 PM
by Tom van Stiphout[_2_] Go to last post
1 698
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 03:08 PM
by Tom van Stiphout[_2_] Go to last post
2 692
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 8th, 2009 12:54 AM
by Bob Barrows Go to last post
1 734
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 08:12 PM
by Duane Hookom Go to last post
3 686
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 06:56 PM
by Dale Fye Go to last post
1 633
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 12:51 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.