I've defined a simple select query in Access that retrieves data for a particular date. I execute the query from VBA.Is it possible to pass a parameter into the query from the VBA when I execute ...

i'd like to make a query in access (and eventually SQL 2k) that will combine a table of activities (each row with a unique activityID and activityName) along with a table of activityToUsers (each ...

In Microsoft Access, you can add records to an existing table that already as data and resize the columns that contain the fields and data.

If you need a complete list of Microsoft Excel sheet names, Microsoft Excel Power Query is fast and generates a dynamic list.

Highlighting or even deleting duplicate records in Excel is simple but listing them isn't as easy. Fortunately, you can use Power Query to easily display a list of duplicate values or records.