Search results for query: *

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

I am facing a similar kind of problem. I have two different tables and i want to Union those two tables. Can i do it in Crystal reports. Thanks Rishy

Thank you. That is exactly i wanted. Have a good weekend.

Thank it did definitely help. It is now able to accept signs such as () and -. But i want the DAP form field also to reflect in the following format as the cursor is on the said field or when the form is opened so that the final user would know that it is a telephone field with the format. For...

Hi, I am trying to have a field on the web pages (html) of access with an input mask of a phone number. Example xxx-xxx-xxxx or any other format on the page. I am able to do this in the table field with !\(000") "000\-0000;;# as an input mask. But how do i make the same or anyother format to...

MichaelRed, I tried my best and did web search to identify the possibility of linking powerpoint to MS.A recordsets but could not get any affirmative answer. I would appreciate if you could lead me to the path. The first option of exporting the data to powerpoint and then making a...