Search results

We are faced with a problem where we have a table and need to find “the last log” (From Table1.Field3): [Please see Excel attachment for Table example] - Although we are using MS Access. We need to: 1) Find “Log5 05/01/2008” from Field3 (we already have an idea what the date we are searching...

Thanks Brian, I will give that a try.

Give that a try now...

I have a spreadsheet with several tabs. All but one of the tabs collect the same data, but for different countries and then they have a column within for each day. This is just typed into the spreadsheet and is not in ODBC data set. The last tab is simply a summary. So the columns are added...

Finally, I managed to do this after much determination. Basically by use of one huge Macro and 4 Append Queries: Macro1 – a) Crates a List to sort the data in to an acceptable format and remove bad data. b) Index all this data (and then have the macro copy this and add 1 to the Index) c) Query...

I have a list of events and what the out come was on a particular day or date. To give you some idea, the event is basically number given to a day and the outcome is all possible things that “could happen” and that did happen (so not all 160 possible Outcomes are used all the time). So it is...