|
|
|
|
2 |
127 |
|
|
PASS THROUGH QUERY WITH ORACLE BACK END by
nique
Hello, having problems using the pass through query to pull data off of an
oracle back end. I have created an odbc user data source but I still get an
error...
|
|
7 |
220 |
|
|
|
August 31st, 2004 04:27 PM
by rnprice
|
2 |
384 |
|
|
Make Table Query??? by
[email protected]
I have several tables, each being a month's worth of
data. I need to be able to produce a report spanning a 6
month period, with the user being able to chose...
|
|
1 |
162 |
|
|
Mtd Question by
CR
I have a built queries to give me monthly totals, but the problem is that by
using Month(Now()), I get the current month when it is the 1st day of the
month...
|
|
4 |
185 |
|
|
Autonumber in a query by
Fabio
How can I include an autonumber in a field of a query ?
Or hoe can I select just the 5 first records of my query?
|
August 31st, 2004 05:29 PM
by Fabio
|
2 |
158 |
|
|
criteria for an empty date by
June
Hi,
History: In my database I fill in a record for a product but not the date
field until the product is completed. My reports will not show this...
|
August 31st, 2004 05:51 PM
by June
|
3 |
185 |
|
|
Query to delete records by
Jk
Hello,
I had placed a posting on design group to clean out my 50 test records from
my tables so i could get a fresh start on my new database.The response was...
|
|
1 |
310 |
|
|
Select Criteria in a Query by
Adding Selected Range into Query
I was wondering if it were possible to add the select
criteria into a field in the query. Example: when I run a
query that pulls information based on a date...
|
|
1 |
145 |
|
|
|
August 31st, 2004 07:32 PM
by JG316
|
7 |
187 |
|
|
Trim() function not working? by
Will
I have the expression:
IIf(=Null Or Len(Trim())=Null,"This
Manufacturer is not in the system"," ")
in an Access2000 report. It's always worked (for over 2...
|
August 31st, 2004 07:39 PM
by Will
|
2 |
339 |
|
|
setting "date" criteria by
Jeff G
When I set a criteria in a query "between and " to
prompt for dates "a" and "b" and then type in "8/16/04"
for "a" and "8/31/04" for "b" when prompted, I...
|
August 31st, 2004 09:30 PM
by Jeff G
|
2 |
396 |
|
|
MakeTable QRY output (need zero's) by
Maxwell
Hello,
I am having difficulty with the following...Hope you can
follow what I did....
Created a 'MakeTable' query from a Crosstab query to give
me sales for...
|
|
1 |
168 |
|
|
SQL view of messed up action queries by
Kendra
I really appreciate your kindness in helping me out. Here
is the SQL for the action queries (if it clarifies things):
SQL of append query...
|
|
2 |
1,942 |
|
|
|
|
1 |
188 |
|
|
|
|
1 |
560 |
|
|
Ranking by
Richardson
I have a query with a member listing. They have all previously been
assigned scores which are integer values ranging from 1-1200 but they are
not sesquential...
|
August 31st, 2004 10:31 PM
by Tonín
|
3 |
145 |
|
|
Comparison query by
Su Cooper
Hi,
I'm new to queries and I'm trying to work out (without
success) how to do the following.
I have two tables:
tbl1 (the key of which is employeeID)
tbl2...
|
|
2 |
125 |
|
|
Access "behind the scenes" by
Tcs
Is there any way to see what Access is REALLY doing, "behind the scenes" so to
speak? I need help with translating what Access is doing, so I get it to...
|
|
1 |
114 |
|
|
Update query based on different conditions by
Vincdc
Hello:
I have 3 queries and 1 table (ID as primary key). Is there any way that a
update query can deal with 3 conditions and update "Status"?
if a.ID=b.ID,...
|
|
1 |
120 |