Search results

I've been struggling for a while to resolve a performance problem with an application I've been developing. Tables within the database (not linked) were taking an age to open at times. I eventually traced the problem to some linked tables whose links were broken. As soon as I refreshed the links...

Hello Gurus, I'm not quite sure how to word this but here goes..... I have a form that collects data from a survey. The survey has been undertaken before and the equipment being surveyed may carry an ID number and I have the original survey data in a table. If the old survey ID is entered...

Hi All, I have a form that takes input to the first, indexed, field from a barcode reader (and keyboard at a pinch). The data coming in has always been numeric so I have several checks in place to ensure it is numberic (field specification) and also that it lays in a predefined range. All...

I would like to find out how to query records from 2 releted tables where the second table has a list of records that are date stamped but I only want to return the latest record with its corresponding data from the first table. In the attached DB I use 2 queries to acheive this but I need a SQL...

Hi All, I've been referring to this forum for a few years but never before needed to post but I cannot find a workable answer to a problem I have... I have a database that collects information on building assets - asset number, description, location, age etc. We often have locations with...