Recent content by hmho
-
H
Help with top two city in each State
Boblarson, What about if one city is there twice, and i want the sum of the population to be the top two -
H
Help with top two city in each State
Hello, I need help setting up query that will give me the top two city in population for each State. My table data look like this. City State Population Hartford CT 120,000 Bridgeport CT 110,000 Stamford CT 100,000 Waterbury CT... -
H
items with entry first shift but no entry second shift
I'm littel confuse on part two. Thanks -
H
items with entry first shift but no entry second shift
I,m little confuse on item two. -
H
items with entry first shift but no entry second shift
I also attached 2000 version for those who don't have 2007 version Thanks -
H
items with entry first shift but no entry second shift
Yes it is as easy as 1, 2, 3, 4, 5, 6 and there is 6 shifts. I attached sample of my data here and in the query what I'm looking for is on 08/19/09 there is no entry on serial numbe KL-123 on Sixth shift but there was entry on the previous shift (FifthShift) on same day, so in my query I want... -
H
items with entry first shift but no entry second shift
Yes it is as easy as 1,2,3,4,5,6 There are six shifts and it is number as 1 to 6. -
H
items with entry first shift but no entry second shift
Here are the fields for my query [ID], [ShiftNumber], [SalesDate], [ProdSerial] and [ProdEndTag]. I'm trying to find how to run query that will give me ProdSerial that was entered in the previous shift but not current shift in the same Date. Shift numbers are 1-5 and there are about 5 shifts... -
H
how to write dlookup whith three criateria
Ho w can I write dlookup in form with three criteria. here is my fields in the form. 1. ActDate Date 2. ActSerialNO Text 3. ActName Text 4. ActStatus Number 5. ActEndingNo Nember What I like to add the form is another field that looks up the ActEndingNo where the ActDate... -
H
How to automatically fill the rest of the fields base on first entry.
Will the same code works for date too? -
H
How to automatically fill the rest of the fields base on first entry.
Thanks a lot that workled -
H
How to automatically fill the rest of the fields base on first entry.
If I have form that enter sales data daily and there is one field base on the first entry te rest will be same, forexample when i enter the first field how can I autonaticaly fill the rest of the records based on the first entry. The example below the first field will be the same base on the... -
H
How to update data in form from pop up form
I'm not sure how to do that. Thanks -
H
How to update data in form from pop up form
I attached data sample I Have continous form [FrmDailySales] where I enter product sales and there is field name [Status] which has five different statuses. When I enter product if the status is InStorage I like to open Status form while still in the sale form and update the... -
H
Update form field I attached sample data
I Have continous form [FrmDailySales] where I enter product sales and there is field name [Status] which has five diffrents statuses. When I enter product if the status is InStorage I like to open Status form while still in the sale form and update the status to OnShelf and at the same time...