Filter Value in Table Field (If $, then Value) (1 Viewer)

glowinggal · Nov 18, 2018

Good morning all!! I am just learning Access and have this in a lab and wasn't sure how to arrive at requested task.

"In Datasheet view, use a filter to assign the value Normal to all records where the Amount is less than $400.00. Assign the value High to all other orders."

Field Priority in the table is a Combo Box, Value List (1) High, (2) Normal, (3) Low

I know it's probably something simple and am overthinking. :banghead:

theDBguy · Nov 18, 2018

Hi,

How many records are in the table? Is your instructor expecting you to manually make the assignments? For example, in the Amount column, you can click on the dropdown arrow and select Less Than and then enter 400 to filter the table. Then, in the Value column, you'll have to select Normal for all the records, one at a time, to assign them.

Is this what you mean?

glowinggal · Nov 18, 2018

It's only 14 records. Not sure what they want b/c it says "filter" so wondered the same if I was overthinking it lol. I was wondering if she wanted a rule/macro or something since it says "use a filter to assign"

theDBguy · Nov 18, 2018

Yeah, in datasheet view (table or query), you can click on the dropdown arrow (right side of the column header/name) to sort or filter the data. If the homework is to auto-assign a value for certain records based on a criteria, then maybe the intent is for you to create an UPDATE query.

glowinggal · Nov 18, 2018

thanks! off to look at it some more and see what I come up with per your suggestion! Will post back!

theDBguy · Nov 22, 2018

Hope it works. Good luck!

Filter Value in Table Field (If $, then Value) (1 Viewer)

glowinggal

New member

Attachments

theDBguy

I’m here to help

glowinggal

New member

Attachments

theDBguy

I’m here to help

glowinggal

New member

theDBguy

I’m here to help

Similar threads

Users who are viewing this thread