Running & Setting Up Queries - Page 2059

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
DateDiff in SQL by E. D. Hi I'm using DateDiff() in an expression in a query which works well until I try to use the SQL as the source of a report. (I'm using Access 2K) I get an...	September 7th, 2004 02:47 AM by E. D.	2	179
most recent date by ok I've seen tons of answers to this question but none of them really work for my purpose, or I just simply don't understand. Here's what I'm trying to do: I...	September 7th, 2004 01:55 AM by	2	619
Query Calculation Doesn't Get Put Into Table by Doug MacDonald I have a table named tblPerfArtsCamps as follows: PerfArtsCampsID AutoNumber CampDate Date/time Season Text ********* I have a query based on...	September 7th, 2004 01:13 AM by John Vinson	3	137
Query for most recent entry by Janet I am creating an online database for our school employees to be able to enter their walking miles every week. I'm doing this using a web page, form, and then...	September 6th, 2004 11:39 PM by John Spencer (MVP)	2	120
First of and last of help! by C Tate I am a little confused by the 'first of' and 'last of' options when using the totals in queries (despite having done a search in this group and reading the...	September 6th, 2004 10:53 PM by Douglas J. Steele	5	150
Stock list by Lasse T I hope I can explain this with my limited english. I´m trying to create a stock list. So far I have 3 sum queries. One to calculate purchased items, one to...	September 6th, 2004 09:59 PM by Albert D. Kallal	1	250
Totals in select queries by mtress I've done a query which gave me sums of quantities for different items. Now how do I get a grand total for all the sums, in the same query?	September 6th, 2004 09:17 PM by John Vinson	3	106
Additem Workaround in 97/2000 by Spammastergrand I found a common workaround for the lack of additem in Access 97 and 2000. Tablebox is the combo box I'm populating. Fields are a little harder. You have to...	September 6th, 2004 08:52 PM by Albert D. Kallal	2	205
Apostrophe in a text field causes error in query by Alp Hi Experts, Back again. I have a query that refuses to proceed when there is an ' in a text field it needs to process. Any help or guidance to resolve this...	September 6th, 2004 07:35 PM by Alp	9	532
Query when no records by Lasse T Hello. I hope someone can help me with this. I´m experiencing some problems trying to calculate stock. I make a query based on the items table, the order table...	September 6th, 2004 06:52 PM by Lasse T	3	138
Trouble with Delete Query by ChuckW Hi, I have two tables. One is called Attendees and the other is called MailingList. They both have a common field called ID. There is a check box on a form...	September 6th, 2004 05:37 PM by Ken Snell [MVP]	2	111
Text to Column function in Access by Chris Hello, I have a Column called City State Zip that houses the info in this format. City, ST, Zip. I am trying to create a query that will seperate the...	September 6th, 2004 05:19 PM by Allen Browne	1	221
Split info in one field into two fields? by Stranger Currently employee names are in the field empfirstname. Is there an easy way to move the employee last names into the field emplastname? thanks.	September 6th, 2004 04:35 PM by Stranger	4	205
mortgage calculation by jlambert I really need help with a formula to calculate the loan amount based on the mortgage payment, interest rate and term. How would you calculate this in Access...	September 6th, 2004 04:15 PM by Ken Snell [MVP]	1	332
comparing addresses by Alex Hi everyone, would apprerciate some help with following i have a database of addresses, which also contains email address for establishment. We also have a...	September 6th, 2004 04:05 PM by Douglas J. Steele	1	96
Why I get "Type Mismatch" by Kostas Why I get "Type mismatch" with this code (VBA) The 'sale_Date' field is date/time field ----------------- Dim strSQL as String Dim dbs As Database Dim...	September 6th, 2004 03:50 PM by Allen Browne	1	102
"If the user enters something, return something, otherwise return everything" by Chris Mortimore I need a expression for a query thinger. The database has 4 possible values for a field called "Voltage", these values are 11, 33, 0 or NULL (NULL being...	September 6th, 2004 03:35 PM by Chris Mortimore	2	188
Extract data for a date plus tomorrows date by Rick In my table named tblSchedule I have the fields EID (Employee ID), Date and Assnmt (shift to be worked). A new aggreement between management and labor dictates...	September 6th, 2004 03:15 PM by John Spencer (MVP)	3	121
use case or anything else in access by lhjlr Hello is it possible to use thin querie in Ms Access select test case champ = 1 then toto case champ = 2 then tata .... like we can in SQL server or what is...	September 6th, 2004 01:53 PM by Brendan Reynolds	2	117
Between two aleatory or fixed dates by an Hello! I would like a query to field with next condition: Between And , please. Thanks in advance. an	September 6th, 2004 12:59 PM by an	1	126

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