Search results for query: *

Returning after a lengthy absence (had a son at age 60, now 2): I can't believe how skills atrophy!! Here's my sumproduct, on some voting data, which consists of 37592 rows: SUMPRODUCT(1*(Data!$AR$2:$DB$37592=$C$1)) where $C$1 is an election date, gives me a count of those who voted on that...

I have a spreadsheet that takes 2 minutes to open, and the same to display a cell whose formula is merely a link to another cell in a different work sheet, i.e. Sheet2!A1=Sheet1!A1. The result does not display, but only the formula, until I place the cursor to the right of the formula and hit...

When I look today at the pivot chart I created yesterday, I have a problem "finding" the pivot table from which I created it. I cannot right-click, or find the "source data" or "series" readily at hand. Indeed even recreating what I have done is tricky, making documentation a problem. What is...

I am trying to chart the occurrence of events, as a function of their time of day and their location. I'd like to be able to group all the times into 24 discreet hourly segments, so that an event at 01:14 is grouped with an event at 01:54 but not with 00:54, etc. The events occur in locations...

A simple question, that I could not find addressed in MS Help or in Que: What is the proper syntax to do a count of dates in a column/range which fulfill a criterion such as >01/01/2001 or between 01/01/2001 and 12/31/2001? If the answer involves serial date formatting, I can deal with that...

I will try to describe briefly this challenge: A doctor (MD) can be hired at one or more of four facilities, A,B,C & D, during any month between 2006 and the present. Thus the table MD contains the doctor ID field (MD) and four Date fields. When the doctor is hired by a facility, he must go to...

Can I do this in one step? find the standard deviation of a group of scores, and then find the average of all scores within (2) standard deviations of the raw mean score? Right now I'm using this cumbersome method to exclude numbers from a range that fall out of two stds...

I am looking for potential duplicate records in a table. A duplicate would have the same LastName and IDNo, but there might be duplicates where an IDNo had leading zeroes, thus: 05887 and 5887 are really duplicates. I've tried running the find duplicates wizard on Table1 with fields LastName and...

Given a number of possible ways in which duplicates might exist, I created several different duplicates seach queries: one looked for Count(*) where >1 of Last & First; another looked for the same where Last and SSN; a third for Last and DOB, etc. Now I'd like to combine all of these and end...

I have a long list of names ("Last", "First", "DOB", etc.) and when I run the find duplicates wizard on one of these fields, I get a very long list of duplicates (e.g. every Smith is listed as a duplicate). I'd like to concatenate this query, so that I can find all the duplicate last names that...

I have not yet been able to combine or concatenate name parts in a query! I have Last, First and MI as fields in a table NAME that I inherited. I want to create a fourth field in the form Last First MI, with spaces between First and MI, if MI exists, and no space after First, if MI doesn't exist...

I need help combining records to create a new table with more fields. Here's a conceptual example: I have one table with three fields: Name Dept Facility Joe A 1 Joe A 2 Steve B 1 Bill A 2 As there's only one Joe here, my goal is a...

I need to examine a table for duplicates; not exact duplicates, as PKs would be different, but one or in all probability several fields would be very similar, due to mistyping, etc.,. So I need a query that would return records where fieldA is LIKE fieldA; fieldB is LIKE fieldB; fieldC is LIKE...

Only three months and I'm rusty as ...! I have two tables, and I want to find via a query, the records in one that are not also in the other table. Neither table has a single unique identifier (I added an autonumberPK afterward), but is unique by virtue of a combination of two fields (i.e. "Map"...

I am getting an error: you must save the record before going to a SetFocus or GoToForm action. The cause is I have a form and a subform, one is addPatient and the other is addIncident. I'd like to trigger an action when a user attempts to add a duplicate patient: no duplicate patient IDs are...

I am looking for a FAQ on a query to mailmerge action such that, from an Access form (displaying one record) I can click a button and pull up a form letter in Word, with Name/Address, etc., information in the mailmerge template. I have searched, and found the long and interesting thread...

This should be basic, but I reinvent the wheel each time: I have incidents and patients, tblIncident and tblPatient Linked via a query with PatientID the PK, serving as a FK in Incidents, I want to have a form frmIncidentNew whereby I add a new Patient to tblPatients in a subform, then go...

I don't know if that subject line describes it best, but I have a subform, continuous form, that selects text strings for a query. Basically it is a multiple choice situation: pick any number from a list. I get this list using a select distinct query. A text box accumulates these text strings...

I have a single table I'm interested in querying. The user needs to select some entries, say a date range, another field, and finally make a list of several possible and existing enties in a final field. I want to design a "query/report generator form" that makes this possible. table name is...

I have gotten this message before, and it is not what it seems. This time it happened when I made a copy of my database, modified a form, and then exported it back to the original database. Something I have done many times before. I think it may involve visual basic, and compliling, but it is...