Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

microsoft.public.access.queries | Forum profile

Forum profile page for microsoft.public.access.queries on http://www.microsoft.com/communities/newsgroups.... This report page is the aggregated overview from a single forum: microsoft.public.access.queries, located on the Message Board at http://www.microsoft.com/communities/newsgroups.... This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period. Additional forum profile information for "microsoft.public.access.queries" on the Message Board at http://www.microsoft.com/communities/newsgroups... is also shown in the following ways:

1) Latest Active Threads
2) Hot Threads for Last Week

Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.

Site: Discussions in microsoft.public.access.queries - microsoft.public.access.queries (site profile, domain info microsoft.com)
Title: microsoft.public.access.queries
Url: http://www.microsoft.com/communities/newsgroups...
Users activity: 31 posts per thread
Forum activity: 82 active threads during last week
 

Posting activity on microsoft.public.access.queries:

  Week Month 3 Months
Threads: 82 357 1,309
Post: 195 960 4,011
 

microsoft.public.access.queries Posting activity graph:

Posts by:  day  week  month 

Top authors during last week:

Name
Posts
KARL DEWEY
44
user's latest post:
Create update query for...
Published (2009-11-05 16:47:00)
  >>I was trying to add the 1 in the query until it equals the 20 and then stop. What field in table 2 is it being add to? How about posting the SQL of your query. -- Build a little, test a little. "accesshacker" wrote: > The query I have been working on is populating the 1. No fields are being > reduced to zero. Table #1 is only a holder for what is remaining. I am > testing right...
Dale Fye
12
user's latest post:
200 results per page in...
Published (2009-11-06 07:52:00)
  What do you mean by "publish those results"? Do you want to display these results in a report? If so the only way to get 200 of anything on a page would be to use Karl's suggestion. Or do you want these results to be posted to an Excel file, 200 records per page? Or something else? ---- Dale "Biss" wrote: > Access 2007 > > I have a simple table that has about 2,300...
Jerry Whittle
11
user's latest post:
IIF statement with DCount...
Published (2009-11-05 07:10:00)
  What happens when you run just the following? DCount("*","Deductions") It should return the number of records in that table. If that crashes there's a possibility that your database is corrupt. First make a backup copy then do a Compact and Repair. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Brad P" wrote:...
John Spencer
11
user's latest post:
search criteria in query in...
Published (2009-11-04 15:32:00)
  Try the following criteria Not Like "########" Or Is Null or optionally you could use Not Like "[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]" or Is Null John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County Todd wrote: > I've got an access dbase that has a link to an sql dbase table. I didn't > create the sql table and...
KarenY
9
user's latest post:
Replacing * in order number in...
Published (2009-10-30 13:44:00)
  Perfect! thanks a million ! "John Spencer" wrote: > IIF([C0] like "[*]*","HP" & Mid([CO],2),[CO]) > > OR you could use > > IIF(Left([C0],1) = "*","HP" & Mid([CO],2),[CO]) > > John Spencer > Access MVP 2002-2005, 2007-2009 > The Hilltop Institute > University...
Duane Hookom
9
user's latest post:
where clause in...
Published (2009-11-08 19:43:00)
  When suggesting there is an error, always provide the error and/or results. Why are you mentioning "control"? Are TimeStart and DateAppointment both date values? Are either of them Null? -- Duane Hookom Microsoft Access MVP "Sam" wrote: > I am trying to view records where the date value of one control equals that > of another. The following clause causes an error: > >...
Dani2009
6
user's latest post:
Calculate Previous Balance as of...
Published (2009-11-02 08:42:00)
  I tried to follow the steps, I created a query with the SQL indicated, but when I connect the query with the report, I get a message that says "Multi-Level GROUP BY clause is not allowed in a subquery" "Allen Browne" wrote: > You can use a subquery to calculate the sum of previous transactions. > > Type an expression like this into the Field row in query design: >...
Marshall Barton
6
user's latest post:
...efficient method of finding...
Published (2009-11-04 15:32:00)
  Need2Know wrote: >Good Morning All, Is there a more efficient method of finding closest >date between unrelated tables? Any assistance provided is greatly >appreciated. Thank you all in advance. > > SELECT TOP 1 tbl1.[SomeDte], tbl2.[SomeOthDte] > FROM tbl1, tbl2 > WHERE tbl1.[SomeDte] < tbl2.[SomeOthDte] And tbl2.[SomeOthDte] >Between tbl2.[SomeOthDte] And...
Daryl S
6
user's latest post:
find exact match or match those...
Published (2009-11-06 11:10:00)
  Hoachen - Yes, this can be done, but I would worry about multiple matches occurring... I also don't like the special characters in the field names... To do what you want, make the query an inner join, but don't join on the Dep$ = Return$ at all. Then add a field in your query for ABS([Dep$] - [Return$]), and set the criteria to <=0.10. You can test this, and then uncheck the 'Show' box for this new field...
vanderghast
6
user's latest post:
Error in syntax in...
Published (2009-11-06 07:05:00)
  You second SELECT is missing its FROM clause; try adding FROM Competitors just before the last GROUP BY. Vanderghast, Access MVP "Hugh self taught" <Hughselftaught@discussions.microsoft.com> wrote in message news:B76B9916-EC93-498A-99B4-5705E2EBE250@microsoft.com... >I was given this sql code but have the following error which I can't >resolve.. > > "The...
 

Latest active threads on microsoft.public.access.queries::

Discussions in microsoft.public.access.queries
Started 1 day, 13 hours ago (2009-11-08 19:43:00)  by Duane Hookom
When suggesting there is an error, always provide the error and/or results. Why are you mentioning "control"? Are TimeStart and DateAppointment both date values? Are either of them Null? -- Duane Hookom Microsoft Access MVP "Sam" wrote: > I am trying to view records where the date value ...
Thread:  Show this thread (2 posts)   Thread info: where clause in microsoft.public.access.queries Size: 1,053 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: where clause in microsoft.public.access.queries :: microsoft.public.access.queries :: Discussions in microsoft.public.access.queries"
Discussions in microsoft.public.access.queries
Started 2 days, 3 hours ago (2009-11-08 05:17:00)  by anlu
Hi, I see two immediate issues with your sql: First of all, there is a semicolon in your statement - I think Access interprets this as an end of sql marker. Secondly, a GROUP BY clause should come after the WHERE clause. Hope this helps... Regards, anlu "acss" wrote: > My last post did...
Thread:  Show this thread (2 posts)   Thread info: Characters found at end of sql  error-Repost in
microsoft.public.access.queries Size: 2,971 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Characters found at end of sql  error-Repost in
microsoft.public.access.queries :: microsoft.public.access.queries :: Discussions in microsoft.public.access.queries"
Discussions in microsoft.public.access.queries
Started 2 days, 19 hours ago (2009-11-07 13:35:00)  by anlu
Hi Steve, To find the persons with exactly 1 transaction you can use this sql (where you should substitute tblPersonTrans with the name of your table: SELECT tblPersonTrans.PersonIDNum FROM tblPersonTrans GROUP BY tblPersonTrans.PersonIDNum HAVING Count(tblPersonTrans.TransactionType)=1; Regards, anlu...
Thread:  Show this thread (7 posts)   Thread info: Query to Find Records with only 1 transaction in
microsoft.public.access.queries Size: 1,572 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Query to Find Records with only 1 transaction in
microsoft.public.access.queries :: microsoft.public.access.queries :: Discussions in microsoft.public.access.queries"
Discussions in microsoft.public.access.queries
Started 2 days, 20 hours ago (2009-11-07 13:04:00)  by anlu
Hi Tamara, If I have understood your problem correctly, one way could be like this: 1) Create a table containing all the dates you want to count - if these are successive in some interval, you can easily generate the dates in Excel and import them to a table. I'll assume that the table is called "tblDate" and the column ...
Thread:  Show this thread (2 posts)   Thread info: Trying not to run multiple queries in microsoft.public.access.queries Size: 2,944 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Trying not to run multiple queries in microsoft.public.access.queries :: microsoft.public.access.queries :: Discussions in microsoft.public.access.queries"
Discussions in microsoft.public.access.queries
Started 3 days ago (2009-11-07 08:23:00)  by Beetle
> He would like them to display only one line, and then click on the right to > open them and make the selection Which sounds like exactly what a combo box does, so why not just use a combo box? -- _________ Sean Bailey "Nick Dakoronias" wrote: > Hello Forum users, > Any advise on ...
Thread:  Show this thread (2 posts)   Thread info: Ms Access List boxes in microsoft.public.access.queries Size: 1,388 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Ms Access List boxes in microsoft.public.access.queries :: microsoft.public.access.queries :: Discussions in microsoft.public.access.queries"
 

Hot threads for last week on microsoft.public.access.queries::

microsoft.public.access.queries
Started 6 days, 1 hour ago (2009-11-04 07:50:00)  by KARL DEWEY
In design view use this calculated field -- My_Check: Len([assetid]) and use criteria <8 -- Build a little, test a little. "Todd" wrote: > I've got an access dbase that has a link to an sql dbase table. I didn't > create the sql table and I'm just linked to it so I can run ...
Thread:  Show this thread (8 posts)   Thread info: search criteria in query in microsoft.public.access.queries Size: 1,572 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: search criteria in query in microsoft.public.access.queries :: microsoft.public.access.queries :: Discussions in microsoft.public.access.queries"
microsoft.public.access.queries
Started 4 days, 20 hours ago (2009-11-05 12:18:00)  by KARL DEWEY
Post the table name, field names, datatype, and sample data. How do you expect to allocate 20 into 39? 5 into 39? -- Build a little, test a little. "accesshacker" wrote: > Need to create an update query that will add records to a table that when > summarized equals the amounts in another table when ...
Thread:  Show this thread (7 posts)   Thread info: Create update query for remaining records in
microsoft.public.access.queries Size: 1,517 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Create update query for remaining records in
microsoft.public.access.queries :: microsoft.public.access.queries :: Discussions in microsoft.public.access.queries"
microsoft.public.access.queries
Started 2 days, 19 hours ago (2009-11-07 13:35:00)  by anlu
Hi Steve, To find the persons with exactly 1 transaction you can use this sql (where you should substitute tblPersonTrans with the name of your table: SELECT tblPersonTrans.PersonIDNum FROM tblPersonTrans GROUP BY tblPersonTrans.PersonIDNum HAVING Count(tblPersonTrans.TransactionType)=1; Regards, anlu...
Thread:  Show this thread (7 posts)   Thread info: Query to Find Records with only 1 transaction in
microsoft.public.access.queries Size: 1,572 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Query to Find Records with only 1 transaction in
microsoft.public.access.queries :: microsoft.public.access.queries :: Discussions in microsoft.public.access.queries"
microsoft.public.access.queries
Started 6 days, 22 hours ago (2009-11-03 10:34:00)  by KARL DEWEY
>>an append query that re-enters the records in the correct order of EmployeeID and IncidentDate Why do you care the order they are in the table? Try this select query --- SELECT qryTotalDetail.EmployeeID, qryTotalDetail.SSN, qryTotalDetail.INCIDENTDATE, qryTotalDetail.TYPE, qryTotalDetail.POINTVALUE, (SELECT Count(*) ...
Thread:  Show this thread (6 posts)   Thread info: Custom Counter in microsoft.public.access.queries Size: 2,900 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Custom Counter in microsoft.public.access.queries :: microsoft.public.access.queries :: Discussions in microsoft.public.access.queries"
microsoft.public.access.queries
Started 1 week, 1 day ago (2009-11-02 05:47:00)  by John Spencer
Between [Enter Start Date:] And [Enter End Date] Or >=[Enter Start Date:] And <=[Enter End Date] Also you might want to change Total: Group By to WHERE under the End_Date field. John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County Philip...
Thread:  Show this thread (5 posts)   Thread info: Between date with greater than or eaqual to in
microsoft.public.access.queries Size: 2,538 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Between date with greater than or eaqual to in
microsoft.public.access.queries :: microsoft.public.access.queries :: Discussions in microsoft.public.access.queries"
microsoft.public.access.queries
Started 1 week, 1 day ago (2009-11-01 19:35:00)  by BB
Ellen The simplest solution to your question is to have a column in your query (in grid design view) where... FIELD ROW: Format([MyDateField],"mmm yyyy") CRITERIA ROW: [Enter Month to Run Query for (eg Nov 2009)] (The statement "Enter Month..." is in square brackets and thus is a user enterable parameter)...
Thread:  Show this thread (5 posts)   Thread info: Parameter month query in microsoft.public.access.queries Size: 3,203 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Parameter month query in microsoft.public.access.queries :: microsoft.public.access.queries :: Discussions in microsoft.public.access.queries"
microsoft.public.access.queries
Started 1 week, 1 day ago (2009-11-02 07:57:00)  by Dale Fye
Cliff, Think you are going to need three queries 1. The first will compute the Passing mark for each subject, and should look something like: SELECT Temp.Subject, Min(Temp.Mark) AS Passing FROM tbl_Student_Scores AS Temp WHERE ((Select Count(*) FROM tbl_Student_Scores WHERE ...
Thread:  Show this thread (5 posts)   Thread info: deciding minimum passing marks & distinction grade in
microsoft.public.access.queries Size: 4,525 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: deciding minimum passing marks & distinction grade in
microsoft.public.access.queries :: microsoft.public.access.queries :: Discussions in microsoft.public.access.queries"
microsoft.public.access.queries
Started 1 week, 1 day ago (2009-11-02 08:38:00)  by KARL DEWEY
Do not use the quotes around the number if you Code field is a number a mine was text -- [tblTransactions_Reg-Cnl] SELECT tblTransactions.EventID, tblTransactions.PersonID, tblTransactions.Code, tblTransactions_1.Code FROM tblTransactions INNER JOIN tblTransactions AS tblTransactions_1 ON (tblTransactions.PersonID = ...
Thread:  Show this thread (5 posts)   Thread info: Query to find offstting transactions in microsoft.public.access.queries Size: 2,352 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Query to find offstting transactions in microsoft.public.access.queries :: microsoft.public.access.queries :: Discussions in microsoft.public.access.queries"
microsoft.public.access.queries
Started 5 days, 19 hours ago (2009-11-04 13:53:00)  by KARL DEWEY
>>the resulting query includes "Shipping Priority" information that is contained in a separate column in tbl_History, a column not included in the crosstab query. You must have left someting out or posted the wrong query as there is no "Shipping Priority", "DRMO" field or "Shipped" field. -- Build a little, test a ...
Thread:  Show this thread (5 posts)   Thread info: Subquery Issue 1 in microsoft.public.access.queries Size: 3,519 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Subquery Issue 1 in microsoft.public.access.queries :: microsoft.public.access.queries :: Discussions in microsoft.public.access.queries"
microsoft.public.access.queries
Started 6 days ago (2009-11-04 08:20:00)  by vanderghast
SWITCH( [WFL], "I used WFL", [Ab without Asp], "I used Ab alone", [Ab with Asp], "I used both Ab and Asp", true, "I used something else, if I used anything") Vanderghast, Access MVP "rookie" <rookie@discussions.microsoft.com> wrote in message news:22B36A75-DE8F-4D80-9660-B71C1B012048@microso ft.com......
Thread:  Show this thread (5 posts)   Thread info: IIF statement and multiple items in microsoft.public.access.queries Size: 1,707 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: IIF statement and multiple items in microsoft.public.access.queries :: microsoft.public.access.queries :: Discussions in microsoft.public.access.queries"