|
|
Queryed for 30 & Higher Returns 3's & 4's by
Rob
My query is simple or at least I thought it was but I keep getting bad results.
The Table is... Ordering Info
The Field is... Qty Needed
The Criteria Used...
|
|
7 |
183 |
|
|
SQL searches by
Matt
I've got a table with computer names and IP addresses in different columns.
I would like to do a search that returns all the computer names that aren't...
|
|
2 |
202 |
|
|
If statement in Update query by
Gntlhnds
I have an Update Query that updates two fields , in
one table (Barracks Rooms) based on one field in another table
(Students). If in (Students) is Null,...
|
|
7 |
176 |
|
|
update query by
alecgreen
Hi
I want an update query, that deducts 20% from the value of a field
, assuming that is greater than zero. I also need the
resulting figure to be a whole...
|
|
3 |
173 |
|
|
|
March 25th, 2010 03:26 PM
by KST8WCT
|
8 |
309 |
|
|
Data Exceptions Split by
Bateman28
Hi
I have a import routine that imports a monthly data file into my database.
As part of the routine the data is imported into a Temp Table and then split,...
|
|
2 |
170 |
|
|
Returning all values with a join by
Ck1
I have a table that lists business summary data by day.
Not every business has information on each day.
However I need to pull in the business along with zero...
|
|
3 |
194 |
|
|
Nested IIf and IsNull by
jim
I can't seem to get to syntax right on this query field. The nesting goes
this way:
find City Name by: if JobAddress4 and JobAddress3 is blank then get...
|
|
1 |
182 |
|
|
|
March 25th, 2010 10:20 AM
by Ivan
|
5 |
327 |
|
|
|
|
3 |
195 |
|
|
Count if Text is Equal in two Fields by
Tina S
I have a managers that do reviews on employees and i need to know if they did
a review on an employee that reports to them or to another manager.
In my...
|
March 25th, 2010 01:45 AM
by Tina S
|
2 |
153 |
|
|
show records when two fields not equal by
Tina S
I am trying to build a report about reviews done on employees. We have
Managers assgined to Employees that do reviews. Sometimes we have manager
who are NOT...
|
|
4 |
363 |
|
|
Multi List combo as criteria by
Mr. Bud
Hi and TIA. I have a multilist combo box on my form, but don't know how to
setup my query to reference all the values selected in the combo. If you
could...
|
March 24th, 2010 11:36 PM
by Mr. Bud
|
0 |
145 |
|
|
using dates by
daisy
I am wondering if anyone can help me parse a date field and update another
field.
Here's the situation:
I have a date coming thru - for example:
2/1/2010
I...
|
March 24th, 2010 11:33 PM
by daisy
|
2 |
167 |
|
|
Query multiple Criteria, pick one! by
Zach
Hello all-
I have a query:
SELECT .Ratio, .ASheave,
.BSheave, .HPRating, .ADiameter, .BDiameter, .CONVENTIONAL, .ProposedBeltLength, .MinProposedBeltLength,...
|
|
1 |
167 |
|
|
Update Queries by
Marc
I have two tables an Employee table and a Gap Table. Both Tables have the
Social Security Field (SSN) in them. I also have a UPI field (unique personal
ID)...
|
March 24th, 2010 09:11 PM
by Marc
|
6 |
196 |
|
|
Query Help One-to-Many by
golfinray
I know this must be stupid, but I keep setting two tables up in a query and
it is doing the opposite of what I want. I have
Project #
School District
School...
|
|
4 |
183 |
|
|
Querying Date Field, Disregarding Year by
dimatisah
I have an Access database of client information with their birthdate stored
in a field called Birthday, in m/d/yyyy format.
I need a query that will let me...
|
|
2 |
147 |
|
|
Convert Claim # to Julian Dt by
a0a349 via AccessMonster.com
Hi All!
I have seen lots of posts here on Julian Dates, but it would take me days
looking through everything to potentially find my issue.
I need to convert a...
|
|
3 |
212 |
|
|
querry to seperate data by
AlanO
I was sent data that has address, city and state all in 1 field but I need to
break it out into the 3 separate fields. the data has carriage returns(used *
to...
|
|
5 |
161 |