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
Remove text from a field by StratfordWard
Hello All: We are trying to update about 8,000 customer records and unfortunately inherited some fields that heretofore had very few input parameters. We...
July 11th, 2008 12:32 AM
by StratfordWard Go to last post
2 143
Crosstab Column Headings by Movies Man
None of the Field Names are showing up as column headings for my crosstab query. Here is my SQL: TRANSFORM Avg(dbo_tblTranCHECK.DISC_PRINT) AS...
July 10th, 2008 11:50 PM
by KARL DEWEY Go to last post
1 166
Customizing query fields based on form input by Rus925
I'm using a parameter query that derives the parameters from controls on an unbound form. Now, I want to put controls on the form that let the user choose...
July 10th, 2008 11:05 PM
by Rus925 Go to last post
7 194
Calculate Year from Current Year by MB
I have a table that has a field called YearInstalled. Data type is Number (long integer) with validation rule: Is Null Or Between 1000 And 2999. (I only...
July 10th, 2008 09:24 PM
by MB Go to last post
4 182
Query that by Matthew Pfluger[_2_]
I am designing a database that stores tasks, hours, start dates, and end dates. Management wants to see an estimated hours by month for each task. Example: ...
July 10th, 2008 09:06 PM
by KARL DEWEY Go to last post
3 150
Criteria not working on expression field in query by Erin Freeman
Hi there, I am hoping someone can help me. I have an expression in a query I-Amount Balance: Round(-,2) I would like to show all the records that do not...
July 10th, 2008 08:30 PM
by Erin Freeman Go to last post
3 188
my 2007 tax return by tax returns
statics of my 2007 return
July 10th, 2008 08:09 PM
by tax returns Go to last post
0 126
Need help with query linked to form. by Dan
Hi, I am trying to run a query based off of an unbound field in a form. Essentially I would like the end user to input a date in the form and hit the command...
(Multi-page thread 1 2)
July 10th, 2008 06:09 PM
by Dan Go to last post
10 214
Question on Query Comparing 2 values by Joe C
Hello Group, I have 2 recordsets with the 2 exact same fields. I would like to perform a compound comparison of the 2 fields from each table. That is;...
July 10th, 2008 05:58 PM
by Joe C Go to last post
2 166
Help with complicated query? by fktx
I am still new to Access and queries, but I understand the basics of SQL. I have my table set up in the following format: StationID Date_Time ...
July 10th, 2008 05:54 PM
by fktx Go to last post
8 141
Delete query by JOM
I have a table that has 20 fields and might contain duplicate information based on 3 fields(ID, LoanNum, date). How do I create a delete query that would...
July 10th, 2008 05:33 PM
by Allen Browne Go to last post
2 185
= by blancla
I created this expression from other 2 expressions Expr3: IIf(,"MISS","HIT") Expr1 is a variance from Field1 and Field2 Expr2 is Field2 x 2% Expr3 should be...
July 10th, 2008 05:30 PM
by KARL DEWEY Go to last post
1 140
Access SQL Question by Kevin
I'm trying to UPDATE the value of a COUNT() operation into a field viz. UPDATE table1 SET field = ( SELECT COUNT(*) FROM table2 WHERE table1.PrimaryKey...
July 10th, 2008 04:43 PM
by Kevin Go to last post
3 157
Deranged Calculation by KWhamill
I'm not sure this is going to make any sence I need to take the Sum of these amounts in table A and B grouped by Account # separetly and then compare them ,...
July 10th, 2008 04:00 PM
by KARL DEWEY Go to last post
6 197
Simple Query Question, can't figure it out by bswood7
Hello, Novice user here. I have two tables. One contains StudentName, ProgramSelect1, ProgramSelect2, ProgramSelect3 and a variety of other fields. The...
July 10th, 2008 03:46 PM
by bswood7 Go to last post
2 191
A couple of text parsing questions by scubadiver
Question no.1 Eg, the following NORCREST, , WOODSIDE ROAD, , , BANCHORY, KINCARDINESHIRE, AB314EN How do I get "AB314EN" on its own ie. just the text after...
July 10th, 2008 03:37 PM
by Michel Walsh Go to last post
3 185
Produce a list of names based on data from two fields by magicdds
I have a query based on a table with 2 columns. PatientID LinkID PatientName 16 20 Joe(16) 25 ...
July 10th, 2008 03:34 PM
by Allen Browne Go to last post
3 213
Delete all modules but 1 by auujxa2 via AccessMonster.com
Here is code I have that deletes all queries, forms, and reports. The last part I want to delete all modules but one. Any ideas? Case 4 is modules, and the...
July 10th, 2008 02:57 PM
by auujxa2 via AccessMonster.com Go to last post
4 252
Picking up last 4 letters from a field by CAM[_2_]
In my query I have an account account number that I only want to pick the last 4 letters. The account number has 8 numbers and text. This field is actually...
July 10th, 2008 02:41 PM
by CAM[_2_] Go to last post
2 204
Module problems by Jennifer
I have my queries,tables, modules, and macros all set up. Below is the function my module serves. I changed the name of a table, and it will not work now- I...
July 10th, 2008 02:34 PM
by Jennifer Go to last post
2 192
Post New Thread


Display Options
Showing threads 9981 to 10000 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:36 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.