Hi Everyone, Does anyone know how to do this? I need to export a series of queries to 1 Excel workbook, with each query being a new tab. I have pretty...

Warning - I am a complete novice to VB. However, I have a situation where the Split function is really needed in a query. I copied the following from the...

Trying to get a query to determine a tax rate based on the province on a record. It should look at the field and based on what is in that field come up with...

I have a reservation application that I have obtained reservation data from an email message (daqta from which is entered into the tblWorking table). The...

Hi Guys, Been struggling a bit on this so a pointer would be great. Just a simple example would do.. tableA with two fields "Startdate" and "Amount" now i...

Hi all, I wonder if you can help. I have 5 tables of data with the same column names. I want to run a query which includes all records from all tables within a...

I have a parameter query works as long as there are related records in the tables. My problem is I when the query results are "null" or no records exist I...

I am in need of help with exporting queries from Access 03 to Excel. I am familiar with the transfer spreadsheet command using DoCmd.TransferSpreadsheet...

My client would like to have 6 or so combos on a form, in which they can query any field from any table, and export the results to excel. yikes. i figured...

I have two tables that I'm creating a query with. Table 1 has Agent field and Table 2 has product field. I'm linking the tables by a primary key. Table 1...

I have a lot of weather data for one month that is broken down by the minute. My end goal is to take the average hourly value of the column values (temp,...

I have an Append Query which runs from an On click event attached to a command button in a form. When the append query fires it adds records to a table which...

Hi, I have a table with new records added, that is some information has been pre-filled. Say I have 3 new records with the same reference code ZZZZZZ - they...

I'm trying to create a make-table query that will group records by two fields. The fields, named "Left" and "Right," both contain 4-digit identification...

I am trying in a multi-user environment to have each user able to add data to the next available, unlocked record. I am thinking this is a query, but not...

I just installed Office 2010 (May 2010 version from Technet download) and many queries that worked in 2003 and 2007 now will not open and produce the error...

I have an Access database that uses a sequence of select, update, and append queries that must be executed in order to perform certain synchronization tasks....

Please help. I've created a query which is pulling data from 11 tables. The query is not updatable. I've spent hours reading other postings ...

Hi guys. I'm using Access 97 (SP2) to do some work for a client. I am running a Union Query on two tables tht are identical, to create one set of data. Here...

Hello all, my database lists parts that have the following fields (amongst others), BOM TIME PRICE CABLES CUSTOMER PARTNUMBER