Search results

I was trying to use it in three separate queries and pull them together in a unison query. Once combined I wanted to combine that field with another for which the value would be A, B, or C respectively from each query. The idea is that I could then sort like this. 1A 1B 1C 2A 2B 2C 3A 3B 3C 4A...

Hi Please treat me with sympathy. I'm a complete novice. Another user on this forum very kindly gave me some code to assist me with creating a field in a query that generates a sequence of numbers based on time/date fields in the same query. However it doesnt stop when it gets to the end...

Fizzio, Is there a way that I can make this only produce a single sequence? I'm finding that it is giving me unpredictable results.

Thanks!! Fizio and DCX, Thanx sooooo much. This will help me no end. BTW I never had a field that was named using a reserved word, but it had a long name so I was paraphrasing. Sorry for the confusion. Fizio. thanks for the module. It works amazingly,but it was a little supprising to see...

DCount probs...still! I have a query with a field that puts the records in sequential order by the ID field. The code is: Num: DCount("*","ABC Query","ID <=" & [ID]) this gives results like ID Num 41 1 43 2 49 4 47 3 55 5 etc.. What I want to do, however, is have the...

DCount syntax prob. It will be an easy one if you know how. Hi I want to put an expression in a query that generates a field with sequential numbers. (1,2,3,4, etc.) I have created an expression using DCount which works just fine. The expression is this: Num: DCount("*","ABC Query","ID <="...

I have a query that pulls records from a table based on the value of one of the fields. I would like to put these records in order based on a date field. I would then like to have each record assigned a a whole number (ie "1" for the record with the earliest date, "2" for the ext one...etc. I...

I'm an access newbie.... Please help! I want to create a query that: 1. Only pulls in records from another query where the value in a given field is "A". 2. generates a number (1,2,3 etc..) in a an entirely new field for each record that it pulls in. This might be simple stuff to many of you...

:confused: :confused: :confused: I have a problem. I am trying to get a field in a table to somehow automatically enter a value of either A, B or C. I want it to put in A if a value in another text field in the same table matches exactly the text value in the "A" field in another table. I...

URGENT! Please help!!!:( I am trying to create a mini internet stylee search engine device (though not necessarily a web page)in Access that will show records from a table. I will need a user to enter keywords that will search for records from a Memo fields in the same table. Not sure...