|
|
Appending zero-length string by
Claire
Hello all,
I recently ran Allen Browne's function to change all my fields to not accept
zero-length strings- which makes so much sense to me. Of course, I'm...
|
|
4 |
252 |
|
|
|
|
5 |
268 |
|
|
Struggling when there are no records by
Tara
Forgive me...I know this has been covered extensively, but I still can't get
it quite right. I have a query that is currently set up like this:
FFAmended:...
|
February 19th, 2010 05:47 PM
by Tara
|
3 |
228 |
|
|
|
|
2 |
195 |
|
|
|
|
3 |
246 |
|
|
Sum up by cust w all details by
hoachen
Table Data
CustID Item# ItemName Amount
123 A11 Abc 11.5
123 A13 cde 10
123 A16 fgh 20.5
111 A11 Abc 11.5
111 A16 fgh 10
Output example
123 A11 Abc 11.5
|
February 19th, 2010 03:03 PM
by hoachen
|
3 |
247 |
|
|
IIF statement, proper formula by
jligue via AccessMonster.com
Not entirely sure if the IIF statement is the correct way to go about this, I
have a field on a query that has total pounds of either printed or plain
product....
|
|
1 |
252 |
|
|
IIf by
kevcar40
Hi
i have a crosstab query that takes values from 2 tables
table one weekly prod scores (entered weekly)
table two takes scrap numbers (entered daily)
the...
|
|
1 |
165 |
|
|
Do I need a subquery? by
Barry
Hi:
I am having problems creating a query to show cars with WorkOrders. The
tables involved are Customers (CustomerID as PK), CustomerCars (CardID as PK,...
|
February 19th, 2010 06:47 AM
by Barry
|
2 |
232 |
|
|
|
|
1 |
256 |
|
|
remove the database link by
subs
i have a table which is linked to some other table or database. how
would i remove the link to this table?
|
|
3 |
204 |
|
|
Between Dates Criteria by
Apprentice
Can’t' seem to get it. I have two fields: Start_Date and End_Date. Both are
Short Date Format.
Note: Both date fields are previously calculated dates...
|
|
2 |
206 |
|
|
IIF statement by
jligue via AccessMonster.com
Not entirely sure if the IIF statement is the correct way to go about this, I
have a field on a query that has total pounds of either printed or plain
product....
|
|
4 |
218 |
|
|
Query wont sort ? by
Dorian
Any idea why this wont sort by Lastname ?
SELECT C.Restitution-NZ(P.TotalPaid,0) AS , Trim(C.Firstname &
" " & C.Lastname) AS ,...
( 1 2)
|
February 18th, 2010 08:20 PM
by Dorian
|
10 |
342 |
|
|
Qry with dupes looking for only most recent date by
The Joker via AccessMonster.com
Hello all,
I have a query I'm running and when it pulls it has a bunch of duplicates,
which is expected. Is there some type of criteria or something I can do...
|
|
2 |
228 |
|
|
SQL by
KenSheridan via AccessMonster.com
Firstly you'd need to create a form then add a command button to it. Then
select the button in form design view and open its properties sheet if its
not...
|
|
0 |
181 |
|
|
Help required in Update query by
naveen prasad[_2_]
Hi,
pls help me here
table t1 has 3 fields, and data is as below
name , grade , marks
n1 a 10
n2 b 20
n3 c ...
|
|
2 |
188 |
|
|
Hyperlink within Database 2007 by
mroser1
I am creating a rather extensive database in Access 2007 that is going to
have many tables. To make this database user-friendly I want to create
Hyperlinks...
|
February 18th, 2010 02:30 PM
by mroser1
|
0 |
167 |
|
|
|
|
1 |
229 |
|
|
cross tab query by
subs
ozip dzip week no1 week no2 week no3
i have the above fields in a cross tab query. columns week no1 , week
no2 and so on could be dynamic-- it could also...
|
|
1 |
189 |