Search results

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...

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...

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 ...