Search results for query: *

In order to select a dataset, I have to run five queries, three of them requiring date parameters, and two which use a date to calculate a week number. I accept that what I have created is a bit clumsy, and someone with better skills than I possess could probably write a single query to do...

In Excel 2003 and prior versions, if I wanted to convert a table (with headers along the top of the columns and down the left-hand side) to a list suitable for importing into another application, I could use the PT wizard, and by choosing the "Multiple consolidation ranges" option, then "I will...

I've created a macro, and it does the business for me. However, the is a line in the macro which pre-selects the cells. The snag is, I want to use the macro with other sheets, and the cells I would want to select would be different in each case. As it stands, my code reads: SourceData:=...

When I export a date from an Access table, I invariably get it formatted with the time (set at 00:00:00). I can't see how I can suppress this. What I have to to is either edit the .csv file with notepad, using Search-and-Replace, or export it to Excel, and then save that file as a .csv. Is...

I am designing a database for a remote workers to enter data into, and since this data will eventually be exported into a csv file, I want to suppress the use of commas anywhere in a particular table. Is there a way of prohibiting the entry of a comma in the text fields, or alternatively is...