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
Append without duplicating with condition on many fields by anil
hi all I am using this query in VBA to append records from tblImport into tblResults: STR="INSERT INTO tblResults ( ResultRemarks, LabsampleNO,...
November 22nd, 2006 10:42 PM
by anil Go to last post
2 92
Query query ... by Jon Rowlan
I have two tables, both linked on Customer Code. To isolate the items that are common to both I use a straight forward query (it uses an Inner Join) To...
November 22nd, 2006 10:41 PM
by Jon Rowlan Go to last post
2 76
Rows Retrieved In A Query by Tanya
Is there a way to limit the number of rows retrieved in a query? -- Tanya
November 22nd, 2006 08:57 PM
by Tanya Go to last post
2 67
Combine Related Queries ??? by Gwen H
Is there a way to compose the following queries? Query 1 selects all employees from the Employees table, and then sums their assigned deposit accounts from...
November 22nd, 2006 08:39 PM
by Gwen H Go to last post
2 72
2000 Compact Error 3799 by Jen
I am getting the following error while trying to compact an Access 2000 database. This just started happening and I have made no changes to the...
November 22nd, 2006 07:55 PM
by Jen Go to last post
0 60
symbol " " by Randy
Hi I see a symbol " " in a Access Database Queries field, what does it mean? What kind of condition? Thanks,
November 22nd, 2006 06:55 PM
by John Vinson Go to last post
2 67
Day and night patrol hours by day by Matthew P
Hello! First off, this is a repost of an earlier request with modifications. I have data set up in the following format: Area | Start | Stop Area is one of...
November 22nd, 2006 06:50 PM
by Matthew P Go to last post
5 102
Functions by aMack
Is there a list of Access functions somewhere? -- A MACKENZIE, CMA, MBA
November 22nd, 2006 05:54 PM
by Klatuu Go to last post
2 59
Duplication of information on some information by jrp444
When I run the below query I get duplicate information on some of the accounts that it pulls up. Can anybody tell me what I need to do to stop this...
November 22nd, 2006 05:41 PM
by jrp444 Go to last post
4 83
Counting occurrances in a chart by hotplate
Hi, I am making a chart using a trend line format. I am counting the number of occurrances per day. Days with no occurrances should give me a zero, but...
November 22nd, 2006 05:18 PM
by Duane Hookom Go to last post
5 82
Weekly Trends By Hour by CevinMoses
I work in a factory as a foreman. I am building a Dashboard-style Report, and one of the graphs I want to include is a look at whether or not we have better...
November 22nd, 2006 04:56 PM
by Bruce Meneghin Go to last post
3 78
finding two substring and replace only one by Arts
I have strings containing values: C1+2a(i) and +2a(i) both with other letters in the beginning and end of the string ex. B1C1+2a(i)XX I want to replace +2a(i)...
November 22nd, 2006 04:25 PM
by Arts Go to last post
2 72
Interesting problem, maybe... by Gina Whipp
Hello All, I have a query that shows: VendorName SpecificationID Vendor A-101 Vendor A-200 Vendor B-400 What I would like...
November 22nd, 2006 03:40 PM
by Gina Whipp Go to last post
2 69
Count by Dan @BCBS
I need to find the top 20 most used answers. In this case the answers are procedure codes. Is there a way to do a frequency for each code, then report out...
November 22nd, 2006 02:10 PM
by John Spencer Go to last post
2 52
COMBO BOX - IF/THEN STATEMENTS by childe51
I have a combo box in a form with values pre-entered. Depending on which value the user pulls in the first combo box, I would like a second combo box to pop...
November 22nd, 2006 01:55 PM
by John Spencer Go to last post
2 73
Query by Paid The Umpire
Quick question, I've got the below SQl statement which works well, except I want the "CountOfOuts" to count all the values in the table except those which have...
November 22nd, 2006 01:43 PM
by John Spencer Go to last post
1 80
Size of Query result by Rolf Rosenquist
I have a crosstab query that presents the result as a data sheet view. On my computers I can drag the size to what I want and then save the design and it has...
(Multi-page thread 1 2)
November 22nd, 2006 10:41 AM
by Rolf Rosenquist Go to last post
13 157
Protecting queries by C Tate
Is it possible to protect my queries from alteration? I don't want to create an MDE file because I still want them to be able to access the database window...
November 22nd, 2006 09:39 AM
by C Tate Go to last post
3 60
Cumulative total problems by Rob
I am trying to add a cumulative total column into an existing query. Every time I try to run the query below Access shuts down. Is there a problem with the...
November 22nd, 2006 09:26 AM
by Gary Walter Go to last post
1 75
Age Distribution based on Birthdate field by TKM
I have one table that has field "Birthdate" I have another table with two fields Age of Retiree and Distribution Factor. I need to find the Distribution...
November 22nd, 2006 05:40 AM
by John Vinson Go to last post
1 69
Post New Thread


Display Options
Showing threads 22081 to 22100 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 02:57 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.