Search results
-
M
is a sub query required here?
i have my query set up with calculated fields like so: PARAMETERS [First Date] DateTime, [Second Date] DateTime, [Shift] Text ( 255 ); SELECT Main.[Mth/day], Main.Shift, [Run Hrs]*[Actual Lbs/hr] AS [Gross Production - LBS], [Scrap Lbs 1]+[Scrap Lbs 2]+[Scrap Lbs 3] AS [Scrap Produced - LBS]... -
M
help with a text box
hello and good day, I have a report set up using date range perameters i can grab a quarter of data or a month or a day or a whole year worth of data. on this report i also want to display in a text box the following... =([Main]![RD / QA Samples]+[Main]![Total Scrap]+[Main]![On Hold... -
M
do i need a sub report?
Hello and good day, I just thought I was finished with this one but sure enough someone found out i had extra time and figured they could milk one last thing out of this contract. Anyone still in school feel like people just want to take advantage of you!? I sure do... Anyways the report I'm... -
M
The query cannot be completed.
Hello all, I have an excel file linked in access and a table called main I've made a query to append the excel data (Table1) to the Main table as so: INSERT INTO Main ( [Mth/Day], [DS/NS], Shift, Line, [Product Code], [Product Description], [Mat'l], Pcs, Quantity, [Total Run], [Std lbs/hr]... -
M
appending tables with a form
Hello and good morning/afternoon! I am currently in the process of redoing a production database that was originally setup in excel workbooks. What I'm currently developing is a form that interacts with my append query to add new entries which would be added to the current or "master" table... -
M
auto fill look up text box
OKOKOK I'm trying to have a text box on a form look through my product# field for an exact match ie if i type 123456 it looks for the product# 123456 and then in the text box below it i want it to put the data from the cell to the right which is my product description. basically if text1 =...