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
what determines if you can add a record to a query? by MattE
I have two queries, each based on a simple single table (a different table for each query). One allows me to add a record and the other does not (either...
October 4th, 2006 07:10 PM
by MattE Go to last post
2 120
Update based on max value by briank
I have two table linked together by two sets of fields. I am trying to get Table A to update Table B based upon a max value of Table A. In my Update To:...
October 4th, 2006 07:51 PM
by briank Go to last post
0 109
CALCULATION by mbynoe
Could someone please execute this SQL statement into Access? CREATE TABLE #tmp ( RowID INT IDENTITY(1,1) NOT NULL, Injection ...
October 4th, 2006 08:24 PM
by mbynoe Go to last post
0 104
Include ACCESS in ALL OFFICE PRODUCTS by Tony from GCC
I am a new college student and bought the office student teacher edition. It does not have ACCESS on it. Didn't know that when i got it and it suprised my...
October 4th, 2006 08:26 PM
by [email protected] Go to last post
1 126
Eliminate duplicates by stephenson22
I would like to remove duplicates in a query by distincting only one column. So far I only use the max function on the related rows aside from the one with...
October 4th, 2006 08:30 PM
by stephenson22 Go to last post
0 90
Allowing multiple Criteria in a Make Table macro by jesZee
Hi Macro Genius, I have a situation here. I have a make table query which I have to change the "Criteria" field at least six times to make table...
October 4th, 2006 09:04 PM
by jesZee Go to last post
2 132
Queries by Altysha
5 d) Create a query to show the name of the company whose price changed most during the month of July and whose headquarters are in New York. (Hint: Use the...
October 4th, 2006 09:08 PM
by KARL DEWEY Go to last post
1 125
Eliminate duplicate values from details table by Randy
Access 2000. I have a main table and a details table, The main table is for employee Id, Date, District Id, and expenses. etc. The details table list the...
October 4th, 2006 09:16 PM
by Randy Go to last post
0 99
SQL - UPDATE statement help.... by awrex
update mailstops set blgdid = (select bldgid from tblbldg) where mailstops.bldg_abb = tblbldg.bldg Can anyone tell me why I get a parameter pop window when I...
October 4th, 2006 09:37 PM
by awrex Go to last post
7 165
Multi-Average Query by Ripper
I have a table, tblCBAs, which contains results from a curriculum based assessment given at the end of each grading period. I joined that with tblStudents...
October 4th, 2006 10:36 PM
by Ripper Go to last post
2 84
calculated field by mbynoe
I am trying to create a formula that will take the day before value and add it todays value...and continue to calculate for the previous day. -- Marion Bynoe
October 4th, 2006 10:48 PM
by mbynoe Go to last post
2 102
Select distinct e-mail address from 1 table with 2 columns/e-mail to 1 column/e-mail by NielsM
Hello all, I need some more help.....have a table with the following fields: ID : autonumber Title : text FirstName : text LastName : text OrganisationName :...
October 4th, 2006 11:07 PM
by NielsM Go to last post
0 106
Update Record from Query (Max Needed in a Field) by Matthew
I'm building a database from scratch (to replace a spreadsheet), and I have a basic understanding of databases and SQL. The problem that I am having is that...
October 5th, 2006 04:20 AM
by Duane Hookom Go to last post
1 91
Crosstab query problem by [email protected]
I have a crosstab query which I am using as my recordsource for a report I have. Because sometimes I have more or less columns in my query I get the following...
October 5th, 2006 04:27 AM
by Duane Hookom Go to last post
2 115
Global Query Criteria via Function by Suthee
Hi all, I have a table in my application that allows a user to define "custom criteria" to be used in many query objects. This table is accessed via a...
October 5th, 2006 05:04 AM
by Suthee Go to last post
0 91
Criteria from 2 fields to display one result by TKM
I need to retreive a Transaction Type (field named HLP_TEXT) based from the following two fields. 1. TR_NO (has 4 digits such as 3112, 4009 or any other 4...
October 5th, 2006 07:11 AM
by Marshall Barton Go to last post
4 94
Eliminate duplicates in query by Randy
Access 2000. I have a main table and a details table. The main table has: EmployeeID, CurrentDate, Expenses. The details table has: CustomerID, Fees,...
October 5th, 2006 08:29 AM
by [email protected] Go to last post
1 97
Parameter querie, is this possible ? by Perag
Hello, currently the parameter is looking like this . Input will be like "300" and It will then return the data belonging to this department. My...
October 5th, 2006 11:00 AM
by Perag Go to last post
2 88
Duplicates in One Field by SBow
I have searched and read all the documents on Duplicates but they are not full helping me with my question. I have a query that has 3 fields, Name, Number,...
October 5th, 2006 12:35 PM
by John Spencer Go to last post
2 72
Find and replacing numerical values of varying lenth by Dave Barker
I have a table of over 50k entries that are linked to various categories by the category ID number. I need to re-map this entries to new category ID's the...
October 5th, 2006 02:48 PM
by David F Cox Go to last post
5 122
Post New Thread


Display Options
Showing threads 20001 to 20020 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:25 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.