Search results for query: *

The structure is as follows. EmpId EmpName Bonus_payout Date

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

i need the query to include all transactions that were >=400 and not a total sum of transactions. I would also like to insert a date and have the query spit out all transactions within 48 hours of the specific date.

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.

Golom, I tried your code and it works fine but what if i wanted the part that returns true to display all days of the week except friday and saturday and the part that returns false to return all days of the week.

i have an else statement and you don't necessarily need an else statement for your if to work. IIf([tblCriterias]![FriSat]=False,(Weekday([Date]))=2,(Weekday([Date]))=3)

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

Thanks works great!

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.

SELECT tblDialerSummaryMTD.Application, tblDialerSummaryMTD.DEL, tblDialerSummaryMTD.DATE FROM tblDialerSummaryMTD WHERE (((tblDialerSummaryMTD.Application) Like "whirl") AND ((tblDialerSummaryMTD.DEL)="DEL 2" Or (tblDialerSummaryMTD.DEL)="DEL 3") AND ((tblDialerSummaryMTD.DATE) Between...

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

Thanks everyone for your replies. I finally got it working. Cheers

I have adobe Acrobat 8.0 that writes pdf's already installed. I need to automate the process of printing each report and saving it at a specific location.

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

Thanks everyone. Putting myspec in "" worked. I'm actually parsing the date time field and then converting the seconds to integer. Thanks again.

DoCmd.TransferText acImportDelim, myspec, vTableName, vPath, True It isn't taking my spec?? Even if i change the spec to a spec that doesn't exist for example: DoCmd.TransferText acImportDelim, myspec99, vTableName, vPath, True It will still import the data the exact same way. Am i not...

I tried that and it still doesn't work. The file i import from the wizard give me the correct time 69:01:00 but the file i import using docmd and using "myspec" that i saved while importing does not include any time over 24.