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 Reverse Sort Order / Thread Starter Last Post Replies Views
Use results from query on a form by jrusch
This is probably something simple but I am trying to figure out how to take the datasheet results from a query and copy that information onto a datasheet on my...
October 7th, 2004 12:25 PM
by SteveS Go to last post
1 85
Use result of expression in another expression?? by Serendipity
Can I go to the first empty column in a design query grid and use an expression to add a new field row and then use the result of that expression in another...
January 15th, 2007 05:36 AM
by Smartin Go to last post
9 112
use result as a FIELD in the design grid by VJ-mike
I want to use a queried attribute value as a Field name in the query design grid. I tried a Select statement, but at best, was comming up with something that...
July 15th, 2004 10:44 PM
by Duane Hookom Go to last post
8 518
Use response to prompt in a report by lfcjr
I have a query which prompts for a date range. I would like to be able to save the user's response and use the range in the title of a report. Is this...
March 25th, 2008 12:39 PM
by lfcjr Go to last post
4 109
Use Replace function to reduce postcode to postcode region by [email protected]
I have a table of UK companies whose records I want to filter using a map of postcode regions. For the benfit of people outside the UK, our postcodes are a...
(Multi-page thread 1 2)
January 29th, 2007 10:41 AM
by Gelatinous_Blob Go to last post
11 222
Use Query to find due date by mattc66 via AccessMonster.com
Hi All, I need some help..Some would say allot of help. I have a product that I need to report to our sales department the date of availablity. Example...
January 11th, 2007 03:28 PM
by Jamie Collins Go to last post
4 170
use query to find age by paul_88
i have a database and need to use a criteria to calculate the age for all the fields already in the table/database, does anybody know what code i...
January 19th, 2005 02:26 PM
by Go to last post
2 88
Use Query to Filter Table by Ripper
I have a form bound to a table of available tests for a summer Credit By Exam Session. I created a query that finds only the tests that were signed up for...
May 15th, 2008 05:17 PM
by Ripper Go to last post
0 78
Use query to copy data from previous row by penguin66
I'm trying to automate data import from a text file into access using queries so my users can follow the progress of the data import and clean-up. I've run...
November 18th, 2008 12:09 AM
by penguin66 Go to last post
2 61
Use query to change Text to Number by dcozzi
Is there way to change a field from numbers stored as text to numbers, without deleting anything that is actual text? I would like to achieve the same results...
March 11th, 2006 09:42 AM
by John Nurick Go to last post
2 54
Use query to Calculate Distance with geocodes or Lat/Lon by efandango
I have a table with a number of addresses with geocodes; I want to say to the query, find all addresses (geocode) within a 2 mile radius of a given geocode...
October 23rd, 2007 03:52 PM
by efandango Go to last post
0 69
Use query results to copy files? by Gary
Hi, I have a query that returns results like: Name: ID: Picture ID File Name: Bob 1234 bobs_id_pic.jpg Tina 5678 ...
(Multi-page thread 1 2)
December 18th, 2007 01:07 AM
by Gary Go to last post
10 131
use query results in vb code by minimal experience via AccessMonster.com
I'm very frustrated. I have two tables, tblPoints and tblProducts. tblPoints contains PointID (PK), CustomerID, ProductID, Date, and Invoice Number. ...
February 8th, 2005 04:57 AM
by minimal experience via AccessMonster.com Go to last post
1 72
use query result to display a message by JJF
I use a Access Time Clock to tract employes hours. An employee enters his EmId and clicks a command button to SignIn. The computer enters the date & time. He...
July 27th, 2006 12:58 AM
by JJF Go to last post
2 82
Use query name in Open recordset statement by Debbie
Hi all, I have a database that I created which contained all the objects, including the tabels. I then split the tables out into a back end database and...
January 21st, 2006 03:46 AM
by Debbie Go to last post
4 159
use query Criteria from combo box to set subform Filter by David
Hello all, This is somewhat long, but please hang in there. I wasn't sure how much detail to include. I am trying to use a combo box column1 on the main...
March 2nd, 2007 02:04 AM
by Allen Browne Go to last post
1 153
Use query criteria for calculated dates by Carol
I have a database of records with expected (Expr1) and final (Expr2) due dates. These dates are calculated with the Dateadd function and...
June 28th, 2005 11:35 PM
by [MVP] S.Clark Go to last post
1 180
use query as field controlsource by geebee
hi, I have the following query: SELECT find_weekdays(date()-1,Date())-2 AS workdays; of course the find_weekday() is a function/module. I just need to know...
March 10th, 2006 12:36 AM
by KARL DEWEY Go to last post
1 78
Use QBE Grid with Double-Quotes and/or Apostrophe by ryguy7272
In the QBE Grid, with Like "INT'L" in Criteria, my Query works fine. It fails when I try to create a dynamic Query with this VBA: ' Build criteria string...
April 24th, 2008 06:04 AM
by ryguy7272 Go to last post
2 91
Use Prompted variable more than once by CR[_2_]
Hi, I have a query which prompts the user for a date. I want to then use the entered date twice without calling for the variable to be entered again. Query...
May 15th, 2008 12:17 PM
by CR[_2_] Go to last post
5 140
Post New Thread


Display Options
Showing threads 2001 to 2020 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 12:55 AM.


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