Recent content by pm709

Thanks for the code. I made some mods but works fine.

Hi all: I need some help in this please. I want to create a field in a query that inserts a word every 3 records; this is: it counts 2 records and inserts "my_word" only in the third record, it counts another two and inserts "my_word" in record # 6 and so on, no matter the way how other fields...

Hi All: This is giving me a hard time... What I need is to export multiple queries to a different comma delimited txt files, based in different criterias using VB code with a touch of a button.. But I don't want to create such queries at all (about 185) which is a long trip, even using...

Wow! Fast response, Thanks.

"Not is null" or "Is not null"?

Hi: First of all; let me say it: You guys are the Best! OK, this is (I guess) a simple question: I have a field in a query: F14: IIf([F4] Is Not Null,[F4],"MISCELLANEOUS"). This statement inserts the word "Miscellaneous" in field [F14] if field [F4] has a blank (empty) record. But I want to...

Just put the desired word in the criteria box and the query will return only records containing that word, you can specify: "your_whole_word", or "*Like_this_word" etc. You can find many ways to specify criteria in a query in access help.

Hi all. I have a table: tblCategories with 2 fields: Categories and Page#, where Page# is autonumber. ----------- ------- Categories | Page# ----------- ------- Accessories | 3437 ----------- ------- Antennas | 5384 ----------- ------- And I have a...