Search results

Hi I'm using Microsoft Query to get data from a MS Access database into MS Excel. It seems that whenever I pull data from a UNION QUERY or SELECT QUERY based on a UNION QUERY I get an error message: "Too few parameters...expected 8" Can anyone offer suggestions? Thanks

I wonder if anyone can help...I have a report with 2 linked objects: one is MS Word, the other MS Excel. When I send the report to MS Outlook as an attachment, the only way I can display the 2 objects is by using Snapshot format. Is there a way I can display them using either Word or Excel? I...

I wonder if anyone can help...I'm using domain functions to get data for a pop-up detailing last record in a table & number of entries made that day...the relevant part of the code is: Dim dtLast As Date Dim intCount As Integer dtLast = DMax("[Date Received]", "tblLoad") intCount =...

Hopefully someone can help.... I'm trying to change the name of a column in a table using SQL. I've tried different combinations but always get "Syntax error in Alter Table statement" SQL I've tried alter table tblImport rename column F1 to [Date];* alter tblImport rename column F1 to...