Search results

Im doing an event where time calculation is needed. Right now I'm using Datediff to find out the difference in time in SECONDS. I need to round down to the more precise Millisecond but the help file only shows the former available. Need some help to make it be able to calculate in milliseconds...

Im doing a race event with access and want to create a result tabulation form where all i enter is the start time and end time. How can i get the program to come up with the time taken? Is that done in a query? i.e. End time minus Start time 20 min 10 sec 20ms - 10min 0sec 30ms = ?? Help...

I can only do Sum(Price) under my category group, but what i want is a Sum(price) at the bottom of the page in my report. I cant do it just be dragging it under page footer. So is this even possible in the first place?

My current report has a Category header and footer. The cat footer shows the accumulated amount of items eg. Sum([Balance]*[Price]) There's two things i need help in. 1) Move the cat footer to page footer so it shows the sum of the whole page's items. It gave me an error when i shifted it whole...

Is there a way for my inventory form to show what page that item is on a report? I tried directly adding a text box with control source directing to the report's "Page" [Page] of [Pages], but i guess that's not the way it works?

hi people.. I have a database of a few thousand items under a hundred categories. Is there a way i can create the report to come out with a pre-defined category list? eg. cat P followed by cat X, then cat A, then cat 3.. rather than just ascending or descending?

In my inventory report, i made a field called Balance. It shows the remaining units from a query ( SumOfUnitsReceived - SumOfUnitsSold) It shows them even if Balance is zero. The most I could do was to tweak the query such that UnitsReceived criteria >0. I need something like : Only show entry...

I have an inventory checklist being done up now. After the item info has been typed in (price, part number.. ), below i put in the transaction info (4 sold today, 2 recieved yesterday..) I need by report to show the total number of all stocks and how much they are all worth. The report does...

im creating an inventory so that anyone who comes can find a list of what's in the store. Im trying to do the following but still end up lost. eg1. from the switchboard, under product catagories . there are a hundred cats so he chooses from a dropdown list. then from there it's queried and...

im creating a report from a table of products. the products have catagories, so theres a seperate table for that. in the catagory table theres CatagoryID autonumber and a CatagoryName text. So when creating a product i can use the drop menu to select the catagory In the report my problem comes...