Search results

ANd for my next trick I hit post new instead of reply .... really chalking up the smart points today. PB

I do apologize for wasting anyone's time with this. DistinctRow did Exactly what it was supposed to... I just changed it to Distinct and it only looked at the one column. Sorry. PB

I've got a table Dept_Info ID...........Dept.........DeptGroup.....Station IA702.....PC............Plant 1...........N1 MA702....PC............Plant 1...........S1 IP000.....PT.............Paint..............P1 IW000....BW...........BWS...............B1...

Closing thread: WIll post elsewhere. Thanks everyone. PB

Yeah I agree that storing calculations is not a grand idea but alas, most of what I do is based on what I am told. Also, the data the calculations are pulled from is discarded after the calculations so any future queries aren't possible. Sooo, I store the appropriate totals in my little...

That sounds great but unfortunately, I failed to mention that I am executing the query in VBA and also outputting to Excel. There is no drop down box for it. Is there a class method that I could add that would do the same type of thing? Below are the default methods generated. With...

Thank you PB

I've got a table Dept_Info ID...........Dept.........DeptGroup.....Station IA702.....PC............Plant 1...........N1 MA702....PC............Plant 1...........S1 IP000.....PT.............Paint..............P1 etc... and a query (Costs) that returns DeptGroup......month Plant...

Yes, exactly. I get the totals out of a query and need to store them in a table that already exists. This will be done monthly in the fiscal year. Like I said, if the update query is unreasonable, I can use alternate methods... Thanks pb

When using this, .Application.Run "fileName.xls!MacroName" in Access, can any parameters be passed to the macro? If not is there another method? Thanks PB

Thank you Very helpful indeed. PB

More This update query failing isn't really important since I was just trying to get started with the real one and didn't even get that far. I need an update query that will use the values in getTotals to update yearCostRecord. If this is impractical I apologize for my over zealous desire...

ah, I'm being too vague... It gives me a dialog box asking me for getTotals.DeptCode instead of using the data in getTotals to fill in the value for that month in yearCostRecord. PB

Hi everyone, I've got Dim Public varName as String in the declarations section of a form. How can I access this variable from the code in another form? varName crashes and shows as empty... Any clues? pb

Good morning all, I have a query that returns DeptCode TotalRepairs IA702 500 MA702 700 etc. query name is getTotals I need to update an existing table with this data depending on the month chosen from a drop down box. Table DeptCode January February March etc...

This query SELECT DISTINCTROW [companyGraphData].[Dept], Sum([companyGraphData].[TotalRep]) AS [Sum Of Rep], Sum([companyGraphData].[TruckCount]) AS Trucks FROM companyGraphData GROUP BY [companyGraphData].[Dept]; gives me this table Dept Sum of Rep Trucks data data...

Oh. Well, isn't that neat. Thank you so much. I should have remembered that from object orientation, huh? PB

Hi all, this shouldn't be too difficult, I just don't know the syntax. I tried to do this in the code for a form. deptCount = DoCmd.OpenQuery("countDepts") and it won't compile. How am I supposed to do this? I need to capture this number in a variable because I'll be using it in loops and...

Cool, thanks all. PB

Hi all. Is there a way to store queries in a table?.... the query_name.dqy files???? blobs or anything? I can't store just text because it only allows 60 characters and most of my queries are quite complex. Is there another alternative to text not in the drop down list? Read on if you want...