Search results

I am trying to do a search for dates in the three letter format. That is I need the database to look through a memo field and find strings such as "NOV", "DEC". It needs to locate the positions ( using instr function) of these strings on the condition that these months are close to the current...

There is a program which produces .txt files for various records in a database. How would i import this into my database as a memo field. The id of the record is contained in the filename e.g. 6tYUE.txt thanks

I am trying to write some code in VB which will go through a block of text stored in a record and pick out a special 8 digit no. in each record the number appears on the following line phone 001 3digits/4digits/8digitnumber of course each time the letters vary but the format is always the...

I have a subform, stuck in my main form, which I have been trying to order by one of the fields in the subform but to no avail thanks in advance regards Johnn

How can I produce a report that counts the number of times particular variables appear in a field. The field is called "Types" and I have set it so that each record can take on 1 of the following three values: "C/N & INV" "IN & OUT" "C/N" regards

Hi everyone I am quite new to the World of Access(3 months) and I am encountering problems with one of my reports. I have one column containing prices of invoices. How would I go about adding a Sum total at the end of the report. I need to do this for two columns/variables. Thanks John