Search results

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

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

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 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?

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

Hello My last question was answered, how to extract a date/time range. What I need now is to take it one step further. I need to extract the earliest time logged for any given day. Example: 01/17/2005 0625 am 01/18/2005 0615 am 01/18/2005 0622 am...

How, in a query can pull out a range of time values. I have data being inported that show activity in chronology order and what to pull out certain time ranges Date/Time format and data example: Field name: Date/Time Data: 01/02/2005 06:00 am