Recent content by n4467r

Sorry for the vague question. It seems that the root of the problem comes from the format on the imported field "Letter Code". With a general format in excel, it viewed some as numbers and some as text so importing that file to Access seemed to confuse the query. When I converted the excel file...

Sorry, I am new at this. My table contains a database of records pertaining to a direct mail project. There are over 800,000 names (or records) included and each record is assigned a “letter Code”. This letter code field contains both numbers and letters such as: Letter Code 21353231 21323241...

I have a database for a direct mail project that contains a field to identify the specific letter for each recipient. This field contains both numbers and numbers with letters. Example: 21353231 and 33233021BOA. I need a query to identify the total number of records processed for each letter...

Try this link http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/html/acfctDLookup.asp Good Luck! David N4467r@comcast.net

You are probably right about returning the max value but it does seem to work for my table. Perhaps because the previous tach reading would be the max value and the expression &quot;[ID] < &quot; & [ID] must take the max value before the current entry??? Not sure but I may try using the...

Worked like a charm as: Start Tach: DMax(&quot;Tach&quot;,&quot;Aircraft log&quot;,&quot;[ID] < &quot; & [ID]) There is a date field in the table as well but I am not sure about the second option's syntax. I might explore a a bit when I get the chance. Thanks so much for the help! David...

I have a database based on airplane usage. When the airplane returns from use a reading (hour meter) is taken and placed in the log. I have been trying to develop a query that will take the current reading and subtract the reading from the previous record. The result would be the flight time...

Thanks for the reply. Being a bit new to this stuff I am not sure I completely understand the syntax but if I play with it for a while I may just get it! Thanks again.... David

I am new to this board and have a question. I have a database set to log hours of use based on an hour meter. To calculate current record usage I would subtract the previous record meter reading from the current record meter reading. Entering a beginning meter reading would seem redundant but...