Recent content by itechC

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.