I have a query that returns dates and times.  in this query i have a field
that creates a time ("9:00:00 PM" AS EndTime).
This is a value that is needed in every returned record.
This query works fine until it is used in a union query.  I am getting a

I'm trying to run the following query, but I get an error message:
The code:
Dim oDataBase As DAO.Database
Set oDataBase = OpenDatabase("C:\Program Files\Microsoft Visual

I have a VBscript that has been modified to work on 3 different Oracle views,
and  all 3 work great on my desktop. I have 1 of them, that only hits 1
Oracle view, and brings back 6 fields to populate the Access table, I pass
the user ID and password in the script, so it shouldnt ...

aIhave a web site with the database file that I download and update. I need
to combine all the customers data before I upload a new one becuase the files
are the same it over writes the old data.
I want to combine my Data from ex. Shop.mdb (Todays file) with Shop.mdb

Hi I am fairley new to Access and urgently need some help. I have built
a database comprising of various queries, forms and reports which is
stored on a network drive. What I would like to do is have the database
open to everyone as read only, however letting certain users only able

I posted (creating relationships with time series) yesterday within "access
Database Design".
Basically I have 24 tables that are linked to txt files (the output of my
instrument). Yesterdays question concerned how to create the relationships

Is there a way I can read data directly from an access query  to excel
without having to import it to excel???

Right now in Access you can create a favorites list to show favorite queries,
tables, forms, etc.  But my problem is that often I have my own queries in a
database used by several people that has structural updates every so often.  
I can import all of my personal use queries over ...

this is probably really simple!
I have a union query which lists financial data as either credit or debt, so
a cheque paid into the acount is a credit and an invoice charge is a debt. I
use the following code to build up Union Query:

On Friday I posted this:
--An Access 2003 query that has been working fine, began throwing Error 3001,
Invalid Argument when it is run.  It is a Make Table Query, and when 2
particular fields are included in the query, it gives this error.  Without

I have created a query (qryProactive) based on left joins among three
other queries.  The resultant information is generally correct in that
I get the proper numbers from the different queries into the broader
query.  My problem is that as the left joins allow nulls to be carried

Hello,
In my table called billed date: I would like to see all bills =>90 days (and
<=90 days) from bill_date
I have tried the

I have a table that has 54 columns in it. I would like to know how to
see how many of the records have complete identical records in all 54
columns.  Is there an easy way to do this?  I was going to use the find
dups wizard but the size limitation prevents me from doing it.  Any

In reference to the recent post "Need help with a Max function" - I'm glad
you confirmed that that works.
That is how I intended to run a MAX date query  (but I'm not having any such
luck)

I have a simple salesperson and sales history query.
How can I create a form and subform like the following:
Main form has the first select from salesperson to salesperson i.e. sales07
to slaes12, the second select from sales date to sales date i.e. 1/1/2005 to