Search results

FIXED !! I have data control on a form datControl(1) which upon opening the form in vb goes through the following process to remnove the contact between the data control and its normal database. datcontrol.databasename = a different database datcontrol.recordsource = "select * from tbl_dummy"...

Help! how can I select the max of three fields? I have a table with field1, field2 and field3. I'd like to know which is the greatest value but the max function only works vertically.. any help to save me having to write a monster iif statement or coding in vb would be appriciated! thanks WB

SELECT [fiftykLabel] as section FROM (SELECT a.section_label as fiftykLabel, b.section_label as twofivekLabel from [dsw 50k ends] as a left join [dsw 2500 ends] as b on a.section_label= b.section_label) where [twofivekLabel] is null every time i try to save this query access closes with an...

am I going mad - table names and errors In access 97 changing the name of the table meant that a query that used the table would no longer work because the table reference would be wrong In access xp changing the name of the table automatically updates the reference in the query. Can this be...

Hi all, A friend has asked me to write a simple search tool to lookup records in a table containing certain words. I can do a simple query using SELECT * FROM table WHERE name LIKE '*word1*' or name LIKE '*word2*' but was wondering if there is a more appropriate method of doing so.. I...