Running & Setting Up Queries - Page 606

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.

Thread / Thread Starter	Last Post	Replies	Views
Last day of month that isn't saturday or sunday by Brent Is there a quick formula to look at a date and calculate the last day of that month that isn't a Saturday or Sunday. Date field is InvDate. Thanks Brent	December 5th, 2005 10:19 PM by Brent	3	155
Query Part of Text Field by cheshired7 I'm sure this is something ridiculous I'm overlooking, but I can't find reference to it in any of our Access support books, nor on various websites. I've got...	December 6th, 2005 01:04 AM by Tom Ellison	5	105
Updating records in a table by RobertM I want to create a query that will update all records in a table that are null by an incremental value. In other words I'll run a report on Monday and run a...	December 6th, 2005 01:19 AM by fredg	1	78
recordset from a query on a query not updateable by Jonathan I have a simple table and have built two queries on this table each of which filters for a different condition. I've then put both of these queries in a new...	December 6th, 2005 03:50 AM by Duane Hookom	1	81
mulitple select list query by Newbie Hello, I have a simple salesperson and sales history query. How can I create a form and subform like the following: Main form has the first select from...	December 6th, 2005 05:17 AM by Tom Ellison	1	58
More help with A Not so simple - Max Function by jonefer In reference to the recent post "Need help with a Max function" - I'm glad you confirmed that that works. That is how I intended to run a MAX date query (but...	December 6th, 2005 05:38 AM by jonefer	5	94
Find matching rows (54 columns) by CoCoNutt I have a table that has 54 columns in it. I would like to know how to see how many of the records have complete identical records in all 54 columns. Is there...	December 6th, 2005 06:43 AM by Tom Ellison	8	130
Research on Date in a query by halima Hello, In my table called billed date: I would like to see all bills =90 days (and =90 days) from bill_date I have tried the = DateAdd("d", 90,...	December 6th, 2005 08:01 AM by halima	6	124
query calculation problems by papa jonah I have created a query (qryProactive) based on left joins among three other queries. The resultant information is generally correct in that I get the proper...	December 6th, 2005 09:56 AM by terryh70	2	75
Invalid Argument in select queries by Corey Leonard Pendleton On Friday I posted this: --An Access 2003 query that has been working fine, began throwing Error 3001, Invalid Argument when it is run. It is a Make Table...	December 6th, 2005 10:30 AM by Database User	2	129
formatting results in a union query by DowningDevelopments this is probably really simple! I have a union query which lists financial data as either credit or debt, so a cheque paid into the acount is a credit and an...	December 6th, 2005 11:12 AM by DowningDevelopments	2	91
Access should provide folders to group queries and tables by Nicknate Right now in Access you can create a favorites list to show favorite queries, tables, forms, etc. But my problem is that often I have my own queries in...	December 6th, 2005 11:23 AM by Van T. Dinh	4	104
CAN I READ DATA DIRECTLY FROM ACCESS TO EXCEL??? by benton via AccessMonster.com Is there a way I can read data directly from an access query to excel without having to import it to excel??? -- Message posted via...	December 6th, 2005 12:26 PM by Travis	1	76
Average with Time intervals by Susan Hello, I posted (creating relationships with time series) yesterday within "access Database Design". Basically I have 24 tables that are linked to txt files... ( 1 2)	December 6th, 2005 12:36 PM by John Spencer	11	331
READ ONLY ON NETWORK by scoobydo Hi I am fairley new to Access and urgently need some help. I have built a database comprising of various queries, forms and reports which is stored on a...	December 6th, 2005 01:24 PM by jacksonmacd	2	81
Combine two Access files of the together in one by atlskw aIhave a web site with the database file that I download and update. I need to combine all the customers data before I upload a new one becuase the files are...	December 6th, 2005 01:45 PM by Jeff Boyce	1	212
Access not returning all rows on most desktops. by Big Red I have a VBscript that has been modified to work on 3 different Oracle views, and all 3 work great on my desktop. I have 1 of them, that only hits 1 Oracle...	December 6th, 2005 03:19 PM by Big Red	1	62
Problem running a query by ×§×•×‘×¥ hello! I'm trying to run the following query, but I get an error message: The code: Dim oDataBase As DAO.Database Set oDataBase = OpenDatabase("C:\Program...	December 6th, 2005 03:44 PM by Duane Hookom	1	277
Type Mismatch by JeffMKlein I have a query that returns dates and times. in this query i have a field that creates a time ("9:00:00 PM" AS EndTime). This is a value that is needed in...	December 6th, 2005 04:45 PM by John Vinson	2	73
Complex WHERE clause by Edgar Thoemmes Hi I have the following SQL which I need to amend to do the following 1. Exclude all records where . = 4301005 and .LocCurrAmt is less than 75 2. Exclude...	December 6th, 2005 05:06 PM by Marshall Barton	1	178

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed