Queries

Docmd.TransferSpreadsheet
Hello! Can anybody give me some code for the Docmd.TransferSpreadsheet command, which i can adapt for my database (or know where to get it)? I need to be able to create a command button which will export a number of tables into the same workbook at the same time. Ideally, I would like to be able to export b... 15 Aug 2006 07:45

Searching
I have 3 text boxes that I want to be able to use for searching. srcID scrCustomer srcAddress I have a list box below these text boxes that I want to dynamically update as the user types in the text boxes. I thought I had this worked out early but I have sleep since then. :) Here is my sql for my list box... 12 Aug 2006 13:30

Parameter Queries
I am using Acess 2003 and have become quite familiar with it in the past few weeks. I am trying to do a database for someone I work with who is picky and I am trying to create a query that asks you what criteria you want it to show. The only problem I have is that the one I am making this for doesn't want to ty... 14 Aug 2006 15:47

DISTINCT records
Ihave a query that has returned the results that I need to narrow down further. I want to show the fastest time at each circuit, together with the extra detail (Driver, Team etc). Now I can get the right result, showing 72 rows detailing Country, Circuit and Time, using example 1 below. However, if I try and a... 8 Aug 2006 09:54

split address field
I am working with a large database imported from excel. The address field may contain a street number followed by a street name followed by an apartment number. Some addresses have no street number, some have no apartment number. I need to compile a walking list from this data so I need to extract the street... 7 Aug 2006 23:45

"Find Duplicates" Query
I have a query to find duplicate invoice numbers. I use the access find duplicate wizard query as follows: SELECT Invoices.AssignorInvoiceNumber FROM Invoices WHERE (((Invoices.AssignorInvoiceNumber) In (SELECT [AssignorInvoiceNumber] FROM [Invoices] As Tmp GROUP BY [AssignorInvoiceNumber] HAVING Count(*)>1)))... 6 Aug 2006 16:53

access date query
I'd like to be able to return a text cell value from a table that includes fields for "start date", "end date", and the text value that I'd like to find. My plan is to use an update query that would post this value into a different table. I'm new to access and would like to be able to do this in the wizard sc... 8 Aug 2006 10:26

Need help calculating time difference from OBDC table
I am using Access for reporting on data in a table that is controlled by a separate software program. The start and end date and times are in separate fields in each record and I need to calculate the difference between the values. Data format is as follows: start date: 20060802 (YYYYMMDD) as an integer star... 4 Aug 2006 08:45

UNION vs UNION ALL
I'm using a UNION query to join survey results for different types of questions (rating questions are in one table, text answers are in a different table). I ran into a situation where using UNION ALL to get data from the two tables was only bringing back data from the first table in the query. But, when I chan... 31 Jul 2006 19:25

Sorting UNION query
Hi folks, I wanted to create a query that returns a list of company names sorted alphabetically, and then I just add 1 line (constant) to the top of the list so my results should look like: _____________ MyStringHere Axxxx Bxxxxx Cxxxx Dxxxxx _____________ I created the following query that works and doe... 26 Jul 2006 11:13