Search results

"average problem" grnzbra Plug the new Sql statement in with the correction and it works great. Thank you so much!:) Patriot76

"average problem This is the SQL statement, if I move the brackets in the last enter it still doesn't work. SELECT MovementF.Description, MovementF.ITEM, MovementF.SLOT, MovementF.[AVG-WK] FROM MovementF WHERE (((MovementF.SLOT) Between [Enter Begin Loc] And [Enter End Loc]) AND...

"average" issue grnzbra I took the quotes out, but it still returns all records that are exactly 10? did not work. patriot76

In my query I ask for Average wk movement and I put in for criteria [enter,"<"]. When I run the query a window pops up asking for a figure. For example I will put a 10. This should return me all the records that have less than 10. The query only returns the records that are exactly 10. What I'm...

Table Banana I records will be stored, these records are slot replenishment. I'll take alook at the Northwind database. Thank you Patriot76

Anyone can direct me to place the following fields into different tables. I currently import all this info from an Excel spreadsheet. Here are the fields: Record No., datarange, picker-nbr, picker-name, tt-picker-piece, cust-pieces, invc-pieces, invc-date, group, load, batch, pieces, item...

Anyone can direct me to place the following fields into different tables. I currently import all this info from an Excel spreadsheet. Here are the fields: Record No., datarange, picker-nbr, picker-name, tt-picker-piece, cust-pieces, invc-pieces, invc-date, group, load, batch, pieces, item...

Parameter query Bill Works great! Thanks much patriot76 :)

Hi I want the user to put in value in the pop up box, but I can't get the inequality to work. The box says Enter < Wky Qty. Example if I enter a 10 the query only return data that only has 10 not all the data less than 10? I want to show data that is less than or greater than.

I've always struggled which fields go where in normalization process. The Doc Man Thank you for the insight, I'll try using it.

The Doc man Useful information, I've always struggled which fields go where in normalization process. I'll work on it some more. I import several hundred records per day from Excel, so it is not a small DB. Thank You

aTTACHED FILE Can't unzip the file for some reason?

date Not sure what you mean.

I have a table with date/time format column that I import for Excel. There can be numerous date/time stamps for each day. The question is how can I count the total number of different days that a person has worked or done a certain task?

Stuck on a table I make several differnet tables, but I can get the data to from my import table to append these other tables with the data. The tables are as folloew tblEmpl(EmplNum,username,palletID); tblPickSlot(PickSlot,PalletID,ProductCode); tblReason(RRID, ReasonifReturned)...

Importing FoFa The following is my fields that are imported from Excel. "Batch #", "Pallet ID" "Pick Slot", "Product Code", "Description", "Reserve Slot", "Qty Requested", "Qty replenished", "Return Qty", "Return slot", "Reason if returned", "user name", and "Date/Time". Redundant data are...

Hello That I think is over my head. Help :confused: Thanks

Hi My question is: how do I set up the table to minimize redundant data. I have several fields that match the column headings in Excel, so the data can be imported, but fields like user name, pick slot, batch # all get redundant every time I import. My file is getting unnecessarily large. I...

date/time I run the below query, but I only get the individual day listed in one column and the other column where the earliest time suppose to be is blank (no return data) Help SELECT Min([tblstocker].[date]/[time]) AS EarliestLogon, Format([date/time],"mm/dd/yyyy") AS Expr1 FROM tblstocker...

date/time I've tried both ways, not sure what Im doing wrong. My table is: tblstocker fields are: username, date/time, qty replenish Does your statement get typed into the field heading of a query grid or does it go into the criteria area of the Date/time field? Thank you