Search results for query: *

Thanks MajP but I have Union All in the query already. After looking at several other posts, I am currently creating new queries for the notes using only the AuditNo, Key, and Note fields (none of which are aggregates). Therefore there is no group by statement. This method retrieves the...

Many, Many, Many thanks to other posts in the forum that got me far enough to determine that this SQL WILL pull the entire memo field. Previously it was truncating at 255 characters: SELECT tblSATEN.AuditNo, Avg(tblSATEN.Score) AS AvgOfScore, Count(tblSATEN.AuditNo) AS Transactions...

Ok, this works: I had to put the reference to the combobox on multiple criteria lines in the query... Criteria line 1 for Product: IIf([forms]![frmselectReport]![cboProduct]="Product1/Product2/Product3","Product1",[forms]![frmselectReport]![cboProduct]) Criteria line 2 for Product...

Because that's what I need to do and I don't like listboxes because they don't "drop down" but rather have to be expanded at all times... unless there's something I don't know.... I did even try a listbox that allowed multiple selections (I left the name cboProduct and had the qry criteria...

I have a form that has a combo box on it (cboProduct). I need users to be able to select multiple products but I know that combo boxes don't allow this. I've made the combobox into 2 columns. One for the product (or group of products which just acts as the visual label) and the other for the...

Nevermind the last post. The record is still changing even without the AbsolutePositionX code...??? I'm perplexed! PLEASE RECYCLE AND ENCOURAGE YOUR OFFICE/COWORKERS TO DO SO AS WELL.

I do have a counter on the form that uses the AbsolutePositionX to find the current record. I think when I take this code off, it doesn't change records anymore. But it is a random changing so I'm not 100% sure yet. Would you have any idea if that function can cause this? The form calls...

All the code is on the OnClick events. The "sub"record changes without the user touching anything. I've recreated the situation by opening the audit, going to the 2nd sub-record and just sitting there. After a little while, the subform will flip back to the first record without me touching a...

I am working with Access 2003. I have a form with a subform on it. When a user opens the form it creates a record in a Main table and when they enter information on the subform it creates a corresponding record in a different table linked by AuditNumber which is the primary key in the main...

Do you have any idea what that custom function would be? That's what I'm trying to figure out but have no clue. PLEASE RECYCLE AND ENCOURAGE YOUR OFFICE/COWORKERS TO DO SO AS WELL.

No, there is really no specified order because it's a detail in a report and not all of the Audits will have the same details and the order that they display on the report is irrelevant to what I'm doing. But I'm trying a different approach and hopefully there is an easy solution.... I still...

Problem with the running sum is that I'm multiplying rather than summing. I might need to explore that further though. If the first one is NO, the score is 0%. The person get's no credit. But it doesn't matter what order they fall in. If I did it the opposite way I'd get the same outcome...

Is there a way to base a calculation in a report on the result of the previous record? My report contains the following headers: Element(text) Result (Y/N) Impact (Double) Score (percent) I need for my report to show something like this: Element YES 1 100% Element No .5 50%...

See, I knew I was making this harder than it had to be! Thank you so much! You've made my impossible job so much easier!!!!! PLEASE RECYCLE AND ENCOURAGE YOUR OFFICE/COWORKERS TO DO SO AS WELL.

I do have AuditNo in my query (sorry I didn't have that above) but I can't figure out how to add fields from tblB to my query. I have it set up like you list above but I want to also ionclude Manager & Location from tblB based on the primary key of AuditNo. PLEASE RECYCLE AND ENCOURAGE YOUR...

Yes, tblA is related to tblB by AuditNo in a 1 to many relationship... PLEASE RECYCLE AND ENCOURAGE YOUR OFFICE/COWORKERS TO DO SO AS WELL.

Normalizing using a query is working like a charm but how do I add data from another table? Say I want to add Manager and Location from tblB to this data so that my fields would include Factor, FacNum, Manager, Location...?? SELECT Factor1 as Factor, 1 as FacNum FROM tblA UNION ALL SELECT...

I'm sure this is easier than I am making it. I have 5 separate fields on a report. I need to find the min value of the 5 fields. Since they are in 5 different fields, the Min(field) expression will not work. Fields are Factor1, Factor2, Factor3, Factor4, Factor5 Min is MinZeroFactor Any...

Thanks SO MUCH AceMan! I can't wait to try these ideas. I'll let you know on Monday how they work!!! Dawn Coleman, Business Analyst UnumProvident Corporation PLEASE RECYCLE AND ENCOURAGE YOUR OFFICE/COWORKERS TO DO SO AS WELL.

How do I concatenate then into the appropriate field as a date though? I have it set up where they enter month and year but they are text fields... I need the query to recognize "October,2005" as a date... As for month-day prior, I will try that! Thanks!! Dawn Coleman, Business Analyst...