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...

last date query i need for it to be updateable. i change the prices every day as the invoices come in. can i group by last date in a report? can i group by last record. that would work too. thanks for response

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...

ah, ok then i guess i'll follow the protocall. i saw only 3 names on the forum so i thought i'd give it a shot. didnt mean to bother you

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?