Search results

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

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

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

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

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

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

I have form where the field [ProdNumber] is unique and no duplicate. How can I have warning that will tell who is entering the data when they try to enter duplicate record. Thanks

I have table for daily data entry and it has these fields [ID],[ReportDate][ProdNumber],[SerialNumber], [Status] and [EndingNumber] and the table name is [DailyReports]. What I like to have is query that will give me all products that had [EndingNumber] the day before where the [Status]=1 but...

I have main form and subform. The subform will have 10 to 15 items how can I have row count on subform for display only. 1. 2. 3. 4. and so on Thanks

I attached the data file. I have form for data entry to table and it is continuous form and every day we enter about 60 items, what I like to do is enter all the data and then have the option to save yes or no "Do you want to save yes or no". Right now when I enter information to each field it...

I have table that has these fields [ID],[SalesDate],[ProdNumber],[SerialNumber],[EndingNumber] Each product has barcode number and there are two kinds of barcode one with 8 (12345678) digits and one with 9 (123456789) digits what I like to do is scan each product by barcode reader which will...

I have barcode reader that I use as data entry and we have two different barcodes one has 8 digits and the other has 9 digits. I set up form where I scan items and it puts in the table as 12345678 or if it is 9 digits as 123456789. whit these numbers I like to change as follows. 8 digits =...

I have form bas on Table that has these fields [ID] [Salesdate] [SerailNumber] [BookNumber] [EndingNumber] and the table name is TblSales. How do I code for a form that will show me all [SerialNumber] where there was [EndingNumber] on the perivious date but there is no EndingNumber entered on...

Hello, I have form where beforeupdate I have the following codes for preventing duplicate report date data entry, but i want to add one more code in case someone skips daily report to give them warning pop up message telling them they are skipping report date and if it is OK let them proceed if...

Monthly report subtotal weekly I have report that I want to group monthly and then weekly where the week starts beginning of each month. For example for the month of June I want to subtotal in the following 1st-7th 8th-14th 15th-21 22-28 29-30 And the next month the same way. Is this possible...

Hi I attached here my data where I'm having problem with dlookup sometimes I'm getting the previous day's number and some times I'm getting nothing. Please help

Hello How can I sum the details in the sub form to the main form

I have table name TbleDailySales and Form name FrmSalesEntry and i have these fields in the table [ReportDate], [EndingStick], [Amount] Reportdate is Key and date and EndingStick in number and amount is currency. In the form I'm using Dlookup to bring the previous EndingStick and here is the...

I have form that I enter daily sales and I have field where I have dlookup to bring the previous day's data and here are the codes. Table name is [TblDailySales] Form name [FrmDailySales] =Dlookup("[Stick]","TblDailySales","[ReportDate]=[ReportDate]-1") The problem is sometimes I'm getting the...

Hello, I have table name TbleProductSales and it has these fields [IDNumber], [SerialNumber], [EndingNumber] and [SaleDate]. What I like to do is prevent duplicate SerialNumber whitin each day's SaleDate for example SerialNumber 123 can have ending number only once a day. IDNumber is the key...