cannot open in database form

[Sheay Mitchell]

I am currently working on a school project and I cannot open my table in
database view. I can open it in design view and i can access all other tables
and charts. Can anyone help me fix this or do i have to start all over?? I am
almost done with it.

 

[CompGeek78]

I am currently working on a school project and I cannot open my table in
database view. I can open it in design view and i can access all other tables
and charts. Can anyone help me fix this or do i have to start all over?? I am
almost done with it.

I think you mean Datasheet view, not Database view.

What happens when you open your table? More information is (almost)
always better than less.

Keven Denen

 

[Sheay Mitchell]

When I go to my navigation screen and right click to open it says the
multi-valued field cannot be used in ORDER BY clause

 

[Sheay Mitchell]

Lol yes that is what i meant. I am a total program virgin. I hate this!

 

[CompGeek78]

When I go to my navigation screen and right click to open it says  the
multi-valued field cannot be used in ORDER BY clause

That's a query not a table.

Keven Denen

 

[CompGeek78]

That's a query not a table.

Keven Denen

If you need help with the query, open it in design view, then go to
SQL view, copy the SQL query and paste into a message on this forum.

Keven

 

[Sheay Mitchell]

Ok here's my problem, i exported everything into a new database. When i go to
do the advace filter using the item number, item type, item descritpion and
on hand amount (w/criterion as <10 on hand and ascending order w/ type and
description) that message pops up. now its done it again. i dont know how to
upload the thing u asked for.

 

[John W. Vinson]

When I go to my navigation screen and right click to open it says the
multi-valued field cannot be used in ORDER BY clause

That's one of the many, many reasons lots of us HATE multivalued fields.

If you can change the sort order and/or filter of your table, DON'T sort by
the multivalue field. It makes no sense to do so anyway - sorting by a field
that has multiple values is ill-defined (does {1, 3, 6} sort before or after
{2, 4, 5}?)