Running & Setting Up Queries - Page 1496

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
Totals Queries by MacNut2004 Hi, I have a report that is based on an underlying totals query. I am trying to stick a field from one of the tables joined in that query in the grid - it...	January 25th, 2006 10:25 PM by John Vinson	5	99
Make Table Query by AllenKarns Hello, I just have a couple of questions on creating a new table from an existing table. Right now I have a table that was created from a former Sales Database...	January 25th, 2006 10:23 PM by John Vinson	2	209
Create autonumber in a query by Esperanza Hello VBA Expert ! I want an auto increment number in my query. Even if I declare a public variable : intTransacNoEDI the result of my query always return 1...	January 25th, 2006 09:48 PM by MGFoster	2	78
Pass-Through Query w/o Record Locking by Tony Hi All, Using Access 2K, I have to get at data in a Progress SQL-92 database table that has more than 255 fields. Some of the data I need is in the...	January 25th, 2006 09:43 PM by Chrisf	7	143
Count Unique Fields Only by Joe Hello everyone, I am working on a report that shows our company shipment attainment percentage. When a customer makes an order from us, we issue them a...	January 25th, 2006 09:13 PM by Michel Walsh	1	79
Using the Small Function from Excel in Access 2002 by ACWOKING I have a database where i need to write a simple query to display the 1st 2nd and 3rd smallest numbers (currency format) from an array of data that sits...	January 25th, 2006 09:03 PM by LeAnne	1	66
Runtime error 3021 by Redsoxnation I get a runtime error in my query using the code below... Option Explicit Function PrevRecVal_NPDES_1812_Eff_A_qry(KeyName As String,...	January 25th, 2006 08:57 PM by Redsoxnation	8	134
help woith syntax.. by nycdon Anyone with good eye for syntax see the issue with this..getting syntax err.. strSql = "INSERT INTO ( UpdatedTPlanID#, Medication, Reason, Response, Dose,...	January 25th, 2006 08:45 PM by nycdon	4	80
UpdateQuery only on the record specified by a form by BT Hi, Is there anyway I could set up an UpdateQuery based only on the current record as specified by a the user on a form? I've tried this myself, but my...	January 25th, 2006 08:37 PM by BT	2	90
Update Query on network drive by KAREN7305 I have a problem. I am writing an application that has the all of the forms, queries, and reports in one database and the tables in another. They are linked...	January 25th, 2006 08:21 PM by Jerry Whittle	3	99
using ms access to convert ms access & sql server date time to unix time stamp by jjj0923 I'd like to use access to convert a sql server table (using an ODBC connection) to a MYsql table (again using an odbc connection) and I have all the field...	January 25th, 2006 08:20 PM by John Spencer	3	112
UpdateQuery only on the record specified by a form by BT Hi, Is there anyway I could set up an UpdateQuery based only on the current record as specified by a the user on a form? I've tried this myself, but my...	January 25th, 2006 08:02 PM by BT	0	68
Create Field Names based on values in another field by Dane Cooper I have a table with many fields, some of which are years as field names. One of the field names is "Base Year". I want the some of the field names to change...	January 25th, 2006 07:54 PM by John Vinson	7	165
Date lookup in Table by JGal01 I have two tables. In one table, there are lines with various dates which contain information that I will eventually summarize based on Fiscal Months. In...	January 25th, 2006 07:16 PM by JGal01	2	63
Combining variable number of fields by Mark Olsen Hi, I have a question and Im not sure if there even is an answer for it. I have a database of programs. In a separate table I have a list of approvers for...	January 25th, 2006 06:52 PM by Allen Browne	1	89
Birth Month Query by Sara I've got a table of clients and I want to search for employees born during a certain month. For example, my birthday field is . When I run the query, I want to...	January 25th, 2006 06:00 PM by Sara	2	74
Calculations based on constantly changing records by Novice Jim I estimate for a mason contractor (bricklaying company). One of our contractors, a home builder, hires us per job on a time and material basis. I calculate...	January 25th, 2006 05:53 PM by Novice Jim	0	64
what templent can be used for menu making by Rosebud 2006 I like the templates that are designed thay relly helped me I am trying to go in the resturant buisness with someone my part of the business will be...	January 25th, 2006 05:48 PM by Rick B	1	96
Dates driving me to drink. by NC_Sue I have a contacts database in which I have birthdays listed for some (not all) of the contacts and in which years of birth are know for some (not all) of the... ( 1 2)	January 25th, 2006 04:50 PM by NC_Sue	10	119
A query from two queries by GL Hello I have the two following queries: SELECT Items.ItemCode, Count(Items.ItemCode) AS , Items.Cost FROM Items GROUP BY Items.ItemCode, Items.Cost HAVING...	January 25th, 2006 04:34 PM by John Spencer	3	65

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