Recent content by patriot76

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