|
|
 Up |
|
  |
Author: alecgreenalecgreen
Date: Jun 8, 2010 08:02
Hi
From the result of an iif query, is it possible to change the value of
a another field, other than the field with the iif query?
Many Thanks
Alec
|
| |
|
| |
no comments
|
|
|
Author: Ken SnellKen Snell
Date: Jun 8, 2010 04:47
So, how would you calculate the number of days due? Is it a countdown from
the shipping date to the next June 1 date? Or something else? Show us some
examples using data.
--
Ken Snell
http://www.accessmvp.com/KDSnell/
"Jim" gordonferon.com> wrote in message
news:O2aO8SlBLHA.5808@TK2MSFTNGP02.phx.gbl...> Hello,
> Sorry, 6/1 means terms of June 1.
>
> Jim
>
> "Ken Snell" wrote...
|
| Show full article (1.40Kb) |
|
| |
no comments
|
|
|
Author: JRJR
Date: Jun 8, 2010 00:48
Absolute brilliance!
Thanks so much, John.
"John W. Vinson" STOP_SPAM.WysardOfInfo.com> wrote in message
news:to1p06pdr15b942lo90r488c20q0hr4ov6@4ax.com...> On Mon, 7 Jun 2010 23:13:18 -0400, "JR" gmail.com> wrote:
>>>in the query view or sql view?
>
> You can use either, but in the query grid (which is NOT the query, just a
> tool
> to help build SQL) you'll need to put the subquery - as a SQL string in
> parentheses - in the Criteria box. You'll need to adapt the fieldnames and
> tablenames to match your actual tables, which I cannot see.
> --
>
> John W. Vinson [MVP]
|
| |
|
no comments
|
|
|
Author: DawnP277DawnP277
Date: Jun 7, 2010 22:46
I am trying to do a like criteria with 2 wildcards using a text box as the
parameter.
The original data comes from our ERP system that I ODBC to.
Everything I read tells me I am writing the criteria correctly but it will
not pull any data or I get an ODBC fail message. But if I take out the Form
control as the parameter and just type the parameter it works.
Here is my criteria
Like"*" & [Forms]![NewBlockForm]![Text0] & "*"
Does anyone have any suggestions as why this is not working.
I am trying to filter down the results that the production people need to
view to decide what is the best part number.
Thanks for any help you can provide.
Dawn
|
| |
|
1 Comment |
|
|
Author:
Date: Jun 7, 2010 21:38
What I want to do, hopefully, will be simple enough. I want to have a search
form that has two fields, one a combo box and the other an unbound field. I
want the combo box to list the different fields within a table that I want to
search. I want the unbound field to be where I enter the criteria for
searching the field that I selected in the combo box. In the past I usually
just created an unbound form and created unbound fields for each field and
then call the fields to the query. This has always worked well enough but
thought It would be easier using 2 fields as opposed to many. Any help would
be greatly appreciated.
|
| |
|
4 Comments |
|
|
Author: dtretinadtretina
Date: Jun 7, 2010 21:11
if (Escalation/Assignment = 0) or (Updateheat = 0 )or (Worklog = 0), then 0
for the total. Else total.
How would you set this up in design query? Each of the above is a seperate
table
Query:
SELECT DISTINCTROW tblMonitoringData_OLD.[HEAT ID],
[tblEscalation/Assignment]![Points Earned]+tblUpdateHeat![Points
Earned]+tblWorklog![Points Earned] AS [Documenation Pts],
[tblEscalation/Assignment].[Points Earned] AS [Escalation?Assign],
tblUpdateHeat.[Points Earned] AS UpdateHeat, tblWorklog.[Points Earned] AS
Worklog
FROM ((tblMonitoringData_OLD LEFT JOIN [tblEscalation/Assignment] ON
tblMonitoringData_OLD.[Escalation/Assignment] =
[tblEscalation/Assignment].ID) LEFT JOIN tblUpdateHeat ON
tblMonitoringData_OLD.UpdateHeat = tblUpdateHeat.ID) LEFT JOIN tblWorklog ON
tblMonitoringData_OLD.Worklog = tblWorklog.ID
GROUP BY tblMonitoringData_OLD.[HEAT ID], [tblEscalation/Assignment].[Points
Earned], tblUpdateHeat.[Points Earned], tblWorklog.[Points Earned];
|
| |
|
2 Comments |
|
|
Author: John SpencerJohn Spencer
Date: Jun 7, 2010 21:05
If you are talking about having a field "block" with something in it like
Field: Old: New
that should be assigning an alias "OLD" for the field named NEW and should not
do any concatenating at all.
It will consolidate all the same values into one row. For instance if you had
a table with first names and last names show only the first name and GROUP By
the first names you will see one row for everyone who has the first name JOHN.
If you add the first name field again and set the Total to COUNT you would see
something like
FIrstName CountOfFirstName
JAMES_________8
JEAN__________1
JOHN__________22
If you have multiple fields and group by them, then the group by is done on
the combination of the fields.
|
| Show full article (1.45Kb) |
|
1 Comment |
|
|
Author: pat67pat67
Date: Jun 7, 2010 20:55
On Jun 3, 6:18 pm, KARL DEWEY discussions.microsoft.com>
wrote:> Revise to add 1 --
> ....b.CC = a.CC AND b.Price = a.Price AND b.Value = a.Value)+1 AS Rank
>
> --
> Build a little, test a little.
>
>
>
> "pat67" wrote:
>> On Jun 3, 11:18 am, pat67 comcast.net> wrote:>>> On Jun 3, 10:58 am, KARL DEWEY discussions.microsoft.com>
>>> wrote:>
>>>> Your tables are joined on Purch Doc and Item but you have multiple dates in
>>>> both tables. This results in what is known as a Cartesian effect. The
>>>> number of dates in the first table will be multiplied by the number of dates
>>>> in the second.
> ...
|
| Show full article (6.11Kb) |
|
no comments
|
|
|
Author: DontKnowDontKnow
Date: Jun 1, 2010 07:53
Hi Guys,
I would like to add my thanks to all of you guys as well !! You guys have
certainly helped me over the years with helping me out with my problems with
Access and certainly I have learnt a lot via your incridible source of
knowledge in this area!!
many thanks to all of you and best of luck in your future endavours!!
Many thnaks ,
Ian from Newcastle Australia!!
cheers!!
"Daniel" wrote:
> Firstly, let me apologize for making this beautiful cross-post. I know it
> bad etiquette, but in this instance I'm hoping no one will truly mind (after
> all MS did it with their announcement......
|
| Show full article (1.44Kb) |
|
no comments
|
|
|
|
|
|
Author: RRSRRS
Date: May 14, 2010 10:39
Every Friday, I run an error report which searches for errors with an
Audit_Date between last Friday (a week ago) and Thursday (the day before the
report is run). Since the reports must be signed and management wants them
returned by the following Friday, I've been asked to put a due date on the
report. Additionally, since the Audit_Date varies and the automated report
can be printed by others at anytime, how do I get the due date to always
appear as the second Friday after the Audit_Date? I've tried several date
functions, but I'm not having any luck. Please assist. Thank you!!!
|
| |
|
no comments
|
|
|
|
|
