Search results

have a table i am creating for a subform to calculate a price for a line total. [item] [amount] [weight] [yeild] [linetotal] *[need coverted price from a query] the converted price is in a query and i would like to load it with its selected item in a table (or form?) so i can multiply for a...

Can you group by last record or date in reports? i need a report to show an item with the last date or record that i entered the item's price. this is so i can have an updated inventory list of items with current prices. tables: item_id, item, date, price, company i was referred to this which...

Show last date items and prices I need a (group by?) query that shows my items only by the last updated price by date. Basically i need to show the last date. (MaxDate?) I keep a database for my restaurant of my food items and change their price everyday. i now have a table that archives...

I want to SUM a line total on a subform similar to a order entry database where items are totaled and the subtotal is displayed. I have tried to set it up similar to the order entry template but i cant get the subtotal. The line i tried so far is: =nz(Sum([Line Total])) any suggestions?

what are some good suggestions for learning access through books or training?

I am having a problem with the SUM function that displays my recipie amounts in a subform. Ive tried different things such as =nz(Sum([Line Total])) in the subform any suggestions?