Running & Setting Up Queries - Page 551

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
delete query by Chris Hi all, the query listed below inserts the rows returned by a query into table tblTeamTask. How can I change this insert query into a delete...	October 25th, 2005 01:22 PM by Gary Walter	3	131
Formula in query by jptpjs via AccessMonster.com Hope someone can help. I have a query with a formula that combines a series of textboxes to form one result. There are a series of messages from 6 text boxes...	October 25th, 2005 02:36 PM by jptpjs via AccessMonster.com	2	111
Date stuff by Allen Browne Hi Derek. It might help to understand how Access works, so you can then choose the best way for you to work. Internally, Access stores date/time fields as...	October 25th, 2005 02:38 PM by Derek Brown	2	97
Update Query - Calculation of person's age in Years - DateDiff??? by Kelsey Running Access 2000 I'm setting up a update query to calculate someone's age based upon two dates and insert that age into a table. So I want to find out how...	October 25th, 2005 03:38 PM by Adam Turner via AccessMonster.com	9	153
Populate my form with parameter query results by Tom K via AccessMonster.com Hi Im using a command button on my form to open a parameter query. The query runs and asks for input and then shows the query results. How can I populate my...	October 25th, 2005 04:13 PM by fredg	1	169
Appending between rows by Rich Several hundred records in my database are duplicates except for the data in one field. I would like to create a new field or fields and somehow "append" the...	October 25th, 2005 04:36 PM by Duane Hookom	6	165
Format date Month/Year by Alex I have a date field that is formatted 05/12/2004. I need to use the date in a crosstab query that will group by month/year like 05/2004. I'm currently using...	October 25th, 2005 04:52 PM by Alex	2	161
Replacing text and leaving numbers by KReese Access 2000 I have a text field that has a combination of text and numbers. For example, in one field there might be "ex 500.00" or "el 650 ...	October 25th, 2005 05:15 PM by KReese	3	121
Access 97 by Bruce I have two Tables in a database & I have made a Join between the Reference fields.However, the data in the two Reference fields that I wish to find duplicates...	October 25th, 2005 05:53 PM by John Spencer	1	105
How can I pass an Excel variable to an Access query by R Oschger I have an Access database that contains the following fields: Year/Mo, Product Category, Part number. The data consists of transactions for a rolling 12 month...	October 25th, 2005 05:55 PM by R Oschger	4	132
Access error message by sloan I am doing a project for school and I need help. I am being asked to create query using all catagories in table. When I chose all with asterick and them try to...	October 25th, 2005 05:59 PM by Vincent Johns	4	121
How to Get Table Name with Field Name in Query ? by SANJAY SHAH-MICROBRAIN COMPUTERS PVT. LTD. Dear Sir, I am using following Query for Reports purpose. SELECT FaAccountMaster.AccountCode, FaAccountMaster.AccountName FROM FaAccountMaster ORDER BY...	October 25th, 2005 06:19 PM by Vincent Johns	7	175
cross tab query - group by week by Helen Hello, I need to create a cross tab query that can group my data by week. The wizard can do it by Year, by Quarter, by Month etc. but not by Week. ...	October 25th, 2005 06:49 PM by Marshall Barton	6	136
Transfering info between tables by Clare Can I remove lines from one table and transfering that info to an archive table when product has been shipped. ( 1 2)	October 25th, 2005 08:48 PM by Marshall Barton	12	198
Perform Multi-table Query?? by Matt K. using Access 2003; building a tracking database to track projects through a long process. Inheritied and Imported 11 tables from Excel. Want to query the...	October 25th, 2005 09:38 PM by Pat Hartman\(MVP\)	5	155
I need a query that finds matching data between two dbs by jackdb I need a query that finds matching fields lastname, firstname and dob, between two access databases names newdb1 and newdb2. Anyone out there know a script or...	October 25th, 2005 09:45 PM by '69 Camaro	2	120
Concatenate by shank I'm using Concatenate to assemble data in the query grid. Problem: Results will only show 255 characters. How can I display all characters which may be...	October 25th, 2005 09:55 PM by Marshall Barton	4	126
combo box query parameters by Doug Goodenough Hi, Is there anyway to have a query parameter possible values be pulled from another table or query? Basically to change the default query parameter prompt...	October 25th, 2005 10:40 PM by [MVP] S.Clark	1	74
Query grid & Formats by Patricia when you have your results from a query in the query grid view, is it possible to bold 1 or more columns? Thanks	October 25th, 2005 10:55 PM by [MVP] S.Clark	1	105
"Effective Date" Criteria for Rates by Jason V I have been stuck on this for some time now. I will try to make it as clear as I can. I need to create a Report of â€œtransactionsâ€ (days worked of... ( 1 2)	October 25th, 2005 11:00 PM by Jason V	13	1,221

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