Search results

Where do I put this

I thank you for your efforts; however, that code doesn't work for me. I need a query that will generate one number (Total) that represents how many records I have from 1-Oct-12 to 30-Sep-13 (Army FY13) and will continue to do FY14 and so on. Whatever help you can give will be much...

Thanks for the reply, it really means a lot. Ok, I hope this makes sense. I have a table with a field named “SARC Notified”. That field has a date format as such: 12-Sep-13. I need to show on a report how many reports/records we had from the previous FY. Would a simple query or a cross-tab...

Perhaps you’re right; I’m really not sure what the best approach is. I’ve never had to track anything by FY before. I have created simple and cross-tab queries before, but this seems to be so much more complicated.

Hello Everyone, I have been tasked to create a DB for my unit. I have created a few DB, but I am a novice at best. I need a crosstab Query to count the number of records for each FY. The Army's FY is from Oct -Sep. I only need to show the the total number of record for the previous FY in a...

Thanks for the quick response. I am not sure how to apply you instructions. I’m OK with the most basic, but when it comes to coding, VBA :banghead: I am very green.

Greetings all, I am a newbie/novice at best and this is my first post; so, thanks in advance. I would like to change the Font and background color based on dates. -I have a text box (Training Event) on a form populated from a field (Training Dates) in a query. - I need the font...

Hello to everyone in the MS Access universe. I am less than a novice at best, but I like creating DB’s. I have created a few DB’s w/access, but nothing serious. I am more of a computer builder; however, I like creating DB’s. I am a 23 yr vet, retiring soon, and would like to learn Access and...