|
More site info...
Discussions in microsoft.public.access.queries - www.microsoft.com/communities/newsgroups... | Site profile
|
|
Site profile page for http://www.microsoft.com/communities/newsgroups....
This report page has aggregated and summarized the online discussions from the Message Board located at http://www.microsoft.com/communities/newsgroups....
This site profile page outlines general site statistics such as: Users Activity, Site Activity, Site Rank, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional site profile information for http://www.microsoft.com/communities/newsgroups... is also shown in the following divisions:
1) Top 10 Active Forums during Last Week
2) Top 10 Site Forums
3) Latest Active Threads
4) 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 site's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity table on Discussions in microsoft.public.access.queries:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
165
|
501
|
1,340
|
|
Post:
|
421
|
1,317
|
3,943
|
|
|
Authority Badge:
|
|
|
BoardReader Authority Badge code for Discussions in microsoft.public.access.queries (http://www.microsoft.com/communities/newsgroups...)
|
|
Put this code anywhere on your forum page:
|
|
|
|
|
|
|
|
Rating - The position measured by activity among all forum sites tracked by BoardReader.
If rating is 10 there are 9 forum sites which have higher activity.
Posts - Number of posts on forum site during last 7 days.
Threads - Number of threads on forum site active during last 7 days.
Authors - Number of authors which contributed to the site within last 7 days.
|
|
|
|
|
Discussions in microsoft.public.access.queries posting activity graph:
|
|
http://www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.access.queries Alexa graph:
|
Top authors on Discussions in microsoft.public.access.queries during last week:
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")))
user's latest post:
Remove Certain String from Query...
Published (2009-11-25 10:50:00)
ASSUMPTION: There is ALWAYS two underscores. Mid(ProjectField,Instr(Instr(1,ProjectField,"_")+1,ProjectField,"_")+1) You can test before you execute the expression IIF(ProjectField Like "*_*_*", Mid(ProjectField,Instr(Instr(1,ProjectField,"_")+1,ProjectField,"_")+1) ,ProjectField) John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop...
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],...
user's latest post:
period question in...
Published (2009-11-25 10:03:00)
Mccloud, You have asked several vague questions without providing your table and field names. I expect if you provide some field and table names as well as enough records and what you expect for results, someone can help you. If you choose to not provide this information, we can only make wags.
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...
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?
user's latest post:
Can I use an IIF statement with...
Published (2009-11-23 13:00:00)
And what will you do when the powers-that-be decide to add yet another "movement"? Or stop considering one of the existing ones? Your table design is not so much a relational database table as a spreadsheet. Access is a relational database, and is optimized to work with well-normalized data. If you try to feed it 'sheet data, both you and Access will end up working overtime to come up with work-arounds ... oh...
user's latest post:
YTD Subquery is not including...
Published (2009-11-25 20:20:00)
On Wed, 25 Nov 2009 18:06:01 -0800, jeromez <jeromez@discussions.microsoft.com> wrote: >Hi Allen: > >I created a query with a subquery to sum the hours worked by period (i.e., >month) and then YTD hours next to the month hours. > >However, it's not entirely working for me and it's driving me crazy. > >The query gives me by Dept and period the ytd hours...
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.
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' ;
|
|
|
Top 10 active forums on Discussions in microsoft.public.access.queries during last week:
|
|
Top 10 forums on Discussions in microsoft.public.access.queries:
|
|
|
|
Latest active threads on Discussions in microsoft.public.access.queries:
Started 21 hours, 51 minutes 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...
Started 18 hours, 56 minutes 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 ...
Started 19 hours, 11 minutes 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 ...
Started 2 days, 8 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
...
Started 21 hours, 56 minutes 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.
Started 1 day, 2 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:
>
> ...
Started 1 day, 3 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 ...
Started 1 day, 7 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,...
Started 1 day, 8 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 ...
|
|
Hot threads for last week on Discussions in microsoft.public.access.queries:
Started 4 days, 9 hours ago (2009-11-23 07:13:00)
by Dorian
Started 4 days, 18 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 ...
Started 6 days, 5 hours 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 ...
Started 1 week ago (2009-11-20 16:01:00)
by KARL DEWEY
Post a SQL of a select query containing all the fields to use.
Started 5 days, 4 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...
Started 2 days, 7 hours ago (2009-11-25 09:42:00)
by KARL DEWEY
Try this --
Mid([YourField], InStrRev([YourField], "_")+1)
Started 1 week, 1 day ago (2009-11-19 08:05:00)
by Steve
I just realized what I wrote could make it sound like I have multiple PK per
table. I was just referring to a new entry made into the table and I want to
take the PK from this new entry and join it in the joining table with all
entries in the other table.
"Steve" wrote:
> I have two tables that are joined through a ...
Started 1 week, 1 day ago (2009-11-18 22:55:00)
by Duane Hookom
Create the function in SQL Server.
Started 3 days, 1 hour 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 ...
Started 3 days, 3 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]
|
|
Size: 624 bytes
