Is it possible to update a field of one record (rec2) based on the value of the same field in a different record (rec1) where rec1 is the source of rec2 and...

Hello, I have an Access '97 database with a table containing a Yes/No checkbox field. When I query the records in the table with no "Yes/No" criteria...

Hi experts, can anyone tell me how to populate a number field with the numbers 1 thru 639? Obviously, this will be sequential like an autonumber but I already...

Hello everyone. I am trying to calculate time from time in to time out then get a total. It works fine when calculating from example 7AM to 10PM but if you try...

Hi all, I've got this query: SELECT a.Item, b.Cost, b.Category FROM b RIGHT OUTER JOIN a ON a.Item = b.Item AND b.Cost = (SELECT MIN(Cost) FROM WHERE Item...

How do you find a changed record by comparing two tables. I am looking for price changes, inventory quantity, contact names, etc. I have used the unmatched...

The table shows "Jan. period 1", "Jan period 2", "Feb. period 1", "Feb. period 2", etc. mileage by vehicle as fields. How to write a query to show only the...

Dear Sir, In My Stock Master Table I am having following fields. StockMaster ------------- ItemCode Quantity Rate Value ------------- ...

I have a table called "tickets" that holds help desk ticket information and another table called "ticket_log" that holds all the changes that were made to the...

Im trying to take records from one table to another only if a value in the record being transfered doesnt already exists as a vlaue of an item in the table, is...

Hi! I'm a novice user at Access 2000 and would appreciate your help on a problem I am trying to solve. I have two queries currently setup that give me...

I am trying to display zero's and have been told to left join them. I am still having troubles. I have one table that says "Hospital Name" and I am linking...

Hi: I am trying to query a table's field that contains date and time data. The data type is Date/Time. Anyways, I would like to create a query that looks...

Hi All. I have table that contains a date field. There are many records with different dates that go throughout the year. I want to group the dates into...

I have to create a lookup that will come back with the following Form & Color values: Subj CRS Form Color ENG ...

Hello all! I hope you'll be able to help me out with this situation: My boss is running WinXP Professional, OfficeXP/Access XP(2002); he is using dbases he...

I need a lookup scenario that gives me the form & paper color listed below All ENG 100-699 courses (except ENG 265 & ENG 266) Use form 1 & Pink paper ENG 265...

First I wrote: I am working on a database that seats passengers and pilots on hot air balloon flights. I have six tables for flights, one for flights with...

Hello, I display records on the form. Then I delete one of the records directly from the table. Then I want the form to redisplay the records except the...

I want to be able to email the record that I am currently entering into a form. I created a control box set to run a query on my form and called...