A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Running & Setting Up Queries Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Insert contents of Col in one table into another table by Sandy
Hello: Is it possible in Access to insert the contents of a column from one table into another table? When I run a Sql statement, it pretends to be inserting...
May 28th, 2004 09:31 PM
by Sandy Go to last post
2 604
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...
May 28th, 2004 08:04 PM
by Peter Knight Go to last post
4 704
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...
May 28th, 2004 07:49 PM
by Dan Artuso Go to last post
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 Go to last post
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...
May 28th, 2004 06:07 PM
by John Vinson Go to last post
1 512
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 Go to last post
2 588
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...
May 28th, 2004 04:18 PM
by Duane Hookom Go to last post
1 804
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
May 28th, 2004 04:13 PM
by Brian Camire Go to last post
1 404
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 Go to last post
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 Go to last post
2 984
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...
May 28th, 2004 03:12 PM
by Cheryl Fischer Go to last post
2 1,300
Text field causing trouble in query (continued) by KaiRich
Hi, This is a continuation of a post a few days ago. Apologies about the time lag, but the question is from a contract I am working on only 1 day per week,...
May 28th, 2004 01:03 PM
by Gary Walter Go to last post
2 965
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...
May 28th, 2004 12:46 PM
by Gary Walter Go to last post
3 648
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....
May 28th, 2004 12:36 PM
by Gary Walter Go to last post
4 549
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 Go to last post
3 342
Query List Doesn't Display by [email protected]
Hello out there! Presently I am using Windows XP with MS Access 2002. My situation is that after Access opens, the system does not display the list of...
May 28th, 2004 07:06 AM
by John Vinson Go to last post
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 Go to last post
3 668
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...
May 28th, 2004 01:16 AM
by Cheryl Fischer Go to last post
5 457
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 Go to last post
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...
May 27th, 2004 10:11 PM
by Gerald Stanley Go to last post
5 307
Post New Thread


Display Options
Showing threads 43161 to 43180 of 43289
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:09 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.