Search results

Hello! I need help!.. I have an unbound mainform and an unbound subform(datasheet). The source of the subform is a query which is dynamic(I have many queries with diffrent columns). the subform source is change using a combo box selection. I have text boxes in my mainform... my question is how...

Thank you! I'll see what I can do.. Thank you again jdraw

Hello jdraw, Attached is a sample data. lets say my sample size is 10% of the 189 records that means 19 samples should be selected. Since there are only 10 high priority then all of them will be included in the sample, there are only 9 remaining and since there is a total of 108 medium...

Thank you jdraw... the link you suggested is not quite what I need. It gives the suggested percentage from a population depending on the desired grouping. But what I'm hoping is to get the suggested percentage of the population but the samples should have emphasis on priority. Highest priority...

Good day! I need help in creating a query: I have a table with three columns the ID(PK), Date, BatchNumber. In the BatchNumber column there are entries like HP, MP, LP. What I need is to get a random sample of 10% of the population. But random samples should have priority based on the HP...

Thank you Cronk Thank you plog Yes your right there can be multiple Email ID in tbl_transaction_processed while in tbl_Received_Email there can only be one. Kindly see attached example.

Hi - I have a query: the first one shows the number of emails received for each date SELECT tbl_rEceived_eMail.ReceivedDate, Count(tbl_rEceived_eMail.EmailID) AS EmailCount FROM tbl_rEceived_eMail GROUP BY tbl_rEceived_eMail.ReceivedDate; The second one shows the number of emails received...

Here is the code in the SQL view of the query. SELECT * FROM tbl_Sent_Email WHERE (((tbl_Sent_Email.ID) In (SELECT Top 5 ID from tbl_Sent_Email as tmp WHERE tbl_Sent_Email.UseriD and ReceivedDate=tbl_Sent_Email.ReceivedDate))); ID is an Autonumber column UserdiD is name of the Employees...

Thank you very much... CJ_London I've tried your query and its getting the top 5 Employee name for each date. I'm hoping that for each employee I will have 5 samples for each date

Hi Everyone, I am hoping someone could help me with my problem because I'm completely stuck. I've search the web but I can't find the answer. So here it goes... I have table with [EmployeeName] and [DateReceived] column what I am hoping to accomplish is to get 5 samples of each Employee for...

Now I get what you mean CJ_London.. Thank you!!

Thank you CJ_London.. How do I exactly make this update the data in table 2?

Good day!! I am hoping someone could help me out with my problem... I have two table - TABLE 1 contains letter of the alphabet and a user assigned to each letter while TABLE 2 contains company name and user assigned to each company. What I'm hoping is if I change the user2 for letter A in...

Wow!!! Thank you!! I appreciate it very much!!

i I have two queries.. What i'm hoping is to combine the result into one query but not in one column only but instead the result of the second query should be beside the first query.. The result of the second query should be added as a new column. First Query SELECT tbl_uSers.UserName...

DLOOK UP Error "The MS Office Access database engine cannot find the input table etc. Hi - I have multiple database opened I have a macro in outlook linked to ms access... I have a DLookup that looks up the name of the assigned agent based on the table vendor assignment using the sender email...

Thank you!! I will follow your suggestion!

Hi - I was browsing the Northwind database and notice that there is a dropdown in the table(Kindly see attached print screen). I've been trying to recreate it but I'm having a hard time. Can someone help me out or provide a clue as how it can be done? Thank you Jun

Thank you JHB it works this is what i did.. strHelpDeskName = DLookup("HelpDeskName", "t_job", "InStr(1,'" & strFilename & "',[Filename])")

Hi Everyone... I have to search the Filename field and return the value on HelpDeskNamefield on the Table1. The problem is the data on the Filename field contains only a portion of the value that I am searching. For example... I have 'majdatlate' that I need to search but the data on the...