Running & Setting Up Queries - Page 199

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
Concatenating two fields in Make-Table query by Jim Hank I have a table that has the fields FIRST NAME and LAST NAME, and would like to use a Make-Table query that creates a new table that has all the... ( 1 2)	December 21st, 2004 02:53 AM by Edward G	13	214
Aging Report by Stefan I have a summary query which has 2 fields I am grouping by the due date and summing AmountDue However I need to create a 0-30 30-60 60-90 90 day...	December 21st, 2004 02:53 AM by MGFoster	1	87
Show all cumulative end of month quantites by neenmarie I have a table that stores all inventory transactions. Each record shows either a positive or negative quantity to add or delete inventory of specific part...	December 21st, 2004 05:55 AM by neenmarie	3	112
update query to conditionally alter the value of cells by DowningDevelopments Hello everyone, I am trying to alter the value of a field where, due to my own errors in the input field, users have been able to input incorrect values into a...	December 21st, 2004 09:29 AM by DowningDevelopments	3	145
Increment a Counter and reset it by Ten Twenty via AccessMonster.com Increment a Counter and reset it at some stage when the group change: I wrote a powerlifting system but have run into some problems and it all boils down to...	December 21st, 2004 10:23 AM by Ten Twenty via AccessMonster.com	3	210
criteria - exclude by VilMarci Hi, I need to distribute interview dates. Have a table...	December 21st, 2004 12:22 PM by VilMarci	3	140
Using a variable value in an SQL statement by R the D I'm trying to constuct an SQL statement in VBA code to create a table in a separate database. I have stored the path and name of the destination database in a...	December 21st, 2004 12:29 PM by R the D	2	227
Add zeros and remove hyphens by Ellen Hello, I have a field of CAS# numbers, which identify chemicals. These numbers can exist either as a nine digit number or a number with hyphens between...	December 21st, 2004 01:33 PM by Ellen	3	226
Only weekdays in datediff by Y Beckers via AccessMonster.com I have this Query, SELECT DateDiff('w',,) AS Expr1, * FROM Dat WHERE DateDiff('w',,); Now i want to count only the weekdays, so exclude the weekenddays. How...	December 21st, 2004 02:28 PM by Edward G	6	164
append query repeats some lines by jonmarcr Hi there, i've written a database that takes input from an external source and prepares it for use within our business. If say I import 400 records 380 will...	December 21st, 2004 03:23 PM by jonmarcr	2	86
convert 'yyyy ww' to an actual date by neenmarie I use the following format to get the totals of a field by week. Format$(.,'yyyy ww') This allows me to sum all records within a week...and shows the date as...	December 21st, 2004 05:12 PM by sandip	6	154
test for string by RickM Still working on the same problem. Known error between SCO Unix and Informix when being read by Microsoft Access. Example. Informix displays 72.599999 in...	December 21st, 2004 06:18 PM by Ken Snell [MVP]	4	132
Case Sensitive in a Criteria with Like by MMesarch Hi, I have a field that included a complete citation of a publication. This means it can have multiple authors listed,title of article and publication, among...	December 21st, 2004 08:10 PM by John Vinson	3	90
Viewing records for a certain date range. by Mayra I am trying to view records from 9/1/04 to 11/30/04 and for some reason when I do this nothing comes up. I currently have it set up to view the records from...	December 21st, 2004 08:14 PM by John Vinson	2	216
New Question by Brian Lyons I have two fields that say this: LoanGoals: IIf(=350000,"YES") DepositGoals: IIf(=300000,"YES") Now, in order for the loan officers to receive their...	December 21st, 2004 08:38 PM by Duane Hookom	1	113
use wildcard with parameter? by el zorro I have a query that reads a parameter from a form. For ex, if the user input the language "Bosnian" on the People form, the Query shows all records with...	December 21st, 2004 08:48 PM by John Vinson	1	90
could not delete from specified tables by mccloud I have two tables with an interjoin. dbo_IMINVLOC_SQL and dbo_IMITMIDX_SQL. The first is an inventory table based on location. The second is a...	December 21st, 2004 09:33 PM by mccloud	0	113
User Defined Queries by tvt I would like to create a user defined query, where the USER gets to choose specific criteria on which they wish to query. This means that the user can select...	December 21st, 2004 11:55 PM by tvt	2	399
adding a comma into imported text by Marie I import a text file into my Access database and it is several dates appearing as follows: 2003/032003/042003/05 I would like to insert a comma and a space...	December 22nd, 2004 12:12 AM by John Vinson	3	118
I run a "create query by using wizard" or any wizard I get "Activ. by hippynz I run a "create query by using wizard" or any wizard I get "ActiveX component can't create object" (in Access only)	December 22nd, 2004 12:18 AM by Douglas J. Steele	4	249

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