Can someone help me? =)

[xoxoAllyCat]

I am trying to complete this but I can only get up to 1 query and then everything erases.....


I never used Access before....thank you

Product Name	Product Number	Taxable	Amount Purchased	Purchase Price	Amount Sold	Selling Price	Revenue	Expense	Profit	Sales Tax
Pizza	XA-124-Q	No	128	$5.25	92	$10.50
Potato Chips	TN-258-Z	No	1,024	$1.79	833	$3.58
Soda	PG-909-B	Yes	512	$2.78	476	$5.56
Ice Cream	KR-762-A	No	256	$1.99	239	$3.98

Create the following select queries: 1. A listing of the Products in Name order with their Selling Price. 2. A listing of Product Numbers that are not Taxable. 3. A listing of the Products where the Amount Purchased is not greater than 500.

[June7]

Is that the only table you are working with? If so, this is not a normalized database. If not, we need to know tables in the db.

What do you mean by 'everything erases' - the query does not return any records?

Show the SQL statements of attempted queries.

Are you using the query builder?