Search results

Hi, I am trying to add two text criteria to a query to exclude results that contain either word/phrase. I have tried the following: WHERE (((Matches.Result) Not Like "*D/L*" And (Matches.Result)<>"No result")); and WHERE (((Matches.Result) Not Like "%D/L%" And (Matches.Result)<>"No...

Hi, I've got a table that contains ball by ball cricket data. An extract is attached. Currently, I import it into Excel and use the following formula (copied down) to find the first delivery a batsman faced in each match, then the second, etc...

Thanks guys, I understand now. And thank you for answering the question that I should’ve been asking!

Hi all, I have two tables, BBB and ScB, and have designed a query to make a new table. In essence the new table just adds a field to BBB from ScB. The query works ok, with one exception. Ideally, I would like the field from ScB to be added to the new table only if the value in a field called...

Thanks for all the suggestions guys. I really appreciate it

Hi, I have a database of 5 tables that I have imported from 5 csv files. I have then run different queries to produce new tables of combined data, converted date formats and added a calculated field to one table. I have then linked the new tables to Excel for analysis. The csv files are...