Running & Setting Up Queries - Page 153

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
diplaying contents of required date and also the sum of contents by naveen prasad[_2_] Good day.. dear all kindly help me in this. I have created a table d1 with fields date, r1,r2 r1,r2 are numeric values. I want to display contents as per...	September 22nd, 2009 06:52 AM by naveen prasad[_2_]	8	212
Find records in a field based on a date range - JCW by JohnW I am looking to be able to run a report that shows who has not paid their bill for the month. I have a paydate field that I want to search in and I want to...	September 22nd, 2009 02:53 AM by JohnW	5	140
Long Date Search - JCW by JohnW I have a field called birthdate that I have formatted for long date so when the user inputs the date as 8/21/1999 the month name August will appear in the...	September 21st, 2009 11:22 PM by JohnW	3	137
Please help to zero filled on file by Duyen I'm being having trouble setting up an update query that would help me update the amount field on my report to zero filled the space. For example: Amount ...	September 21st, 2009 11:19 PM by Duyen	8	175
Parse from Description by Matt Cromer I would like to expand this query to be B followed by any 2 numbers, for example B01, B99, etc. Mid(, InStr(, "B45") + 1) Thank you	September 21st, 2009 10:42 PM by Matt Cromer	4	120
Add time to Date Field by Rita Brasher[_2_] In my table, I have a date column and I also have a time column. I need to join these into one date-time field so that I can do some time comparisons. How...	September 21st, 2009 08:32 PM by Duane Hookom	1	84
Calculation query by LG I posted previous on this but did not really get a response. I have many tables with different fields and some fields are the same. What I need to do is find...	September 21st, 2009 08:02 PM by Duane Hookom	7	163
making a table with a query by Gunther Kint Hi, I've got a problem to make a query. Here is a sketch of the situation. There are two tables: in the first one there are people with a number. In the...	September 21st, 2009 07:37 PM by KARL DEWEY	2	110
Select, Insert, Update, and Delete â€“ SQL Question by ryguy7272 Conceptually, I understand what needs to be happen, but technically, I donâ€™t really know how to do it. Here is my Select statement: SELECT...	September 21st, 2009 07:08 PM by Daryl S[_2_]	1	156
Want the query to figure a future date by diesel I have a table containing three fields, LastName, FirstName, AdmitDate. I want to write a query that will figure the HPDate which is the AdmitDate plus 3...	September 21st, 2009 07:04 PM by KenSheridan via AccessMonster.com	4	139
First table not appearing in append table dropdown by Eirwyn John I am having exactly the same problem with the first table not appearing in append table dropdown when creating an append query. This seems to have come about...	September 21st, 2009 06:10 PM by John W. Vinson	1	170
Difference of 2 tables row sum by naveen prasad[_2_] Dear all, kindly help me in this. I have created 2 tables d1,d2 d1 fields are x1,x2; d2 fields are y1,y2;	September 21st, 2009 05:03 PM by naveen prasad[_2_]	3	134
Main Table References Another Table Multiple Times by nogreatnamesleft I have a main table with several fields for people - i.e. Engineering, CAD, Manager, etc. The fields contain a number to represent an individual. A separate...	September 21st, 2009 04:43 PM by nogreatnamesleft	4	154
Concatenating with and without comma by Owl I want the comma to appear ONLY when there is an appartment address AND a street address. I can't seem to get rid of the comma when there is only a street... ( 1 2)	September 21st, 2009 04:18 PM by Clifford Bass[_2_]	12	201
cross tab by subs how to join the following two cross tab queries by SQL? pl s help TRANSFORM Avg(.SumOfPAID_AMT) AS AvgOfSumOfPAID_AMT SELECT .OCITY FROM GROUP BY...	September 21st, 2009 03:05 PM by Jerry Whittle	1	119
The use of "Like" by Frank Situmorang[_3_] Hello, I just want to make my query to look in the memo field name "Note1", the records that has a content of "Jatimulia", but it seems it can not work....	September 21st, 2009 02:48 PM by Frank Situmorang[_3_]	2	143
Making it more user friendly by Herman_KLF[_2_] Hi All I created a query in my database based on the values in a (Yes/No)field. In order to display the records I need, I inserted in the 'Criteria' line the...	September 21st, 2009 02:18 PM by Herman_KLF[_2_]	2	127
crosstab queries by subs I am trying to join the following cross tab queries below- What will be the SQL statement be? TRANSFORM Avg(.SumOfPAID_AMT) AS AvgOfSumOfPAID_AMT SELECT...	September 21st, 2009 01:35 PM by John Spencer	1	100
JOins pls help by subs table A carrier price year op 3333 2009 ot 233 2009 op 1200 2008 op1 1400 ...	September 21st, 2009 02:53 AM by subs	4	164
syntax help for SQL where ????? And ?????????? by Billp Hi, I have an sql statement strsql = "INSERT INTO " _ & "(Works_Number" & strOtherFields & ") " _ & "SELECT...	September 21st, 2009 02:52 AM by Billp	3	200

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