Recent content by jtabb

Changing to an integer is not a problem.

Reply to Paul Bricker: Thanks for your response. 1. The serial numbers are consecutive, w/o gaps. 2. My manual method of inserting a record is to add an alpha character to the number, e.g., serial number: 101A. I then sort the column, and manually begin re-numbering from 101A on. 101A...

I am using an Access table to create a "Table of Contents" for AutoCad drawings. I want to control the sequence in which the drawings are listed in the "Table of Contents" by simplying assigning a serial number to each record, e.g., 001 through 999. When I insert a new drawing in the middle of...

I just tried it and it did not work. It's like the database is gone.

I have an Access database named CRBII. Usually when I open it, a menu box pops up that says: CRBII:Database and all of the Objects (tables, queries, forms, reports, etc.) are available to click on and view and then see in design view, etc. For some reason now when I double click on the CRBII...

SELECT [RM#], (SUM([L/S(max)]) + SUM([L/S(min)])) As TotalSum FROM TerminalUnits GROUP BY [RM#] sums the min and max, I need to sum 2 max's together and 2 min's together. (See my above example and how I added them together for rooms 1.16 and 1.20)

I'm sorry for the confusion, I wrote a wrong piece of information in my question, the sums should equal eachother, meaning the difference would be zero. Here are sample values in the table named Terminal Units: Rm# L/S(max) L/S(min) 1.16 -445 -240 1.16 350...

I have a table that gives detailed information about what is located in certain rooms of a large building. It includes columns of positive and negative values for each entry. For each room number, the values, when summed, should equal zero. How can I create a query to sum the values in each...

(1) Taking your advice, I tried this: SELECT [RTS P/N], Count (RTS P/N) As [Total] FROM [RTS Schedule] GROUP BY [RTS P/N] and i got the following error message: Syntax Error (missing operator) in query expression 'Count (RTS P/N)'. do you know why this would happen? thank's for responding...

I have a table with various flowrates in liters/second. I would like for them to be in gallons/minute. I know the conversion factor is 1 L/S= 15.82 GPM. How can I use Access to convert all of the values in the column from L/S to GPM?

I have a query that contains a list of part number's. There are 4 different part numbers that repeat. How can I make a table or query that totals how many I have of each part number? (Should I be using DCount?)