query breaking

Hello all, I am in the process of creating a VBA macro in Excel 2010 to scrape text from a list of websites to examine the frequency of words. Ideally, I would like to plop in a list of thousands of websites and let the macro run overnight. I’m running Windows 7 64bit. Ill post the entire...

When I run my query, I'm getting this message: "You tried to execute a query that does not include the specified expression '([Net Amount]-[Accrual Amount)]/[Net Amount]' as part of an aggregate function." The fields [Accrual Amount] and [Net Amount] are in the Total category of "Sum" and the...

Hi, I have a function in VBA 2008 which returns the results of a query within the requested date range. This query works beautifully if I remove the where statement. Otherwise, I receive the error "Either BOF or EOF is True, or the current record has been deleted. Requested operation requires...

When every I run a Append query I get a error " The INSERT INTO statement contains the following unknown field name: 'Scac(BKG/FRT)' Make sure you have typed the name correctly, and try the operation again." The field name is correct ie - Scac(BKG/FRT). If I edit the query by just selecting...