Threads Replies Last Post 589 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>   reconstruct table that was normalized into several tables I imported a table into my database and normalized it into several tables. Now I can't figure out how to reconstruct the original table with queries. The data relate to procedures done on patients. At a given "encounter" a patient can have one or more procedures done. So the original table looked like this, with a Yes/null for each of the three procedures (if the procedure was not done d... 5 12/12/2008 4:05:00 AM Set Warnings false is misbehaving Access 2003 FE, SQL 2005 express BE Generic code : docmd.setwarnings false docmd.openquery "sql pass thru query 1" docmd.openquery "sql pass thru query 2" etc docmd.setwarnings true Just started happening today (nothing has changed in my environment) Intermittently will happily run the 1st pass thru query without comment but next query will prompt: "You are about to run a pass-thro... 4 12/12/2008 3:33:27 AM Echo? I have a form open on startup, and code run on the form open. All the code does is follow a hyperlink, then close the database. I'm basically using the database as a "portal" from a frontpage website, so anyone who does not have access to the department drive (where the database is), won't be able to access the file that the hyperlink opens. My problem is that the hyperlink opens the fol... 4 12/12/2008 3:25:57 AM How can I append a table and set a date field to a specific date Not sure I worded the subject clearly, but here's what I'd like to do: I want to append a table with 12 new records. Each record has a date field and the new date field would be the first of the month, with all 12 months represented. Here's what the appended records would look like (the Link Field column represents the link to another table (arbitrary number used here), since this is ... 3 12/12/2008 12:30:36 AM Parameters I have a combo box that collects info for a query. How can I get the query to return ALL records. I basically have four options in the combo box, can I add an All to that selection or maybe a check box?... 2 12/12/2008 12:18:46 AM sort by last name I have a field [SetterCompany] ex John Smith. I would like to sort by last name in a query that is the "Row Source" for a "List Box" I know dividing the field into 2 fields "[first] [last]" is what should have been done, but I can't do that now, because they are hundreds of "queries, tables, forms..." that would have to be changed. Thanks -- Message posted via http://www.accessmons... 6 12/11/2008 10:37:30 PM query for attendance I have an attendance database to record student atendance. My database data like following: studentID, Attendance date, Attendance code 1 Dec/01/2008 Absent 1 Dec/10 /2008 Sick 1 Nov/5/2008 Late I need a query report like following: Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thur Fri Nov ... 2 12/11/2008 9:34:08 PM Defining Text field sizes in destination Make-Table Query when extracting fields from ODBC DB2 tables into access using Make-Table Query howdoes one define/limit the destination text field size? Access seems to default to 255 or 50 characters which is problematic on large numbers of records when the field only needs to be 3 to 10 characters Keeping blowing 2GB limit because of all the dead space. I'm unsure of how to trim / exclude / limit du... 4 12/11/2008 8:39:01 PM Union Query I have a table - Reportsdue with multiple fields such as reportname, fiscialyear, towhom, also with reportduedate1 reportduedate2 reportduedate3 reportduedate4 I need to create a query/report that allows the user to input a month requested Example: Reports due in the month of May (5) so I began with a union query that I thought would rename each of the above 4 fields to duedate th... 3 12/11/2008 7:49:01 PM Do I need a Report & Subrept or Can I do this with a Crosstab Quer I have two queries. One query (qryInventory) pulls the current inventory levels [current], min inventory levels [min], and optimal inventory [opt] for a given product model [product_model]. The other query pulls the each transaction for each product model over the last 14 weeks. I am then utilizing a CrosstabQuery (qryProductSales) to show the quantity of product models sold eac... 1 12/11/2008 6:20:01 PM Selecting top records based on multiple fields I have a query shown below: SELECT data.[Account-Sub account], data.[Account Unit], data.[Account Unit Description], data.Account, data.[2007 Actual], data.[2008 Actual], data.[2009 Actual], data.[2009 Budget], data.Description, data.[Description Order], data.[LEVEL 1], data.[L1 Order], data.[LEVEL 2], data.[L2 Order], data.[LEVEL 3], data.[L3 Order], data.[LEVEL 4], data.L4Order, data.... 4 12/11/2008 5:59:04 PM populate an ole table field with pictures I hope this is the right venue for this question. Sorry and could you redirect me, if not... I have a database that tracks student information. My site head would like a new field that would contain a photo of the student. He wants our guidance people to be able to save the photos as jpgs to a serverside photos folder (within the same folder as the database) using the student number as ... 1 12/11/2008 5:59:03 PM Size of QueryDef.SQL property Does anyone know the maximum string size that can be accepted by the DAO.QueryDef.SQL property? Patrick =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Patrick Jackman Vancouver, BC 604-874-5774 ... 7 12/11/2008 5:47:13 PM Query is asking for a parameter that's not there. Whenever I run my query, it is asking for a parameter that is not a part of the parameters. Here is the SQL for the query: SELECT tblProspectComplete.Destination, Count(tblProspectComplete.Destination) AS CountOfDestination, Sum(tblProspectComplete.[InitialR/OAmt]) AS [SumOfInitialR/OAmt] FROM tblProspectComplete GROUP BY tblProspectComplete.Destination, tblProspectComplete.Funded HAVIN... 2 12/11/2008 5:38:00 PM multiple user input parameters I have a query in which the user is prompted to enter a value. The report then prints all records that contain that value in a field named “Main Description”. Is it possible for the user to enter more than one value to search on within the field “Main Description”? Example: Can the user enter “Snowden” and then “Kendall” to print a report that contains all records ... 4 12/11/2008 5:24:02 PM List all records that appear more than once I have a query named readmit_2 that lists medical encounters. I need to build another query that lists only those encounters that are a readmission. The distinguishing characteristic is the Medical Record # (mr_num). If the mr_num appears more than once, it is a readmission. However, I need all the records that appear more than once listed so they can be seen - I just don't want to see a... 2 12/11/2008 4:55:01 PM Calculate difference in Sales by comparing month yearwise Hi, I am having dataset like this, Period field Type is 'Text' Product-Period-Sales X-2007/01-10000 X-2007/02-5000 X-2008/01-15000 X-2008/02-3000 I would like generate final output that will show the difference of sales by comparing current year month (2008) with last year month. Please suggest me query. Thanx in advance... 2 12/11/2008 2:11:57 PM rolling 3 months I still need help with the subquery if anyone is up to the challenge of teaching a novice to get a rolling average. thanks! "buzzmcduffie" wrote: > > >I would like the last 3 months that had data for each employee.. > > > > > >Emp 1 had data in Jan Feb Mar Apr May = I want to see Mar, Apr, May > > >Emp 2 had data in Jan Feb Apr May - I want to see Fe... 21 12/11/2008 1:19:02 PM IIF Statement in a Criteria In() statment...? In the query in questions there is a field where I need to place a "In(Select...)" statement in the criteria but the catch is that the "Select statement within the In() string would have to reference one of two queries within the same database based on the value on an open form as indicated in the IFF statement within... In (IIf(([Forms]![frm_Period]![WDPoint]="Domestic")=True,"SELECT ... 3 12/11/2008 1:04:40 PM Need most recent date out of many I am having trouble creating a query where I need to get the most recent orderdate from a list of unique records that includes customer and orderdate: Customer OrderDate 22222 010107 22222 060106 22222 010106 33333 010101 33333 050105 Any help would br greatly appreciated!... 7 12/11/2008 12:53:15 PM How can I make the name of a record an attribute in a table? Hello, I have several tables that look like this: ProteinName Signal ProteinAmount A 10 20 B 5 20 C 30 30 (about 1000 proteins) I have about 50 of these tables. I want to make a larger table such that all the signal readings for protein A are side by side, all the readings f... 3 12/11/2008 6:36:24 AM Normalizing semicolon delimited rows Is it possible to transform data in a semicolon delimited field into individual rows by using a query in Access? I can write VBA to do this but would prefer to use a query if possible. Each entry in the field is 6 characters in length separated by a semicolon. Patrick =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Patrick Jackman Vancouver, BC 604-874-5774 ... 3 12/11/2008 6:08:42 AM Compare to Previous Record Access 2007 on XP - I have a table that has: claim trans date examiner 1 1/2/08 MB 1 2/9/08 MB 1 5/21/08 DG 1 7/18/08 DG 2 1/5/08 KY 2 3/1/08 KY 3 1/6/08 PB 3 3/19/08 PB 3 6/12/08 RS What I need to do is find out w... 4 12/11/2008 2:40:56 AM Iff Statment in a IN() string... ... 1 12/10/2008 11:25:00 PM Update problem using Dsum with like I have a table containing the directories, names and sizes of a set of files. I have created a table containing just the directories. I am now trying to update the directory size column of the directory table by summing the sizes of all files in each directory and its subdirectories. My query returns a data conversion error. Both size fields are 'doubles'. My query is: UPDATE Directories ... 5 12/10/2008 10:23:01 PM 589 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>