Search results

Hi , Thanks for your reply. What i want to do is: I have a table of records ( of payees) some of which may appear twice, eg jblogg £10 , jblogg £17,Another £23 etc. At the end of the day i want to extract from a list of records of payees, where jblogg only appears once irrespective whether...

Hi all, Before i explain my problem, please note that i have posted a similar thread in the queries forum. I hope i'm not offending anyone! My problem is this: I have a table with payments made to sundry payees. I've made a simple query which groups the payees. However I would prefer to see...

hi, thanks for prompt reply. dont quite understand what you mean.. I had thought of making a table which was grouped by payee. the use that table to extract the list by removing the repeated payees and leaving just the one of each payee. 1. i dont know how, 2. seems to over elaborated. regards

hi all, just wondering whether query can be done that will search through a table that will extract a list of payees. However if a payee was paid twice i just want it to appear once. Regards

My sincere apologies... I did not intend to cause any bother. I was just curious whether there was another way of tackling the problem. Once again my apologies Kind Regards

Hi again, Is Dateserial a date function? can't find it in the Access Help? Kind Regards:(

Thanks this worked a treat too....

Thanks worked a treat...

hi, Wondering if someone could help me. I would like to write a vba script which would extract the the previous month's entries in relation to the now function.. in other words i have a list of date related entries and i would like the script to extract data that pertains to the previous...

Hi all, Hope someone can help.... I have a list of entries which includes the date. I would like to have a query which would extract the previous month's entries in relation to Date()... in other words I have a query which extracts the current month using >=Format(Date(),"\1/mm/yy").. I...

Thanks, penny dropped. Thanks again.:)

Hi, thanks. But why format? and why is there a switch in the form of a \ ? and why is there quotation marks? regards

hmm.... not quite certain. I know it should look at the first day of the month [ Date() ] and beyond. I'm not quite clear on the construct!!!

Hi, Can anyone explain the logic of this parameter?;) >=Format(Date(),"\1/mm/yy")

Hi all, Does anyone know how can I extract the data dictionary from an MS access database? or export it to word? Regards :confused:

Hi all, Sorry for insisting. Can anyone find me a solution for the above error. I have read the help and microsoft webpage but I cant may it work. Please see my previous thread. Thanks Eddie Regards

Hi all, I have a main form and a subform. My main form contains a list box which is based on a query which is based on a table.The form also contains the subform. My intention is to pick an item from the list and the results displayed in the subform. Simple.... however I'm getting the error...

Hi all, grateful for some help, I have a table of persons many of which belong to different departments. I have a main form with a combo from which I can select from a list of departments. my question.. how can I produce a list as either a table or a form which responds to my choice. i.e all...

Hi, Just one last request, I've made it all work... however how can I pick my saved template (its a htm template) Thanks:o

Hi, thanks for your suggestion....i've managed to glean some useful codes from there. Many regards