|
|
|
May 28th, 2004 09:31 PM
by Sandy
|
2 |
634 |
|
|
Creating a wildcard search for a form. by
Peter Knight
Hello,
I have a form called "Guest Search" where the user is asked to enter a
guest name, which can appear in three different fields in a table. It
is also...
|
|
4 |
712 |
|
|
Log10 function by
Andy
In Access 2000 there was a Log10 function, this seems to
have disapeared in the 2002 version. The Log function in
2002 returns the Natural Log. Does anyone...
|
|
1 |
741 |
|
|
Absolute value of a checkbox in a query by
MarkD
Using Access 2000
I have a query based on a table with a bunch of check
boxes. I want to sum the checkboxes based on a field then
transfer that to an Excel...
|
May 28th, 2004 06:09 PM
by MarkD
|
4 |
292 |
|
|
comparing two tables by
ADAK
I would like to comparing two tables.
The results to be a side by side comparisions of each record from the two dbs.
If the record in db-1 does not have a...
|
|
1 |
517 |
|
|
Select Query by
Pago
Whenever I design a select query, I have to enter the parameter twice before the query runs. It seems like the first time I run the query after I saved the...
|
May 28th, 2004 04:56 PM
by Pago
|
2 |
597 |
|
|
Option group selection as query criteria by
Tara
I'm pretty familiar with a lot of the basics of Access,
but have never worked with an option group before. I
have one on a data entry form and am using it
for...
|
|
1 |
825 |
|
|
Date Search by
Shawn
I have a query and I would like to look up the record with the most current date.
Is there a way to do this?
Thanks in Advance
Shawn
|
|
1 |
405 |
|
|
Return top record by
Bren
I am tracking river levels for three rivers. I have set up a query to give me the latest reading for each river. However, it is giving me the first readings,...
|
May 28th, 2004 03:31 PM
by Bren
|
2 |
396 |
|
|
Hold it, we found SQL view.... by
1.156
Fred, we now can see the code -- don't know how we didn't run into it
earlier.
The SQL code looks understandable for the original simple query with no
drop...
|
May 28th, 2004 03:20 PM
by 1.156
|
2 |
1,006 |
|
|
field manipulation by
Steve
Hello,
I have a mailing list i created in access from an
external file. I am trying to figure out how to create a
new field from part of the data in another...
|
|
2 |
1,324 |
|
|
|
|
2 |
994 |
|
|
Importing Query results to Excel by
ChuckW
Hi,
I am running a query and would like the results to
populate certain cells in an excel spreadsheet. Is there
a way to have a field in my query be sent to a...
|
|
3 |
655 |
|
|
What's wrong with this query? by
Craig
SELECT ,
SWITCH(=,2,TRUE,1) AS Expr1
FROM
qry_Detail_Transactions
LEFT JOIN
qry_OpeningBalance_ClearDate
ON
qry_Detail_Transactions....
|
|
4 |
588 |
|
|
IIF Limitation by
JA
I am using IIF statement to specify weeks as shown below.
Unfortunately it does not allow me to go beyond 13 weeks.
How can I overcome this...
|
May 28th, 2004 11:46 AM
by Dann
|
3 |
342 |
|
|
|
|
1 |
366 |
|
|
Format for phone number by
Sandy
Hello:
I have a table with a phone column having a 999999-9999 format.
I need (999)999-9999 or at least even a 999 999-9999.
Any help will be greatly...
|
May 28th, 2004 01:31 AM
by Sandy
|
3 |
689 |
|
|
Most Recent Date by
Michael Noblet
I have a linked table that has 3 fields.
fldName
fldHours
fldDate
This table is poulated by and external program designed to
give hours of usage by month and...
|
|
5 |
477 |
|
|
Taking the Top Three by
Frank
I have a query that prints out all individuals and the amount of footage they produced for a given date range. I would like it to print out just the top three....
|
May 28th, 2004 12:33 AM
by Mark D
|
1 |
389 |
|
|
Query help by
Steve
Hello,
I have imported a databae into access. Essentially I have
a database of names and addresses. all of the names in
the databae have multiple records with...
|
|
5 |
307 |