Running & Setting Up Queries - Page 1092

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.

Thread / Thread Starter	Last Post	Replies	Views
Calculating Dates by Melinda I have a query to calculate lost time for workers compensation claims---my problem is that on some claims I have no ending date because they have not...	December 15th, 2006 07:22 PM by Melinda	4	72
performing a lookup on a query by [email protected] is it possible to perform a lookup on a query I want to do a look that counts from lets say 1 to 10 in this loop i want to look up x=1 loop until x=10 ...	December 15th, 2006 07:31 PM by Marshall Barton	5	58
Create a front-end to keep people from messing with query design by DOCUBANK I have a lot of users who want individualized queries to display data. I don't want to clog up the queries section with lots of queries. I'm trying to...	December 15th, 2006 07:52 PM by John Spencer	1	54
Parsing data by Eric I receive regular e-mails of the same basic format with which I would like to create an access DB, The body of the mail will contain something like: Name:...	December 15th, 2006 08:08 PM by Eric	4	56
Subquery Help!!! Top N Values by K Good day: I have a table called Downtime. The table contains the following fieldâ€™s sequentially in the table. CC_No Cost Center Description Reason... ( 1 2)	December 15th, 2006 08:11 PM by K	12	153
Update macro by ladybug via AccessMonster.com I have a macro with a series of append queries. When I run the macro the querie work correctly. However, I created a command button using wizard to run this...	December 15th, 2006 10:23 PM by fredg	1	47
Help with an update query by Corey-g via AccessMonster.com Hi All, I have the following structu An import table (import_mpl - local access table) that has data loaded from an Excel spreadsheet, and 2 lookup tables...	December 15th, 2006 11:35 PM by Smartin	3	60
Select Last payment date and amount of a group by Kathy Webster I apologize if this posts twice. I am perplexed. Seems like it should be so easy, but...Can you help? My table has: Client PaymentDate ...	December 16th, 2006 12:09 AM by Kathy Webster	6	65
Sequential Numbers by Brian Hello all , I have a table that I want to read that can't be put into an autonumber so what i want to check is that the numbers are sequential so if it miss...	December 16th, 2006 01:00 AM by taurus via AccessMonster.com	3	66
Update Query to change text? by chewy Hi, Working on a Query in the MOS exam, I was asked for a single command that would change "De" to "de". I don't remember if I eventually did a find &...	December 16th, 2006 04:46 AM by John Vinson	1	72
Query: return value if within + or - 10% of entered value? by Maax Hi all, i am quite new to Access and have struggled for a few days tryiny to find a way to achieve this. I would like to be able to return records that have...	December 16th, 2006 10:44 AM by Maax	3	72
Track Changes to Table by [email protected] Dear NG - Yes, I'm brand new so I will apologize in advance for being such a pest. Lets say you run an update query and at a later date decide you want to see... ( 1 2)	December 16th, 2006 12:14 PM by Douglas J. Steele	11	161
find and replace data by wisconsinexplorer I have a large database containing records that I am trying to update. My database has records that are keyed to ID numbers that have since been changed. I...	December 16th, 2006 02:56 PM by wisconsinexplorer	4	85
Select Last payment date and amount of a group by Kathy Webster I am perplexed. Seems like it should be so easy, but...Can you help? My table has: Client PaymentDate Amount...	December 16th, 2006 03:12 PM by John Spencer	9	158
insert a Parameter query into a form by freelancer I have set up a number of parameter queries but would like to insert them into a form. This is in order to have a dedicated search form for various...	December 16th, 2006 06:21 PM by John Vinson	2	60
Multi dated query by Dan I put the criteria (date()-7) in a query field. It gives me what I want from that field. However, I have more date fields and would like them all to...	December 16th, 2006 09:11 PM by hrtrst	3	73
Quarterly Sales Tax Query by CoachBarkerOJPW Problem I am trying to create a query from two unrelated tables, I have tblSales tblSalesTax SaleID ...	December 16th, 2006 09:13 PM by CoachBarkerOJPW	2	64
change value name by JRS Hello, I have a query as an ecample that returns several values in a field....dogs, cats, and eleph. How do I change the eleph to elephant? thanks	December 16th, 2006 11:25 PM by Ken Sheridan	2	52
concatenate and time by Jen I have date and time fields on two databases that I need to report from. The first dba (Provides time and duration of each call) has the date and time in one...	December 16th, 2006 11:57 PM by John Spencer	4	95
Comparing Fields using Wildcards by TDAnderson I am trying to associate the part no. of products in one table to their pics in another. example: PN PIC ds11300 ...	December 17th, 2006 06:24 AM by TDAnderson	7	165

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed