Query's result in text field
- Thread starter key
- Start date
Adrianna
Registered User.
- Local time
- Today, 09:56
- Joined
- Oct 16, 2000
- Messages
- 254
I'm not exactly sure why you would want to do that, but it is possible.
You can either create unbound test boxes in the form or report that you would like to display the results in (setting them equal to the query fields)...
Or
You could create expression fields (not sure if that's the technical name) in the query itself. So if you had 2 fields that the query adds, then just type NewField: [Field1]+[Field2]
You can either create unbound test boxes in the form or report that you would like to display the results in (setting them equal to the query fields)...
Or
You could create expression fields (not sure if that's the technical name) in the query itself. So if you had 2 fields that the query adds, then just type NewField: [Field1]+[Field2]
Hi,
I'm sorry, I did'n catch it...
Let's say I've a simple query (Select Name, Birthday From Table1)
In my form, there is a field called txtName, txtBirthday.
Now, there are 10 results from the query. How I can set the first name and birthday to this fields?
Thanx,
Key
I'm sorry, I did'n catch it...
Let's say I've a simple query (Select Name, Birthday From Table1)
In my form, there is a field called txtName, txtBirthday.
Now, there are 10 results from the query. How I can set the first name and birthday to this fields?
Thanx,
Key
Adrianna
Registered User.
- Local time
- Today, 09:56
- Joined
- Oct 16, 2000
- Messages
- 254
The query only selects the records with fields the meet the criteria that you provide.
Are you wanting to place each of the results into individual fields?
If you want to use the resulted information from your query, just base your forms or reports on the new information by setting the RECORD SOURCE to the query and not the table.
If this still doesn't answer your question....just SPELL it out. Sometime it is very difficult for members to understand what you're asking for without seeing it.
Are you wanting to place each of the results into individual fields?
If you want to use the resulted information from your query, just base your forms or reports on the new information by setting the RECORD SOURCE to the query and not the table.
If this still doesn't answer your question....just SPELL it out. Sometime it is very difficult for members to understand what you're asking for without seeing it.
Yes, you're right I want to place each of the results into individual fields. It means:
first field of the query in the first form field
second field of the quere in the second form field
....
...
It should be something like a list. (But I don't want to use a ListBox. )
first field of the query in the first form field
second field of the quere in the second form field
....
...
It should be something like a list. (But I don't want to use a ListBox. )
Adrianna
Registered User.
- Local time
- Today, 09:56
- Joined
- Oct 16, 2000
- Messages
- 254
Wow...I'm either really tired and confused, or you are trying to perform something that I just can't reason with.
Are you asking to have all of the query records presented on the same form?
If you run the form off the query you will limit the records that you see to the query fields. Each of them is held in it's own field, just on seperate pages as you navigate though.
If you want to display a "table" or "datsheet" format...that is possible.
If you're trying to assign individual fields values to query results....I would say that you're out of luck. I'm not saying that it is impossible, but I would never see the need for it....let alone care to do the loop coding to create and assign new fields.
Maybe if you explain your desired purpose or end result, someof the members here will be able to better assist you in a solution or an alternative.
Are you asking to have all of the query records presented on the same form?
If you run the form off the query you will limit the records that you see to the query fields. Each of them is held in it's own field, just on seperate pages as you navigate though.
If you want to display a "table" or "datsheet" format...that is possible.
If you're trying to assign individual fields values to query results....I would say that you're out of luck. I'm not saying that it is impossible, but I would never see the need for it....let alone care to do the loop coding to create and assign new fields.
Maybe if you explain your desired purpose or end result, someof the members here will be able to better assist you in a solution or an alternative.
