Running & Setting Up Queries - Page 119

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
Convert String to Date by Chris I have been given a table with "visit_date" stored as text as follows: 29MAY2009 19JUN2009 06FEB2009 06MAR2009 06FEB2009 I need to convert data to a date...	November 11th, 2009 04:44 PM by John Spencer	1	127
Table View - How Can I see description by Muse In Access 2007 if I right click on table and then select properties I can see the description associated with the table. In the view pane I can see all my...	November 11th, 2009 03:32 PM by Muse	0	129
Query-finding umatched data with duplicates by Solv123 I am trying to compare two tables to find what does not match. However each table may have duplicate items but I need each item to have itsâ€™own match. The...	November 11th, 2009 03:01 PM by John Spencer	5	125
Find start position of the 9th occurance of a character in a str by Mikael Lindqvist[_2_] Good morning everyone, I know that the function "Instr" is very useful for finding starting position of a particular "string" in a string. However, in my...	November 11th, 2009 02:31 PM by Duane Hookom	1	134
Grand Total in a Query by Mike I have a table with two fields Class Type and Number Of Students. I have a query that totals the Number of Students by Class but how do I get a grand total of...	November 11th, 2009 04:23 AM by Duane Hookom	2	142
crosstab with conditional SUM() by elena Hi, All my query: PARAMETERS DateTime, DateTime; TRANSFORM Nz(COUNT(Master.TickNo),0) AS CountofTicks SELECT AS Badge, Sum(Master.AmtVl) AS SumOfAmount,...	November 11th, 2009 04:23 AM by Duane Hookom	1	155
Query Service History/Future Dates by Coyote_Jackson Trying to setup a query which takes into account a list of cars using reg numbers: 1 ---- 2 ---- 3 ---- 4 ---- 5------ up to 100+ cars	November 11th, 2009 03:29 AM by KARL DEWEY	1	146
...cannot use a calculated field in a Where clause... by Need2Know Hello Everyone, Still stumped with a problem I've been trying to resolve since last week. I've posted here before and received excellent assistance but now...	November 11th, 2009 03:28 AM by KARL DEWEY	2	177
crosstab query with Sum -conditional by elena Hi, All my query: PARAMETERS DateTime, DateTime; TRANSFORM Nz(COUNT(Master.TickNo),0) AS CountofTicks SELECT AS Badge, Sum(Master.AmtVl) AS SumOfAmount,...	November 11th, 2009 03:28 AM by elena	0	149
Summary Queries by TP1959 I'm trying to run a simple summary select query to effectively filter out multiple occurrences of database records by Grouping them via the "First" criteria....	November 11th, 2009 03:28 AM by KARL DEWEY	3	112
Data type mismatch in criteria expression issue by Benjamins via AccessMonster.com Hi, I have a query call ListRecur where it will Caculate the date when the entry is going to recur Below it the query Field information DetId (FieldName same...	November 11th, 2009 02:02 AM by Benjamins via AccessMonster.com	2	122
Date parameter question by pat67 I have a query that pulls data. What I am trying to get it to do is pull the data greater than a specific date. Is there a way to do it other than just...	November 10th, 2009 09:50 PM by pat67	2	111
update and append queries by Brett[_5_] I created a few 2007 access queries that would append or update various tables. This is working fine on one machine, but when I installed access 2007 on...	November 10th, 2009 07:23 PM by Jeanette Cunningham	1	119
Crosstab returns blank fields by thehikingfool What am I missing? Here is the SQL: TRANSFORM Sum(Query3SalesConvert.SALES) AS SumOfSALES1 SELECT Query3SalesConvert.MANUFACTURERNAME,...	November 10th, 2009 07:01 PM by thehikingfool	6	138
Subquery Range Lookup by John Keith I could do this in VBA easily, however I want to know the pure-access query syntax for accomplishing this (to allow the range table to be maintained by the...	November 10th, 2009 06:38 PM by John Keith	3	149
RecordsetNot Updateable by Mark A. Sam[_3_] Hello, I have a query as a Recordsource for a form. It originally contained two tables, and with an inner join. It was updateable. SELECT .*,... ( 1 2 3)	November 10th, 2009 06:15 PM by Mark A. Sam[_3_]	22	384
Crosstab Returns Empty Fields by thehikingfool What am I doing wrong here? Here is the SQL: TRANSFORM Sum(Query3SalesConvert.SALES) AS SumOfSALES1 SELECT Query3SalesConvert.MANUFACTURERNAME,...	November 10th, 2009 06:07 PM by thehikingfool	2	157
Make Table Query Truncating Memo Field at 255 Characters by excelCPA I have a lot of data in an Excel spreadsheet that I want to analyze with Access. Many of the data fields are 255 characters. I understand linked tables to...	November 10th, 2009 05:33 PM by Ken Snell	1	138
Data type mismatch in criteria expression even the datatype is the same by Benjamins via AccessMonster.com Hi, I have a query call ListRecur where it will Caculate the date when the entry is going to recur Below it the query Field information DetId (FieldName same...	November 10th, 2009 05:09 PM by John W. Vinson	1	140
Last record by text field of an unsorted table by Nir N I have the followinig simple quwery: SELECT M2001.LASTNAME, M2001.FIRSTNAME, SESSION1.Date FROM M2001 INNER JOIN SESSION1 ON M2001.RECNUM =...	November 10th, 2009 04:51 PM by John Spencer	3	135

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