You could import the data from the two sources, creating a table for each. Then, you can create a query that compares the data in the tables. "TedChicago"...

Is there a way to auto-update front ends on users desktops??? Thanks, Emma -- www.bardpv.com Tempe, Arizona

I've been watching this group for a couple of months now and have noticed that most design questions are posed in narrative form. I propose we come up with a...

I'm trying to set up a database in Access for our Instructors but am running into a problem. Some instructors teach multiple programs which in turn has...

Hi I am trying to avoid being able to do double bookings in a form. I have a combo box holding 3 options eg AM PM All Day. Based on the date of the...

Hi, I have a series of table containing data over the past 2 years I am analyzing with the table analyzer and I am dividing it up and I have one question. ...

Hello there! I'm having an issue with access 2000. I'm trying to make one form where I can select from different tables from list boxes, and then have my...

Can someone help me with where certain fields should go (I am self-taught so please bear with me!) I am creating a database to store information regarding...

We have a database for our recieving department. For each package recieved, a lot number is assigned and typed in. Now we are looking to automate the lot...

Hi, I am suposed to create a database manually. By this I mean using SQL statements. I am unable to figure out how this is done though. The only way I can...

I was wondering after reading some comments about table design. Is it wrong to use a lookup in a table to store the text of the foreign key to make the table...

Greetings, We have an Access database that was originally designed back in Access 2.0 days. It's since been added to and convert numerous times; today it's an...

I have a report that runs off a query. The report displays the data in a graph on one page. But there are hundreds of the same page over and over again, so...

I want to make the field names in the table I am working on wrap through two lines. Is this possible in datasheet view?

I would like to use the calendar control to set a start date in the database and then automatically calculate a date 12 weeks after that date, but I would also...

I need to calculate time differences (in hours and minutes) across a couple of days. The database is set up with a separate fields for date and time. Can I...

I have an HR dbase with S.S.# as the primary key and info about a person's position. I also have separate tables with S.S.# as the foreign key -- one has...

I'm looking for help on database construction. We have a current database that would appear to be not normalised so I am looking for help on the correct...

I have recently been aproached with questions about Document management / Relational Databases for managing business. I also recently attended a presentation...