Search results
-
B
a frenzy of numbers
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...- BarnetBoy
- Thread
- Replies: 1
- Forum: Modules & VBA
-
B
DCount Problem
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... -
B
DCount Syntax
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 <="... -
B
Auto number in a query (having trouble with dcount)
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... -
B
Auto number in a query
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... -
B
I wan't a field to show A,B orC based on other field values matching.
: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... -
B
can I create a mini search engine in access
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...