Recent content by tlindeman

thank you I will give it a shot

Ok, Table A has two columns Style and Cost. Right now Cost is blank. Table B has Style and Forecasted Costs . Table C has Style and Actual costs. What I would like to to do is update the costs in Table A with Table B forecasted costs and if there is no style match in table B update with the...

What I would like to do is update Table A from data in Table B and if it is not found in table B update from Table C. How do I do that? Thank You Tony

Could you please tell me if there is a way in access to prompt for dates in a SQL stored procedure? Maybe in VBA? This is all I have right now: exec uspScorecardSSSDetailAllStoresNet3 '9/03/2012','09/09/2012' Thank you Tony

I found code (through this site) to upload a spreadsheet into a table. However, is there a way to create a macro to prompt me for the name of the spreadsheet? The name of my spreadsheet changes weekly. BTW I am using Office 2010 Thank You Tony

Could you please help. I am trying to build a statement where the data is not in one table. I keep getting a "data mismatch in query expression". All I am trying to do is get the data from table dbo_tmphistorical where the store number does not exist in dbo_Xpientstores. I pasted the SQL...

O.K. That makes sense. I was going to use SQl because I wanted to setup a connection in Excel. However, I think can just setup the control interface and have the user run all queries through there. Thank you Tony

Good afternoon, What I would like to do is run several queries and overwrite a table each time. Each query has the same field names, however, different data. For example, one query is Same Store Sales YTD that has fields: Store number, Average Sales this Year, Average Sales last Year. Then...

Bob, I cleaned it up( I had some SQL paramters wrong) and the query works great, thank you very much for your help Tony

Thanks Bob, However, I am still getting a missing operator error, any ideas? SELECT Switch(Factsalesweekly.[IVRnet3] > 0 And Factsalesweekly.[IVRnet3]<= 2999.99,'0000-2999, Factsalesweekly.[ivrnet3]>2999.99 AND Factsalesweekly.[ivrnet3]<=3999.99, '3000-3999') As...

Thank You for your help, what I am trying to do is classify sales in different categories (Strats) so we call sales IVRNET3, so when IVRNET3 is greater than 0 but less than or equal 2999.99 then I want it state 0000-2999 in the blank column which I am calling AUV_STRAT, when sales are greater...

Hello, I have been fighting with this Access query all morning, however, I think I am close. Right now, it is not complete, but you will get the idea. What I am trying to do is if sales (IVRNET3) are between certain numbers than categorize them in the AUV Strat field. I am using switch ...