When I run a query, I will get multiple rows of results (multiple records) via a spreadsheet format. I would like to access every cell in the query results...

I have a select query where I am doing a left-join with two other tables, but the query output is almost double the number of records in the table I am...

I am trying to export a query to a .txt file. I can't get the number field to right align. Any help would be appreciated.

how do i design a query to pull specifics from a field

I have two tables in my database. TableA has a field that contains filenames only. TableB has a field that contains the full path and filename. In my query,...

I am making a calendar which has a table of all the days & another with birthdays + I want to be able to print out a report combining both tables but the 1st...

I have a query that looks at the invoice field of a table, and based on the data in that field, for each transaction type "DI", changes the transaction type to...

I need to caluclate the maximum number of tanks by chemical that are on a lot on any given day over the course of the reporting period. The reporting period...

I am using Access XP. I would like to identify unique values in tables with a query. This is how the raw data looks: Customer Date A ...

Hi, I will require 5 tabs in the report. All reports should be able to use the same result set, but not all columns will appear in each report. They will just...

I am successfully pulling data fields from table-A to table-B based upon record field relationships. Now I would like to write a query to tell me when...

I am trying to run a simple access query I have a database of names - first name, last name I would like to create a query - where it shows the entries , where...

I have a table that contains multiple information about meetings between companies. The table consists of a meeting key, a foriegn key from companies and a...

Hi everybody the following query is running fine from Access but when I am putting the same query it in a access form to query the database and export...

I'm using Access 97. What entry do I make in the Criteria section of a query, for a control which only contains dates, so that I only get the record that...

Hi, I am setting up loans database with a table holding all the dates that items are going in/out. I want to be able to ask user for the dates and search...

I would like to create a query that shows records that don't meet join criteria. One table has all records, the other has those I want to eliminate. What...

Hi All, I'm desperately trying to use an old access query and translate it to be used in SQL enterprise manager. The dataset i'm trying to update is too...

Hi all, I have been trying to figure this out for the last 14 hours and am making almost no progress. Any help is GREATLY appreciated. I have two tables: one...

I generate the numeric values that I want in a cross tab query but cannot get it to change the values to percentages in relationship to totals in that view. ...