Sequential Number created by a query URGENT

mercwonder

mercwonder

Registered User.
Local time
Today, 05:21
Joined
Dec 20, 2005
Messages
18
I am trying to create a sequential number field in a query. I cant use an auto number for the fact that i am combining multiple tables. Any help with this would be greatly appreciated.
 
Do you simply need this for a report or do you need a permanent relationship between the data and the number?
 
Just for a report
 
You can simply add a non-bound text box in the detail and set it's default value to 1 and then turn on the running sum option.
 
On the data tab of the text box properties.
 
one last stupid question... where do I set the default number to one. I dont see it in the property box.
 
There is one last thing I would like to learn from the Master... I am now trying to create a final count of that sequential column. In the Report Footer I have the following code in an unbound text box. =Count([Number]). "[Number]" is what I called the sequential column, but it doesn't work. Any ideas?
 
Can you simply count any other fld in the report?
 
Now you're just giving me the big head... Whoops!

exploding_head.jpg
 
Query by form PLEASE HELP

I have a form that has a bunch of unbound fields on it. I have a query that is tied to the fields of the form. The purpose is the form is a filter and when you type something in it goes through the query and then creates a report. The form is not bound to anything. Is there a way to have a list box in the form that has a list of information that people can choose multiple records from the list box and have it go through the query?
 
Last edited:
The only way that I know to do this is to build the sql statement on the fly by looping through the selcted items in the list box and use them as criteria...
 
I notice it's not going through any query. so, how would that work in my situation where all the other unbound fields are going through a query?
 
You must log in or register to reply here.

Similar threads

W
Combined Queries
Replies
17
Views
391
Ken Sheridan
Ken Sheridan
S
Incremental Sequential Numbering by Year via Calculated Field
Replies
17
Views
757
CJ_London
C
D
How do I set up sequential numbering in one field of a table for each alike value in another field? I want to have this applied in a query.
Replies
13
Views
1,269
Pat Hartman
P
109bow
Solved filter results in a query
Replies
3
Views
361
109bow
109bow
109bow
Count number of rows depending on criteria
Replies
4
Views
402
109bow
109bow

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom