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
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
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
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
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
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
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
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
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
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
previous Sundays date in visual basic by KL
Can anyone pls help with calculating the previous Sundays date in visual basic, I need this as a default value in text box. Thanks.
October 4th, 2006 06:57 PM
by Klatuu Go to last post
5 90
Beginner Total Query Question by ferde
I have a table with two fields. .... DATE and ROOM. I would like to total the number of hospital rooms completed on each floor on a specified date. I...
October 4th, 2006 06:41 PM
by ferde Go to last post
2 180
Dividing sum by 2 by JeffH13
I have a query that accumulate the sum of material. The query has Material, Qty(sum), Assemble (Check Box) which is set to 'NO' and Material Type. If the...
October 4th, 2006 06:09 PM
by geebee Go to last post
3 100
Query criteria: reformat date from Calendar Control to yyyy/mm/dd by PHBoliou
Using MSCAL.calendar.7 as calendar control in form. Need to use date selection output as criteria in query... need to reformat date in critieria to...
October 4th, 2006 05:39 PM
by Van T. Dinh Go to last post
1 97
How do I perform a date lookup and calculation in ACCESS by st0rm
I have two tables:- table(A) contains a date and a numerical value which can change at varying intervals (weeks, month etc.) Table(B) contains "date" (daily...
October 4th, 2006 05:38 PM
by Marshall Barton Go to last post
1 85
Frech, Spanish, Deuch accents on a query by Warrio
Hello! How is possible to type for example "à uinetas" and find a record stored in the database as "á uiñetas"? I'm looking to remove all the accents (or at...
October 4th, 2006 02:09 PM
by Warrio Go to last post
4 142
Query to calculate the percentage by [email protected]
Hi, I have a table with field physical damage (number) and this can be either 0,1 or 2. I need to calculate the percentage of occurrance for when is 1 and...
October 4th, 2006 01:58 PM
by [email protected] Go to last post
2 117
Which Access Query is more efficient? by Husker
Both queries perform the same function (at least it appears that way). Which query is better from a performance stand point. #1 SELECT...
October 4th, 2006 01:54 PM
by David F Cox Go to last post
8 134
Automatic saving of redesigned queries by LarsM
I once had a macro, where I first used a query to create a temporary table, then made use of this temprary table in some append queries to add records to...
October 4th, 2006 12:59 PM
by LarsM Go to last post
0 85
repeat previous record if blank by dan
Good morning, I am trying to create a query which lists the price per day for a date range. If there is no price for a particular date however, I wish it to...
October 4th, 2006 11:19 AM
by dan Go to last post
0 89
Make new table increment 1,3,5 by Garry
Hi all, I am making a new table from a query O.K. Upon running can I input the number of records I wish to be copied (say first 500). At the same time can I...
October 4th, 2006 08:58 AM
by Garry Go to last post
3 119
Post New Thread


Display Options
Showing threads 23281 to 23300 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 06:59 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.