"Group By" in query

  • Thread starter Thread starter disneygoof via AccessMonster.com
  • Start date Start date
D

disneygoof via AccessMonster.com

Here is the situation...

I have two string columns that I put together to make one string.

Columns
1 E
1 D
2 D
2 E
3 E
4 E
5 E
etc E and/or D

Results after combining
1E
1D
2D
2E
etc.

Now, what I need to do is display this in a subform with all the 'XE' first
in order (1E, 2E, 3E, etc) then the 'XD' second (1D, 2D, 3D etc...). So my
subform looks something like this...

1E
2E
3E
etc..
1D
2D
3D
etc...

Problem...
When I use a query and set the "Group by" I get what I need, but I can not
enter data in the subform. There are a number of fields in the subform
cooresponding to these indicators that need filled in by the users.

Is there another way to make this happen...Thoughs...

David
 
Since Group By can consolidates multiple rows of data into a single row,
queries that use Group By are not updatable.

Try using Order By instead.
 
Never mind...I got it to work....
Here is the situation...

I have two string columns that I put together to make one string.

Columns
1 E
1 D
2 D
2 E
3 E
4 E
5 E
etc E and/or D

Results after combining
1E
1D
2D
2E
etc.

Now, what I need to do is display this in a subform with all the 'XE' first
in order (1E, 2E, 3E, etc) then the 'XD' second (1D, 2D, 3D etc...). So my
subform looks something like this...

1E
2E
3E
etc..
1D
2D
3D
etc...

Problem...
When I use a query and set the "Group by" I get what I need, but I can not
enter data in the subform. There are a number of fields in the subform
cooresponding to these indicators that need filled in by the users.

Is there another way to make this happen...Thoughs...

David
Click to expand...
 
Back
Top