I am (still) developing with VB 6.0 and MS Access 2000 on Win98-R2.
Is it possible to easily/reliably query two tables that each exist in a
different database, then return the results in a single recordset?  Or must I
create a linked-table reference in one of the databases?  Or ...

I want to calculate in every month how many days (like Mondays, Tuesdays etc)
are falling. Basically I have two group of People (Monday, Wednesday, Friday)
and (Tuesday, Thrusday, Saturday). And want to calculate number of days
possible for each group in a month. It varies from ...

I am creating a report break down by area code. I use cross tab in query and
form to input the area code. Each time, the form pompt to enter the area
code. After I enter the area code, it show up the error message as "Microsoft
jet engine does not recognize " as valide frield ...

is there a way to pull report for a week showing Sun, Mon, Tues, Wed, Thurs,
Fri and Sat for each individual rows.
Thanks
TechRon

I've inherited a database that works fine for the users.  One of the fields
users enter data is the time of the day (Seperate from the date).  I need to
create a new report that show how busy employees are based on the time of the
day.  I want to create a query in which I can ...

I imported queries from an Access 97 database into a blank Access 2003
database and wanted to ensure that all the queries were imported.  When I
referenced the QueryDef.Count property in each database (97 and 2003) I got a
number greater than the number of queries that I counted ...

When I put a date range on my query then try to create a pivot table with
that query I will get an error, "Problems obtaining Data". How can the pivot
table prompt the date range field parameters before creating the pivot table?

This is working fine on our all Access 2K production machine. (without the dbo)
I moved this table to a backend SQL test enviorment and I get the error that
this is not updatable.  I have timestamp fields in both tables and have
checked premission to see that everyone has insert, ...

When adding a record I would like to combine part of two fields (first 3
letters of the Province field and the last 5 digits of the Autonumber primary
key) to form a unique "Stock Number".   I used an append query with a
concatinated expression.  Every thing works fine except the ...

I MADE A DATABASE MADE 4 TABLES AND FORMS ETC.  WELL ANY WAYS EACH TABLE
CONSIST OF 1000 QUESTIONS.  I NEED HELP MAKING A QUERY TO RANDOMLY GENERATE A
100 QUESTION TEST FROM THOSE 1000 QUESTIONS.  HERE IS THE KICKER THE 1000
QUESTIONS COME FROM 10 DIFFERENT BOOKS/SECTIONS.  SO I ...

Our work system has recently changed to Office 2003 and when I open Excel and
then go to edit a query thats allready set up (preferably in the wizard mode)
it starts to think and "install from Office 2003", then I get an error
message saying "Error 2709. An internal error has ...

I designed an Access database in Microsoft Access 2000 using the MID
function in a few queries that some reports run off of.  When I run this db
in Access 2000 it runs just fine but when it is run in Access 2003 I get the
following error..."Undefined function 'mid' in_expression ...

I'm trying to update a table with values in another:
UPDATE [Stock Report] SET [Stock Report].Name = (SELECT [Status Assigned
Work].Name
FROM [Status Assigned Work] WHERE [Status Assigned Work].[Serial No] =

I want to make a query. My query works. But when i wanto take max of the
three columns, it gives some errors (works but not with errors).
My query is like this.
http://img399.imageshack.us/img399/9467/myquery1oc.jpg

Does anyone know how you can you bulk copy all your MS Access queries
from one database to another, without having to copy each one individually.
Any help would be appeciated.
Regards,