Search results for query: *

This worked syntactically, but the numbers aren't adding up right ... I just noticed that a few moments ago. SELECT Sum(P.[8-Est$-Pre2002]) AS total_1, Sum(P.[8-2004$-OrigEst]) AS total_2, Sum(P.[8-Est$-Pre2002]+P.[8-2004$-OrigEst]) AS total_3 FROM Projects P; Yields the resutlts: total_1...

Skip Thanks for the help ... i've worked mostly with Oracle and I am always struggling with syntax in Access. A follow up question out of curiosity: why wouldn't Access accept the following rendition of what you showed me? SELECT Sum(P.[8-Est$-Pre2002]) AS total_1, Sum(P.[8-2004$-OrigEst])...

I am trying to get the sum of multiple fields in a table. The query listed below will get the sum of each of the 2 fields (total_1 and total_2) in the query. How can I get the sum for both columns in 1 field (e.g. sum_total)? How can I continue to include additional fields? SELECT...

I want to be able to open an excel workbook, refresh the data, and then save the workbook again from a command line. Anyone have any tips?

I have a column of dates, and I was wondering if there were any way to return what day of the week each date was. Any suggestions?

I have a database in Access 2000 which was using autonumber to autofill the key, "Item Number" on a form that allows users to input new "Items." I needed to batch input some items so I did it in excel and imported the entire table. Autonumber has now been turned to number...

Alright, I'm trying to get a start on this one, and I know there are multiple methods. I have a workbook in which one sheet holds columns of data, one of which is acct number. When this sheet is originally populated, some of the acct numbers are wrong, and need to be changed. I want to add a...

Thank you tons.

Ok, here is the code that I am using Private Sub Form_Load() Me.ItemNumber.text = Forms![Find Item]![Text84].text End Sub and here is the error I am getting "You can't reference a property or method for a control unless the control has the focus."

Hi, I'm not really used to programming in VBA, although I have some experience with VB. I'm really annoyed at the fact that you can not reference a control in Access without it's having the focus. First of all, this doesn't logically make sense to me. Second of all, I can't figure out how to...