in access, if then statement22126 (6/7/2010 7:11:03 PM) Utfif (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
duplicate results in query6899 (6/3/2010 1:24:57 PM) pat67Hi, I am getting duplicate results when I run a query. Here are the
details. Bothe tables have the same data only dates have changed. what
I am trying to do is find out which dates have changed. The problem i...
Forcing an ambiguous outer join6949 (6/4/2010 3:12:12 PM) UtfI tried to add another table to my query with a Left join and I receive a
message that my SQL contains ambiguous joins. It went on to say that I
needed to create a separate query and I think it was telling...
Pulling specific data from table field42284 (6/3/2010 7:55:28 PM) jet04I am having a problem figuring the right way to pull specific data from
within the text of the table's field and separating it into a unique field
Anyway, my problem is that I need to copy a user's ...
How to calculate days due?21092 (6/4/2010 5:29:08 PM) JimI have a table (tblTerms) with 2 fields [strTerms] & [dblDaysDue]. The
typical terms in the table would be 2%10 Net 30 with [dblDaysDue] having a
value of 30. I then take the difference between the ship dat...
Add character to string36378 (6/7/2010 2:27:33 PM) TwimmI have a simple query that pulls data from a single table containing
some basic client information. One field is a text field containing
alpha-numeric data. For purposes of a report, I need to add the
Dsum Problem with date criteria11271 (6/7/2010 10:16:05 AM) UtfHi all,
Kindly solve my problem.
I have 2 tables stock_received , stock_utilized.
stock_received fields -- date,3pcs,4pcs,boxes.
stock_utilized fields -- date,3pcs,4pcs,boxes.
I have successfull...
Looping through data with calculations1958 (6/4/2010 7:52:51 PM) UtfI have to loop through the data from one table (demand) and calculate total
supply expected depending on the data from the other tables, here is example
and expected result:
Table A - (supply batches)
How to set the parameter query for this case?21005 (6/7/2010 2:55:12 AM) klim1167Dear all,
I have 2 fields, Eng and Math.
I would like to set the parameter query for Eng and Math ==> Eng min, Eng max,
Math min and Math max.
The Eng query criteria can be "Between Eng min AND Eng max" and...
Delete Query not Working5823 (6/2/2010 5:15:52 PM) UtfI have tried to follow many of the suggestions in other posts, but have not
been able to get this to work.
I have a table called DailyCalls and another table called PersonalCalls. A
query was set up to r...
Use of Parntheses in Expressions3924 (6/6/2010 11:49:14 PM) UtfHello,
I am fairly new to Access and Excel. I am trying to write a
formula/expression, but I think my problem is as simple as having the
parenthese in the wrong place. The formula I have currently is as ...
Multiple tables search8906 (6/6/2010 9:33:11 AM) UtfHi all,
Kindly solve my problem.
I have a mdb file.
tables created t1,t2,t3,t4.
fields are almost same in all tables, but the data is different in all tables.
fields are.. name, age, mobile_number,...
calculating average days22307 (6/6/2010 11:49:01 PM) UtfI am trying to develop a report where in the PartNum footer the
average number of days between orders is calculated. I have
created the following:
date and time query61097 (6/5/2010 10:04:12 PM) domazehello,
this is my first post in this forum.
I have the following problem and i really need some help because i am about
to go crazy.
I cannot understand why running this code in sql
select * from le...
JOIN Query very slow4731 (6/4/2010 11:45:00 AM) TallyThis is a multi-part message in MIME format.
I have the...
Optimization of Between Clause Queries3915 (6/4/2010 10:42:32 PM) KevinI have some sql queries involving the use of between clauses, similar to the
select Colors1.*, sum(Colors2.freq) as TFreq
from OldColors as Colors1, OldColors as Colors2
Serious Problem with Access 2010 "Query to complex"01104 (6/6/2010 6:52:20 PM) UtfI just installed Office 2010 (May 2010 version from Technet download) and
many queries that worked in 2003 and 2007 now will not open and produce the
error message "Query to complex - OK". Nothing was chan...
Sum and DateDiff21188 (6/6/2010 2:33:30 AM) UtfHi,
I doing a calculation in a query of the difference in times. I'm wondering
if I can control the decimal precision to be just (2) places. The number I
end up with is ie; 5.6666666666, can I have this to...
A field (string) is into other field (string)2800 (6/4/2010 10:03:38 PM) UtfUsing 2 tables I want to get the rows that match where the content of the
field (string) is equal or is into other field (string) from other table.