|
|
Translate if statement in query by
KARL DEWEY
The query has table twice, with second instance having suffix _1 to
appear as and they both check for nulls.
The same could be accomplished like this --
New...
|
|
2 |
791 |
|
|
Joins on NULL Date values by
KARL DEWEY
You can use a LEFT JOIN from Table1 to Table2 if Table1 always has a date or
the reverse if Table2 always has a date.
--
Build a little, test a...
|
|
0 |
915 |
|
|
unique records Access 2003 by
Jerry Whittle
SELECT valveID, Max()
FROM YourTable
GROUP BY valveID
ORDER BY valveID;
If you have a duplicate valveID/Mas of Date combos, it will return all ties.
You...
|
|
1 |
846 |
|
|
How to Union Crosstabs... by
dtoney
I've been reading many posts but still trying to comprehend the union of
crosstab queries. I need to take the weekly count of estimates that take
under 4...
|
|
1 |
885 |
|
|
union query without "blank" recordsl by
Mark Kubicki
I have a union query between 2 related tables, and where they may be records
in one table with no value in the other
.
I've got this (below) query written,...
|
|
4 |
1,352 |
|
|
Translate if statement in query by
Jazz
Thank you for the feedback; I appreciate your help and the suggested
modifications, they are much better. I still have some questions that I need
help...
|
May 27th, 2010 09:06 PM
by Jazz
|
0 |
791 |
|
|
|
May 27th, 2010 08:56 PM
by MKuria
|
0 |
863 |
|
|
|
|
0 |
821 |
|
|
|
|
4 |
1,475 |
|
|
Single Query for Top 10 of Multiple Items by
Joe Murphy[_5_]
Greetings,
I'm going to confess right up front that I'm an Access noob, so there is a
great possibility that what I'm asking is basic and that I just don't...
|
|
2 |
841 |
|
|
|
|
4 |
882 |
|
|
Undefined function 'Left' in expression by
The Joker via AccessMonster.com
Hello all,
First off I want to say I read a lot of the previous posts about this issue
and none seem to be similar to mine. I am working on a database...
( 1 2)
|
|
11 |
1,841 |
|
|
Shift several columns in table by
Hans[_7_]
Hi!
Say you have a table A with fields field1, field2, field3 and field4 and I
want to shift values so field1 receives the value from field2, field2...
|
|
4 |
976 |
|
|
Convert string value to numeric value by
alhotch
I saw a post that showed how to convert from a number value to a string
value. But how about the other way ? Convert a string value to a number...
|
|
3 |
733 |
|
|
Descision based on a query by
poorboy13 via AccessMonster.com
Hello,
I'm hoping this should be easy - I just can't seem to find the answer. I'm
guessing my syntax is wrong but I can not figure it out.
I am making a Db for...
|
|
4 |
840 |
|
|
|
May 26th, 2010 01:37 AM
by Paul
|
3 |
1,064 |
|
|
Merging Query results into Word document by
Used to Know Access[_2_]
I have Word forms to send tailor for each client I mail to. The forms are
requesting specific information regarding employees. To that end, I am
providing...
|
|
1 |
758 |
|
|
Parameter in Union Query by
Jill
I inherited about ten databases, Year2001, Year2002, etc. These databases are
not related, even though they have information about same ID's (For example,
ID...
|
|
1 |
740 |
|
|
Union Query with two crosstabs by
AccessKay
Hi…I attempted to do a Union Query with two crosstabs. I received an error
“Characters found after end of SQL statement. I then read some posts but...
|
|
2 |
745 |
|
|
Merging query fields into Word document by
Used to Know Access
I'm trying to fill out some forms with fields from a query. The forms are
built in MS Word. So far all I get is inserted lists into the form but the
fields...
|
|
1 |
898 |