Search results

I have done this and see some things similiar but no real solutions that is why I posted this thread. Thanks for the suggestion though...

Did you resolve this issue? I'm trying to do something similar that is a Multiple Item form that shows the results of a query on the form. I then placed a text box beside it on the form and when the form populates it of course ads the text box beside each record. As your problem was when I...

I have two tables 1 that is inventory Recieved and 1 that is inventory Used. I runa query on actual inventory by subtracting used form received. This works fine. What I want to do is show this on a form or report where I can enter the actual inventory beside each record and then be able to...

Unfortunately I was not able to build something on my own therefore I found something that was an add-on for MSAccess called dbpix for $99.00 and I purchased that application add-on. I would love to find a way to have my own as I plan on possibly marketing this product and would like to have...

I need some suggestions on the simplist way to handle somethign like this. i'm thinking my way may be the difficult way and I wanted to see if anyone had any better ideas.. ANY SUGGESTIONS would be greatly appreciatted..!! I have a database that has inventory of each and ounces as well as it...

Thank You but I figured it out.. The tdatInventoryUsage properties was set to lookup instead of text therefore it did not recognize like the tdatinventoryrec was...

Here you go.. I have included two queries as well that collect the data individually but I cannot change the criterias in them cause they are used for another purpose as well.. There is three tables "tdatInventoryList" List of Inventory "tdatinventoryRec" Inventory Received...

What is the best way to get the difference between two queries? I tried Union but dont get any results. I tried Crosstab but that doesnt allow multiple queries.. Hmmm So I tried the simple query and added both queries to it and right joined by Item and added the field "Qty" from the Recieved...

I'm trying to take my "Sales" and subtract "Payroll", "InvPurch" and "nonInvPurch" from it leaving me my net Profit.

I have a report that is calculating from four fields it could be a positive number or a negative.. What is wrong with this? =Sum(nz([Sales],"0"))-nz([Payroll]+[InvPurch]+[nonInvPurch]),"0"))

TY works great. Thank You for the push along..

TY that did it.. I should have known that I just did that on something else.. How about if I have a combo and if its null then it will run the report on all employees? I know I use same method as above to run on selected employee.

Hey I have seen several people post that it is a solution but i do not see anything saying how to do it. I want to run reports from a single form and I want to have the start date and the End Date for the reports on the form they run the report from. My question is how do you have the report...

OK i have gooten my subform showing the value I want in a field call "Total" on subform "qdatPurchases subform".. How can I get that value to be shown on the main form in a field named "GrossPurchase"?

Ok so I created a Query and added it to my subform here is the sql for the query: [CODE]SELECT DISTINCTROW tdatPurchases.ChkDate, Sum(tdatPurchases.ChkAmt) AS [Sum Of ChkAmt] FROM tdatPurchases GROUP BY tdatPurchases.ChkDate HAVING (((tdatPurchases.ChkDate)>=[fdatpayemp]![WeekStart] And...

I have a form "fdatPayEmp" that has fields "WeekStart" "WeekEnd" "GrossPurchase" I have a table "tdatPurchases" that has Fields "ChkDate" "ChkAmt". I want to get the total of the ChkAmt for the reange of dates entered on form and have the value placed in "GrossPurchase" If either of the dates...

Maybe what I need to do is have a form prior to this that they would select the "weekStart" and "WeekEnd" and select Go to move the actual payroll form. On the form would be the query you are referencing or suggesting I guess is more accurate. The WeekStart and the WeekEnd on the form would be...

I am not basing it on a query so say.. I do not have a query I have built for this no.. I was trying to write the code to actually do the query itself within the VB of the form versus creating a query and adding it as a hidden part of the form to try and increase the speed of the process.

I have an error in this code which is error 3061 "To Few Paremater Expected 2" I have a table "tdatInventoryRec" which has two fields "recdate" and "Cost" On my form I have Fields "Weekstart" "WeekEnd" "GrossPurchase" I'm trying to get this code to gather all records in table...

It varies between 7 and 15 characters... I'm trying to be able to swipe the card in a reader or type it in before it executes. I thought about a timer but then that would slow down the process.. Is there an on Enter meaning when the enter key is pressed? Therefore I could set the reader or...