|
|
query field reference help by
-dch
I am running Access2002 under Windows XP Pro.
I have built a query as a row source for a listbox on a
form. The first version of the query is working...
|
June 2nd, 2004 07:30 PM
by
|
4 |
1,696 |
|
|
Week number problem by
Mike Collard
I have a table that holds average values by week number -
the last week held is currently week 21 so I now need to
add data for week 22 and week 23.
If the...
|
|
2 |
779 |
|
|
|
|
14 |
553 |
|
|
Matching Data by
Mark R.
I have a query where company name fields from two different sources need to be compared. I need an expression (or something) that will compare the first 15 or...
|
June 2nd, 2004 09:06 PM
by Mark R
|
2 |
300 |
|
|
Query truncates data by
Jake
Hello,
I've created a query that contains two queries, with a left outer join. The
query duplicates values if I don't set the query properties to...
|
|
3 |
571 |
|
|
Query - Not equal to by
Annick N.
Hello all,
I have two tables that have employees IDs as key fields. I am trying to create a query to fetch all of the employees IDs that do not match with...
|
|
3 |
257 |
|
|
SQL statement by
Floradee
I need to run a query in Access that will give us the clients who have not given us work since 2001. The problem; there are clients who have been giving us...
|
|
5 |
402 |
|
|
Can I setup a search engine? by
Scott
How do I create a search engine of some kind for my database? (without having to setup a new query everytime)
I have a database which contains a library of...
|
|
1 |
375 |
|
|
|
|
1 |
322 |
|
|
SQL field limit by
imAGine
I have imported a querry from Microsoft Querry that extracts data from a SQL Table. The SQL table has more fields than can be viewed using Access. Is there a...
|
|
1 |
120 |
|
|
|
|
1 |
244 |
|
|
Query by
CGibbons
Is there any way to share a query? I have created a
complex query that i need to email to someone so they can
use it with a table. This person is computer...
|
|
1 |
228 |
|
|
Dates and MTBF by
Ana
Hi,
I have the following columns:
Vehicle# DateRepair
|
June 3rd, 2004 02:09 AM
by fredg
|
1 |
123 |
|
|
Counting or Grouping Rows by
Chuck
I have inherited a table with information that looks something like this:
Name Fruit
John Apple
John Orange
John Pear
Jane Apple
Jane ...
|
|
1 |
238 |
|
|
Query/Report Setup by
bnichols0330
I have a table set up with
Group Name Q1 Q2 Q3
Group 1 Yes No No
Group 2 No ...
|
|
1 |
376 |
|
|
DLookup by
Chris
Can it be used multiple criteria for the DLookup function in the validation
rule for a control on a form?(Ex:For every control except the first one,
the...
|
June 3rd, 2004 05:57 AM
by Chris
|
3 |
622 |
|
|
|
|
1 |
611 |
|
|
|
|
1 |
405 |
|
|
FINDING THE "#" CHAR by
Mike
Could anyone help me ?
when used in a query what would be the best way to filter out everything
that had a # in the text field
any help would be...
|
June 3rd, 2004 08:47 AM
by Mike
|
3 |
210 |
|
|
Query won't run but copy will by
John
Has anyone ever seen this problem before?
I have a simple update query (that has been running daily
for months with no changes or problems). Now...
|
|
1 |
524 |