Recent content by dwight1

Thank you for quick response. I will read through the tips.

I have a macro that i need to run daily. Is there a way I can schedule time for it to run automatically (like DTS)? Thanks for the help.

Please ignore..found the answer in group options of cross tab. Thanks

Can some body please help me format my date field to look lik Mar 08. I am using cross tab and i want the date field to be months so that i can use it as columns headings. The report should look like this: Sep 08 Oct 08 Nov 08 XXX YYY ZZZ XXX Any help is appreciated. Thanks

Thank you.

Hi, I have a single table containing metrics (fields) on the following: 1. Available working days 2. Actual Work days 3. Total Prouction 4. Average per day (Calculation: Production/actual work days) My question is can i get the calculation for Average per day. User will input Actual Work Days...

Currently i am using the following formula (from this forum) to identify the week days in a month. I have modified the formula for end date to date(). I am currently entering the Start date field as part of the query execution. Not in table and not in form. If i could get to start date that is...

I have a start date field that i input date in it. I want to automate the field by identifying the start date which is equal to the first day of month. Can anybody help? Thanks D

Here is my code. I am trying to put this for a button on acces form. The name of the query is KATE_RANDOM_BASE. Private Sub Command168_Click() Dim strsql Dim TopN Set db = CurrentDb Set qdf = db.QueryDefs("Kate_Random_Base") TopN = InputBox("How many samples?") strsql = " Select Top " &...

I was looking for the same help on MS Access database. I am trying to do audits on the auditors. I have seven different people who have completed X number of audits. I want to pick top 10 or any number depending on audit completion. I have used [auditor name]and also [month] for picking up the...

Worked perfectly. Thanks

When i drag and drop a command button it use to give me options (small screen) where i can pick my macro, query etc. Now when i drag and drop it just drops without wizard getting activated. Can anyone help? Dwight

I am trying to generate a report based on aging by using a crosstab query. Is this possible? As a work around i had made a crosstab and then a maketable query and was using that on my access report. I have client aging such as 0-30days, 30-60days and 60+days. If we do not have any client over...

Thank you for your response. PortYal, I tried your sql and it works wonderful. But you know in access i had various filters such as auditor, Date ranges. It gives me an error if i keep those filters. If i remove than it executes properly. Mainly it looks like it has a problem with "as". The...

Is there anyway i could get a random sampling out of a population of records for audit purposes? Example, If i have 100 records in a table i want 10 from the table to be picked for auditing. I would appreciate any input? Dwight