Search results for query: *

Hello, I am looking to write a query that would give me the top 5 salaries each month within the past year. Does anyone have any ideas on how to do this. Thanks

Hello, I am trying to create an sql statement that will produce a list of all clients that have made two transactions >=$400 within 48 hours. I believe I need to implement a sub query but not sure on the syntax.

Hey, I was wondering if anyone can tell why my iif statement isn't working. I am trying to pull a report based on monday threw thursday and if the user clicks on include friday and saturday in my form it will include the whole week. IIf([tblCriterias]![FriSat]=True,(Weekday([Date]))>=2 And...

Hello, I have a report with monthly trends being displayed in the [reporting month] footer.I am also calculating a grand total in the report footer. In the report footer i would like to calculate the average of only the LAST 3 months. How would i go about doing this when i am displaying more...

hello, I would like to create a query that will give me results for current day (example may 7) and also every 7 th of the month previous. Much appreciated. Frank

Hello, I have a table with a date time field which records the time of a sale. i would like to group my report by 15 minute intervals so i can display what 15 time interval we had the most sales. Appreciate the help.

Hello, I need to set a between date criteria in my query by referencing the value in a table i have call tblCriterias. I am currently using Between [tblCriterias]![MonthlyTrendStart] And [tblCriterias]![MonthlyTrendEnd]. This isn't working. I tried entering the # in my table but that didn't...

Hello, I would like to automate the process of exporting my Microsoft access reports to PDF format and have the file saved in a specific location. I over 30 reports so its taking some time to print each one as a pdf and save the file. Any help would be appreciated. Thanks

HI all, I am trying to get the sum of a column using the sumif formula. This is the formula i am using: =SUMIF(Sheet2!B4:B34,Sheet1!<B4,Sheet2!D4:D34). i want to get the sum of the col if the date in col b is less then July 7, 2007. I keep getting errors in my formula and if i use brackets i...

Hi all! I'm trying to import a csv file that is comma dilimited. My csv file has a time column which some rows go over 24 hours. Now if i import the file using the import wizard i get no problems. When i try to automate it using the docmd, the rows that have the time over 24 do not get...

I would like to email the content on a form using windows default email (outlook). Any ideas?

Hi all and thanks for taking the time to respond. I want to create a function that will get the url of the page the user is visiting. The reason for this is i want to implement a "Tell a friend" button. So the user would be able to click the tell a friend button and get a page with a form and in...

Hi all, I need to format a phone number that i'm displaying on my flex grid with the standard ###-###-#### format. I know that there is a control in vb that formats for you but i can't find it. Does anyone know where i can get it or an easier way of doing this. Thanks

Hi all, Does anyone know how i can refresh a page manually???

Hi all, I need to load a list button from a table in mysql database that i have. The table consists of 14000 cities which i need to put in a drop down list. Does anyone have any ideas...i need to pull this off asap. Thanks in advance.Tek-tips rules.

How do i go about importing an access database table. The table has about 300 000 records in it. What would be the simplest way of importing this data to mysql. Thanks in advance

Hi all, I'm displaying data from a database, something like a yellow pages. I need to display 10 records per page. How do go about displaying 10 records per page if my search returns 100 records. Thanks

Hi all, I would like to import data from a text file into my access database using vba. I have alot of text files to import so i would like to automate it. Any ideas how to go about doing this. The data is sererated by commas.

Hi all, I'm trying to update my datagrid in real time as i'm typing in my text boxes. I know i have to put the code in the keypress event. Does anyone have any idea how to do this.

Hi all, In my vb project i would like to export an access report to snapshot viewer.