Search results

Please Help!! I have a linked table that I’d like to append data from excel spreadsheet every month. Is this possible? For example, I have a linked table (REV–COGS Table) with January data. I will like to add onto this table February’s, March’s April’s…..December’s data by link tables so...

Thank you pbaldy, the issue is solved. Your posts did help!

Thanks, I fixed that and now I get a new error; "Syntax error in JOIN operation". HELP!!

Thank you. The parameter prompt is asking for "SumOfQTR3 FORECAST", the spelling is correct.

Hello All- I am using a union query to sum the result od 2 queries. the query asks for "parameter value" when run. How do I solve this? Please help. Below is my code. Thanks all. SELECT [Delivery Org], Sum([SumOfCY10 Q1 TOTAL ACTUAL]) AS [Q1 ACT], Sum([SumOfQTR 2 FORECAST]) AS [Q2]...

Please- I have a field with revenu and cost of goods sold amont called "Total Local Currency Amt" and another field called "P&L" with values "REV" and "COGS". I want to split the the "Total Local Currency Amt" into 2 columns; Revenu and cost of goods sold depending on the value (REV or...