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: 29 posts per thread
Forum activity: 169 active threads during last week
 

Posting activity on microsoft.public.access.queries:

  Week Month 3 Months
Threads: 169 516 1,347
Post: 431 1,348 3,951
 

microsoft.public.access.queries Posting activity graph:

Posts by:  day  week  month 

Top authors during last week:

Name
Posts
KARL DEWEY
47
user's latest post:
Crystal Reports formula to...
Published (2009-11-25 11:52:00)
  Here is a guess -- IIF([MASTER].[JMT_DATE] Is Not Null, "Post Judgment", IIF([MASTER].[JMT_DATE] Is Null AND [MASTER].[SUIT_DATE] Is Not Null, "Post Suit, Pre Judgment", IIF([MASTER.SUIT_DATE] Is Null AND [MASTER].[JMT_DATE] Is Null, "Pre Suit", "Unknown")))
John Spencer
32
user's latest post:
Temporarily disable...
Published (2009-11-26 10:00:00)
  As far as I know, it is NOT possible to do this in Access. You need to do the appends in order. You could write VBA code to remove all the relationships and then restore/rebuild them after the update is finished. Of course, the danger is that if you did add a record or records that did not comply with the relationship rule, you would generate an error when you tried to rebuild the relationship. John Spencer Access MVP 2002-2005,...
Marshall Barton
14
user's latest post:
Nested or Sub query? in...
Published (2009-11-25 09:15:00)
  Joseph Atie wrote: >Im a bit lost as to how to go about this, I have 3 queries that i built in >access query builder which join 4 tables together in order to generate a >report > >What I would like to do is turn those 3 queries into a single sql statement >that can be run from vba. > >Query A >SELECT Transdata.Barcode, Transdata.Out, Transdata.[In],...
Duane Hookom
14
user's latest post:
period question in...
Published (2009-11-26 21:41:00)
  Then my previous reply is appropriate. I would normalize the table structure with a union query like the following where you need to substitute something for .... that relates Curr_Prd to the period field: SELECT item_no, [1] as Qty, DateAdd("m", .... ,Curr_Prd) as Mth FROM dbo_Inv_Buy UNION ALL SELECT item_no, [2], DateAdd("m", .... ,Curr_Prd) FROM dbo_Inv_Buy UNION ALL SELECT item_no, [3],...
Ken Snell
11
user's latest post:
Ask for date in...
Published (2009-11-25 09:45:00)
  It appears that ACCESS is interpreting your user's input dates as strings, not dates. Either declare the parameters as DateTime type in the query, or format the user's input dates as "formatted dates": PARAMETERS [begin] DateTime, [end] DateTime; SELECT * FROM YourTable WHERE dateadd("h",-8/24, [datetime]) Between [begin] AND [end]; Or SELECT * FROM YourTable WHERE...
Bob Barrows
11
user's latest post:
Pass Through Query Translation...
Published (2009-11-25 08:50:00)
  Kou Vang wrote: > How do I translate this into a pass through query? I've been puzzled > over this for a day now? > > SELECT STORET1_TSRFDACT.START_DATE > FROM STORET1_TSRFDACT > WHERE ((Year([start_Date])=2008)); > > I keep getting an error '"YEAR": 'Invalid Identifier' > What is the database you're passing this through to?
vanderghast
11
user's latest post:
Merging queries by column in...
Published (2009-11-26 13:20:00)
  You can try: SELECT Year(date), min( iif( condition1, var1, null)), max( iif(condition1, var1, null)), ... , min( iif(condition2, var2, null)) , ... FROM ... GROUP BY Year(date) that is, remove the conditions from the WHERE clause which are not common to all expressions, since they are not in the iif on which operates the aggregations. Vanderghast, Access MVP "Xmas" <me@privacy.net> wrote in message...
John W. Vinson
11
user's latest post:
Update query only partially...
Published (2009-11-26 22:00:00)
  On Thu, 26 Nov 2009 03:47:07 -0800 (PST), "d3cyph3r@gmail.com" <d3cyph3r@gmail.com> wrote: >Hi I'm trying to run an update query but for some reason it's only >updating some of the records. The weird thing is that the field that >i'm coparting to update is an auto number. >I've checked both tables and the fields seem to be the the same and >the...
Daryl S
9
user's latest post:
Query Help in...
Published (2009-11-25 07:32:00)
  DCL - The query wizards will help you through these. When you select a new query, use the Crosstab Query Wizard for the first one, and the simple Query Wizard for the second one. There is a lot of information in help - both within Access and on-line on these.
Jerry Whittle
8
user's latest post:
Pass Through Query Translation...
Published (2009-11-25 08:52:00)
  Year is not a valid function in the database that you are trying to use. You need to find out what kind of database and what function you can use in it. For example something like below should work with Oracle. WHERE to_number(to_char([startdate],'YYYY')) = 2008 ; or WHERE to_char([startdate],'YYYY') = '2008' ;
 

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

Discussions in microsoft.public.access.queries
Started 2 days, 1 hour ago (2009-11-26 19:20:00)  by Allen Browne
If your query uses multiple tables with one-to-many relations, the records from the ONE side of the relation will appear on as many rows as there are records in the related table. For example, if you have tables for Customers, Invoices, and Payments. If an invoice was paid in 2 instalments, the invoice will appear twice because...
Thread:  Show this thread (4 posts)   Thread info: Duplicate Returns. in microsoft.public.access.queries Size: 624 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Duplicate Returns. in microsoft.public.access.queries :: microsoft.public.access.queries :: Discussions in microsoft.public.access.queries"
Discussions in microsoft.public.access.queries
Started 1 day, 22 hours ago (2009-11-26 22:15:00)  by John_G via AccessMonster.com
Hi - This is from A2000 - I doubt it has changed much. When you open the event procedure for the NotInList event, you will see that there are two parameters: NewData as String, and Response as integer. NewData contains the data the user entered, and Response indicates how it was dealt with. In your case ...
Thread:  Show this thread (2 posts)   Thread info: Combo Box Not in List function in microsoft.public.access.queries Size: 1,898 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Combo Box Not in List function in microsoft.public.access.queries :: microsoft.public.access.queries :: Discussions in microsoft.public.access.queries"
Discussions in microsoft.public.access.queries
Started 1 day, 23 hours ago (2009-11-26 22:00:00)  by John W. Vinson
On Thu, 26 Nov 2009 03:47:07 -0800 (PST), "d3cyph3r@gmail.com" <d3cyph3r@gmail.com> wrote: >Hi I'm trying to run an update query but for some reason it's only >updating some of the records. The weird thing is that the field that >i'm coparting to update is an auto number. >I've checked both tables and the fields seem to be the ...
Thread:  Show this thread (2 posts)   Thread info: Update query only partially working in microsoft.public.access.queries Size: 1,040 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Update query only partially working in microsoft.public.access.queries :: microsoft.public.access.queries :: Discussions in microsoft.public.access.queries"
Discussions in microsoft.public.access.queries
Started 3 days, 12 hours ago (2009-11-25 09:04:00)  by Bruce Meneghin
I'm assuming you have records with period number as a field (valid values 1-24) and you need to decide which ones to select and sum based on the user's input For this the basic logic would be periodDiff = currentPeriod - numPeriodsRequested if periodDiff >0 then select records where period < currentPeriod AND ...
Thread:  Show this thread (5 posts)   Thread info: period question in microsoft.public.access.queries Size: 1,632 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: period question in microsoft.public.access.queries :: microsoft.public.access.queries :: Discussions in microsoft.public.access.queries"
Discussions in microsoft.public.access.queries
Started 2 days, 1 hour ago (2009-11-26 19:15:00)  by Allen Browne
Use the unmatched query wizard (first dialog when you create a new query.) Use qryA as the first 'table', and qryB as the one to exclude.
Thread:  Show this thread (2 posts)   Thread info: Query design help requested in microsoft.public.access.queries Size: 363 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Query design help requested in microsoft.public.access.queries :: microsoft.public.access.queries :: Discussions in microsoft.public.access.queries"
Discussions in microsoft.public.access.queries
Started 2 days, 6 hours ago (2009-11-26 14:14:00)  by DawnTreader
Hello All i figured it out. i had set the field in the table utblPartListPriceQuery to be index with no duplicates. changing it back to no indexing causes the list to automatically load field information from the other table. "DawnTreader" wrote: > Hello All > > I have a query like this: > > ...
Thread:  Show this thread (2 posts)   Thread info: Requerying Automatically in microsoft.public.access.queries Size: 3,092 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Requerying Automatically in microsoft.public.access.queries :: microsoft.public.access.queries :: Discussions in microsoft.public.access.queries"
Discussions in microsoft.public.access.queries
Started 2 days, 7 hours ago (2009-11-26 13:20:00)  by vanderghast
You can try: SELECT Year(date), min( iif( condition1, var1, null)), max( iif(condition1, var1, null)), ... , min( iif(condition2, var2, null)) , ... FROM ... GROUP BY Year(date) that is, remove the conditions from the WHERE clause which are not common to all expressions, since they are not in the iif on which ...
Thread:  Show this thread (2 posts)   Thread info: Merging queries by column in access in microsoft.public.access.queries Size: 2,149 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Merging queries by column in access in microsoft.public.access.queries :: microsoft.public.access.queries :: Discussions in microsoft.public.access.queries"
Discussions in microsoft.public.access.queries
Started 2 days, 11 hours ago (2009-11-26 10:00:00)  by John Spencer
As far as I know, it is NOT possible to do this in Access. You need to do the appends in order. You could write VBA code to remove all the relationships and then restore/rebuild them after the update is finished. Of course, the danger is that if you did add a record or records that did not comply with the relationship rule,...
Thread:  Show this thread (2 posts)   Thread info: Temporarily disable relationships/constraints in
microsoft.public.access.queries Size: 2,164 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Temporarily disable relationships/constraints in
microsoft.public.access.queries :: microsoft.public.access.queries :: Discussions in microsoft.public.access.queries"
Discussions in microsoft.public.access.queries
Started 2 days, 12 hours ago (2009-11-26 09:00:00)  by vanderghast
< Date( ) + 1 AND >= Date( ) - 2 should do, in the grid., as criteria. Vanderghast, Access MVP "Peter" <Peter@discussions.microsoft.com> wrote in message news:B836DAF3-1782-40F7-8CFA-1B1EE3F3A55B@microso ft.com... > Hi all, i am ashamed to admit that i can not figure this one out.. > > In one table i ...
Thread:  Show this thread (3 posts)   Thread info: Previous Dates in microsoft.public.access.queries Size: 1,209 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Previous Dates 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 5 days, 13 hours ago (2009-11-23 07:13:00)  by Dorian
Thread:  Show this thread (11 posts)   Thread info: Querying between two dates doesn't work if Start and End are ident in
microsoft.public.access.queries Size: 199 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Querying between two dates doesn't work if Start and End are ident in
microsoft.public.access.queries :: microsoft.public.access.queries :: Discussions in microsoft.public.access.queries"
microsoft.public.access.queries
Started 5 days, 22 hours ago (2009-11-22 22:15:00)  by John W. Vinson
On Sun, 22 Nov 2009 20:35:01 -0800, Candy Pierce <candy083@hotmail.com> wrote: >I need an Expression to extend the purchase date to a warranty expiration >date based on a product type Ummmm.... How can we help? You have not chosen to post any information about the structure of your table, where the ...
Thread:  Show this thread (8 posts)   Thread info: A calculated field in access in microsoft.public.access.queries Size: 721 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: A calculated field in access in microsoft.public.access.queries :: microsoft.public.access.queries :: Discussions in microsoft.public.access.queries"
microsoft.public.access.queries
Started 1 week ago (2009-11-21 11:30:00)  by Bob Barrows
perkinesed wrote: > I am trying to convert some MS Access queries to .net. These queries > call other queies, that call other queries, etc., sometimes up to > five levels deep. I am trying to keep from using subqueries because > of the amount of testing that would be required, some of the lower > level queries are used in multiple ...
Thread:  Show this thread (7 posts)   Thread info: convert layered MS Access queries to .NET in
microsoft.public.access.queries Size: 970 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: convert layered MS Access queries to .NET 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-20 16:01:00)  by KARL DEWEY
Post a SQL of a select query containing all the fields to use.
Thread:  Show this thread (7 posts)   Thread info: Time Between the Time of the Current Record and the Next Earliest in
microsoft.public.access.queries Size: 261 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Time Between the Time of the Current Record and the Next Earliest in
microsoft.public.access.queries :: microsoft.public.access.queries :: Discussions in microsoft.public.access.queries"
microsoft.public.access.queries
Started 6 days, 8 hours ago (2009-11-22 12:23:00)  by Duane Hookom
A Yes/No field actually stores -1 for yes or 0 for no. A simple parameter prompt query could use a criteria under the field like: [Enter Y for Yes]="Y" I always feel it is much better to provide controls on forms for all user interaction. For instance if you had a check box "chkMyCB" on a form "frmMyForm". Your criteria would be...
Thread:  Show this thread (7 posts)   Thread info: Evaluate Yes/No Field Based on User Input in
microsoft.public.access.queries Size: 656 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Evaluate Yes/No Field Based on User Input in
microsoft.public.access.queries :: microsoft.public.access.queries :: Discussions in microsoft.public.access.queries"
microsoft.public.access.queries
Started 3 days, 11 hours ago (2009-11-25 09:42:00)  by KARL DEWEY
Try this -- Mid([YourField], InStrRev([YourField], "_")+1)
Thread:  Show this thread (7 posts)   Thread info: Remove Certain String from Query Field in microsoft.public.access.queries Size: 287 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Remove Certain String from Query Field in microsoft.public.access.queries :: microsoft.public.access.queries :: Discussions in microsoft.public.access.queries"
microsoft.public.access.queries
Started 4 days, 5 hours ago (2009-11-24 15:15:00)  by Ken Snell
Try this: SELECT item_types.name AS Type, brand.name AS Brand, item.old_sku, item.long_desc, Sum(item_warehouse_link_history.change_qty) AS [QTY Put Away], Sum(item_warehouse_link.onhand_qty) AS SumOfonhand_qty, Max(FormatDateTime([item_warehouse_link_history] ![date],2)) AS Expr1 FROM brand INNER JOIN (item_warehouse_link INNER ...
Thread:  Show this thread (6 posts)   Thread info: Sum means empty query? in microsoft.public.access.queries Size: 1,659 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Sum means empty query? in microsoft.public.access.queries :: microsoft.public.access.queries :: Discussions in microsoft.public.access.queries"
microsoft.public.access.queries
Started 4 days, 7 hours ago (2009-11-24 13:30:00)  by KARL DEWEY
You did not say but I assume that each period is a calendar month. You did not say but it seems you want period group to start from previous month backwards through the number entered. [YourPeriod] Between (DateDiff("m",Date(),#11/1/2009#)+23) And (DateDiff("m",Date(),#11/1/2009#)+23)-[Enter number of periods]
Thread:  Show this thread (6 posts)   Thread info: 24 rolling periods how to calculate. in microsoft.public.access.queries Size: 605 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: 24 rolling periods how to calculate. in microsoft.public.access.queries :: microsoft.public.access.queries :: Discussions in microsoft.public.access.queries"
microsoft.public.access.queries
Started 5 days, 7 hours ago (2009-11-23 13:45:00)  by KARL DEWEY
If your 'related field' is null then it can never show as a null will not relate to anything. If the field you say is null has criteria applied then maybe it is not null but a 'zero lenght string.' Use this as criteria -- Is Null Or "" If this does not work the post your query SQL by opening in design view,...
Thread:  Show this thread (6 posts)   Thread info: Records with null values aren't being returned in
microsoft.public.access.queries Size: 682 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Records with null values aren't being returned in
microsoft.public.access.queries :: microsoft.public.access.queries :: Discussions in microsoft.public.access.queries"
microsoft.public.access.queries
Started 1 week, 2 days ago (2009-11-19 20:00:00)  by Marshall Barton
Loggical via AccessMonster.com wrote: >I use this expression in the criteria in a Query. How can I modify it to >obtain records for a 24 hour time period? At present it produces records for >the previous day. I need it to produce records on the previous 24 hour time >period. > >(Example) Tuesday 06:00 to Wednesday 06:00...
Thread:  Show this thread (5 posts)   Thread info: Date Expression in microsoft.public.access.queries Size: 946 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Date Expression in microsoft.public.access.queries :: microsoft.public.access.queries :: Discussions in microsoft.public.access.queries"