Question

Find all records in the Item table where the difference between the retail price and the wholesale cost of an item is less than $5.00. Display the item number, description, wholesale cost, and retail price in the query results. Save the query as ITL 2 Step 2 Query.

Subject: Microsoft Access 2016

Answer 1

Design Database Field

Table Tools wholserler : Database (Access 2007) - Microsoft Access Home Create External Data Database Tools Design Insert Rows Delete Rows Lookup Column View Primary Builder Test Validation Key Rules Tools Property Indexes Sheet Show/Hide Views All Tables Description tbshop 3 tbshop : Table tbshop Query tbshop Field Name iteam number item_name wholesale_cost retain_price Description tbshop Query Data Type Number Text Number Number Text Make Design of Book table I Field Properties Comoro

Filled Data

wholserler : Database (Access 2007) - Microsoft Access Home Create External Data Database Tools * Cut B New Y Selection 43c Replace Calibri 11 La Copy Save Σ Totals A ABG Spelling + More - Go To View Paste 7 B U A Advanced Y Toggle Filter Format Painter ab Filter Find Refresh All- X Delete - hos Select Views Clipboard Font Rich Text Records Sort & Filter Find All Tables * tbshop 3 tbshop : Table tbshop Query iteam_numbe item_name 11 Popcorn 12 Oil wholesale_cc 30 retain_price Description 32 it is fun 22 Pure Oil 20 tbshop Query # make sample Database here with some data

Query

wholserler : Database (Access 2007) - Microsoft Access Query Tools Design Home Create External Data Database Tools Union Pass-Through Data Definition Insert Rows insert Columns Delete Raws Delete Columns Builder Returns All Query Setup Show Tablo Totals Property Sheet Table Names Parameters Show/Hide X Pro X! View Select Make Append Update Crosstab Delete Table Results Query Type All Tables tbshop Query tbshop 3 tbshop : Table tbshop tbshop Query team number item_name wholesale cost retain_price Description Selec El Gen Make SQL query here with appropriate thing of condition Dee Det Out Του Uni Uni- Sou Sou | Rec Rec ODI Filte Orc Ma Orie Sub Link Link Sub Sub Filte Orc tbshop.retain pricel-[t item rame toshop wholesale cost tbshop retain price toshop Description tbshop Field item number Table: tbshop Sort Show: Criteria Form View Type here to search O

Query

SELECT tbshop.iteam_number, tbshop.item_name, tbshop.wholesale_cost, tbshop.retain_price, tbshop.Description
FROM tbshop
WHERE ((([tbshop].[retain_price]-[tbshop].[wholesale_cost])<5));

Output

wholserler : Database (Access 2007) - Microsoft Access Home Create External Data Database Tools * Cut B New Y Selection 43c Replace Calibri 11 La Copy - Save Σ Totals A ABG Spelling + More - Go To View Paste B 1 U A Advanced Y Toggle Filter Filter Format Painter ab Find 用 Refresh All- X Delete - hs Select - Views Clipboard Font Rich Text Records Sort & Filter Find All Tables tbshop 3 tbshop : Table I tbshop Query tbshop iteam_numbe item_name 11 Popcorn 12 Oil wholesale_cc 30 retain_price Description 32 it is fun 22 Pure Oil tbshop Query 20 * Final output

if you still have any Problem regarding this question please comment and if you like my code please appreciate me by thumbs up thank you.........