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 Replies Reverse Sort Order Views
Top Two Items per customer by sg
I have a table called PT tbl. If a client has a status of Unacceptable (a field in the table) for two out of the three most recent dates (PT Date field), I...
(Multi-page thread 1 2)
April 6th, 2010 04:03 AM
by sg Go to last post
18 464
Return a date range based on today's date by BABs
I need to build a query (to be used for eternity) to return records for dates between 01 July (the year prior) and 30 Jun (the current year) based on the...
(Multi-page thread 1 2)
December 1st, 2009 10:40 PM
by BABs Go to last post
18 330
MS Access Query Issue by FA
I have the following query; SELECT dbo_SYS_INFO.SYS_NME, dbo_SYS_INFO.SYS_URL, dbo_SYS_INFO.TEST_BEGIN_DATE,...
(Multi-page thread 1 2)
March 20th, 2006 08:30 PM
by FA Go to last post
17 203
finds gaps in sequential numbers? by Jennifer@DakCo
How do I create a query, in MS Office Access 2000, that will find gaps in manually typed sequential numbers?
(Multi-page thread 1 2)
May 23rd, 2006 06:17 PM
by Pip''''n Go to last post
17 239
Operation Must Use An Updateable Query!? - NOT Permissions - CrossTab!!?? by Bob
running access 2k; mdb w/ linked tables to another mdb (front/back-end); trying to run a query that updates a table FROM information from a crosstab query. I...
(Multi-page thread 1 2)
June 7th, 2006 06:30 PM
by Bob Go to last post
17 479
Creating a function to automated this command! (EMAIL) by [email protected]
Hey guys..... Okay I need to some help with code please....I need to query my database....look for the "DueDate" Field, if it is within the next...
(Multi-page thread 1 2)
June 28th, 2006 11:48 PM
by Ken Sheridan Go to last post
17 185
Need help with Query parameters by form by EmAlbritton via AccessMonster.com
Hello all. I am having a bit of trouble getting my query to work properly. I am trying to run a query (for my report) based on criteria entered on a form. I...
(Multi-page thread 1 2)
October 22nd, 2006 04:35 AM
by EmAlbritton via AccessMonster.com Go to last post
17 214
Combining 84 tables with one query...help! by refreshingapathy
Hello, I'm making a database for my college's radio station. They want each DJ to have his/her own little table to keep track of which songs are played on...
(Multi-page thread 1 2)
October 13th, 2006 09:38 AM
by Douglas J. Steele Go to last post
17 265
TWO Crosstab Query Ouput Questions by TuffyE
These are probably simple and I appreciate the patience of everyone. Yes, I am trying the "search" with no success so far. I'll try to explain in more...
(Multi-page thread 1 2)
November 4th, 2006 02:16 AM
by David F Cox Go to last post
17 156
Left Join not working properly by iTISTIC
I have 3 tables I am trying to join in a query. They are as follows: tblProducts tblCustomerEquipment tblEmployees In SQL Server, this query would produce...
(Multi-page thread 1 2)
January 6th, 2006 10:44 PM
by John Spencer Go to last post
17 322
Running Average by cutthroatjess
I would like to create a running average in a field that takes dated results (10 days from the current field date) and averages them for the current...
(Multi-page thread 1 2)
December 19th, 2005 08:52 PM
by Marshall Barton Go to last post
17 458
How to get data from Analysis Services cubes into Access by Karen Middleton
Our users are keen on using Access Reports/Queries against Analysis Services cubes for formatted reporting. Please let me know how I could connect to Analysis...
(Multi-page thread 1 2)
December 4th, 2004 03:21 PM
by Jamie Thomson Go to last post
17 685
SQL Code Problem by matt donker via AccessMonster.com
Now i have posted this same entry about 3 different ways now and got no response begining to think that this site is useless. What i am trying to do is use...
(Multi-page thread 1 2)
April 11th, 2005 02:45 PM
by Van T. Dinh Go to last post
17 314
Remove text in brackets from query by JanetF
Hello, I have a first name field in a query that has text in brackets after the first name. I would like to remove the brackets and the text within...
(Multi-page thread 1 2)
August 16th, 2005 04:07 AM
by Ken Snell [MVP] Go to last post
17 307
Access 2k/2003: Touble with delete query using WHERE EXISTS by Darin
I have a table that I want to delete specific records from based on data in other tables. I'm more familiar with Access '97, but am now using 2003, but the...
(Multi-page thread 1 2)
August 25th, 2005 06:58 PM
by Darin Go to last post
17 307
"You canceled the previous operation." by Steven L via AccessMonster.com
I've got a form with some comboboxes, five checkboxs and a command button on it. The command button simply launches a query. I'm getting some very strange...
(Multi-page thread 1 2)
September 1st, 2005 01:26 PM
by Steven L via AccessMonster.com Go to last post
17 267
Parameter default value by [email protected]
Any ideas how to retrieve a parameter's default value for an Access/Jet PROCEDURE a.k.a Parameter Query (PARAMETERS declaration)? I created the proc/Query...
(Multi-page thread 1 2)
October 4th, 2005 08:06 AM
by [email protected] Go to last post
17 193
Need to select a certain X records after a query in access by ab
I have a table of data (.CSV file) that I'm trying to use Access 2003 to analyze. Each record within the table is essentially a business day (Monday-Friday)...
(Multi-page thread 1 2)
October 11th, 2005 03:05 PM
by ab Go to last post
17 690
Delete query doesn't!! by Ron Le Blanc
I have an Access 2003 database that has several tables in it that are all related to a client table and have the cascade delete enabled. I wish to delete all...
(Multi-page thread 1 2)
December 30th, 2005 09:17 PM
by BenDD Go to last post
17 190
Use first record found in expression? by CASJAS
My calculation is coming up with two different values for the following SQL: SELECT A.ID, A.Site, A., A., A., ((C.-B.) /(C.-B.))
(Multi-page thread 1 2)
July 22nd, 2004 09:21 PM
by Tom Ellison Go to last post
17 2,063
Post New Thread


Display Options
Showing threads 201 to 220 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 09:55 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.