Search results

Finally!!! finally!!! I figured out the date criterias i needed!!! Thanks to you!! Like what i've mentioned, i always use the last day of the month to generate my report. Say, today is "31-Jul-06"... 1. how to filter records during the same period last year = Year([Enter: Current Month])-1...

The BE of my db is located at my PC. FE are then accessed by 3 of my staff on a shared folder. To check how high the security of my dbase is, i opened the folder where the BE lies on one of the user's workstation and tried to delete it. Can't believe IT WAS DELETED!!! Why??? It should have been...

I can't figure out how to further explain what i needed to do. I hope the attached file could solve my issue. Thanks for your time! Sheila

Hi Bob! Thanks for your reply. Hope this could give you a clear picture of my query. I also attached a sample report. SELECT [UsysSources - Current Month Production_Crosstab].[ISE / MP], [UsysSources - Current Month Production_Crosstab].[Total Of Bus Type], [UsysSources - Previous...

Raskew, I tried to base my other date criteria from what you have posted. Forgive my ignorance, but i just can't get the other criteria works.. Whenever a user wants to generate a Production Report of Insurance Renewals for a specific month, the user is required to key in the last day of that...

Raskew, It works perfectly! Thank you!!! :-) Sheila

Thanks for your post OpnSeason!!! Such is a very useful tool. The code works on my db, except that.... (forgive my ignorance for i am an access novice) i don't know why the inactivity shutdown occurs immediately as soon as i open the form. I did exactly what you've stated on your post: I open...

Good day! I have a query that filters records which production starts at the first day of the year and ends a day prior to the current month. I used this criteria: Between [Enter: First day of the year] And [Enter: Date prior to current month] I need a criteria which will filter records...

Good day! I've created a dbase for insurance renewal business transaction. I used a primary field named "Policy Number" on one table. Policy numbers are alphanumeric and structure depends on the insurance company who carries such. Example of Policy Number/s: TSI-PCP-100000 PCTSIY0600000...

Increment alphanumeric field I have the same concern on my dbase. I created a field named "Policy Number" in one table. The idea is the same as that of Ramona's, but the problem is, the field type is ALPHANUMERIC. (Example: TSI-PCA-05-1000111RA). Would it be possible to automatically...