Running & Setting Up Queries - Page 1053

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
changing subdatasheet property w/DDL by David Mueller Is it possible to change the subdatasheet property of a table using the ALTER TABLE statement? or to set the property to "none" using the CREATE TABLE...	January 10th, 2007 04:40 PM by David Mueller	5	272
How do I check value of field in multiple records with IIf stateme by Ryan I have a field in my query that is calculated by a nested IIf statement. One of the IIfs must check ! to see if a date is entered. No date (Is Null)...	January 10th, 2007 04:00 PM by NthDegree	1	110
getting fields from subform by Ian I want to use a subform field (embedded in the main form) as a criteria in a query but I can't seem to 'grab' it for a normal form I put . I've tried . and...	January 10th, 2007 03:59 PM by Allen Browne	4	154
Missing fields by ladybug via AccessMonster.com This morning I opened a form in my database and all the fields are gone. I checked all my forms-same problem. Is there some type of update that I need to...	January 10th, 2007 03:40 PM by Christy Wyatt	3	162
Advanced Select into statement in Access by [email protected] How to do this in MS Access 2000 Select Companyname,Counter = IDENTITY(int, 1, 1) into Custmoers2 from customers	January 10th, 2007 02:33 PM by stumac	4	117
Report Layout by Hansford cornett I have a simple table with a Team Name and EmpNo. There are 10 records for the team in this table that are selected from a larger table in a random...	January 10th, 2007 02:30 PM by Hansford cornett	6	119
how do I change value settings from dollars to pounds by edwardhorden I have change my computer and this one a Dell seems to be American configurated this includes different keys for the @. How can I get back to english	January 10th, 2007 01:10 PM by Van T. Dinh	1	128
Cumulative Count by Matt Dawson I currently have a query that shows all the active contracts that I have within my database. I am trying to populate a pivot table that shows each contract...	January 10th, 2007 10:15 AM by Matt Dawson	2	122
RecordCounts by Dale If have a query that I am trying to write that I need to get a count for the records. Here is what I have. ClassInfo ClassInfoJudges Judges I need to get...	January 10th, 2007 08:10 AM by Gary Walter	1	98
Query by Main form and give the result as input to a combo box sub by Manohar Hi, We are using nest sub forms for entering data. With the three child fields linked to parent fields. We have three subforms linked to a a common parent...	January 10th, 2007 07:21 AM by Manohar	0	74
Why am I only able to use the primary key as criteria? by scaast I created a database with multiple tables and a single form that uses dropdown lists based on tables in the db...for example, I have tables for agents,...	January 10th, 2007 03:04 AM by Duane Hookom	4	86
Query to find longest name of dupe records by John Welch I have a table with these fields (and example data) PersonID (long) OldRecordNum (long) FirstName(text) 12 12 ...	January 10th, 2007 01:11 AM by John Welch	3	225
pass-through query link to local table by PJ How do I link a local table to a pass-through union query? I'm accessing multiple tables via a pass through query, but I want to also link to a local table...	January 10th, 2007 12:25 AM by Ted Allen	4	1,980
can we merge the mdb files? by Kuntal Shah I have lots of mdb files and very big database so I wanted to merge some of the tables of the files but I can not do it... If somebody know, please help me,...	January 9th, 2007 11:35 PM by Smartin	1	111
Output Format by jjacob I am trying to set a query that will export a text file for uploading. I've done this before, but haven't had any money amounts yet so I am perplexed. The...	January 9th, 2007 10:55 PM by jjacob	1	95
parse names by chris My client name is stored in only one field. I want to break it out into two fields--first name and last name. I can segregate the first name...	January 9th, 2007 10:36 PM by John Vinson	5	89
query count records by shank I have the following records: 22732 22106 22106 22106 22106 21690 21690	January 9th, 2007 10:34 PM by shank	6	116
Populating an OLE table field using vba by guyinla05 Does anyone know how to programatically insert a Word document into an OLE field in an Access database. Specifically, I am trying to populate an Access table,...	January 9th, 2007 09:09 PM by John Nurick	2	161
Pivot Records by [email protected] I hope I can do this I have a query that shows Primary# , Date, #sales.... etc In access they all show up in record form Primary# , Date, ...	January 9th, 2007 08:50 PM by Gary Walter	7	102
Writing Data to Table from Query by Manuel I have a table called tbl_training which stores training data. The fields in the table are as follows: ID (this is the primary key; data type: AutoNumber),...	January 9th, 2007 08:50 PM by Manuel	2	82

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