Recent content by ShannonMarie

This did it! SELECT Employees.EmpId, Employees.EmpLastName, Employees.EmpInitial, Employees.EmpFirstName, Employees.EmpDateOfBirth, Month([EmpDateOfBirth]) AS BirthMonth FROM Employees WHERE (((Month([EmpDateOfBirth]))=[Please Enter A Month (1-12)])); Should anyone else need the same same it...

I'm trying to work it I have input the query you submitted in SQL view. I am being promted for "BirthDate" and then "Enter Month (1-12). I will fiddle with it. Thank you for you consideration and help. I will try to manipulate the results that I need. I have never worked with Northwind, but had...

I have an employees table, and a months lookup table. I am attempting to create a query to run a report according to the month selected. I have set up a parameter box in the critera of the query. It is prompting me for the month I would like, however, it is still returning all records. This is...

I have lived and learned! I created a master with the lookup in the title. Copy and past is what I did to create all of the reports necessary. I misunderstood her specifics when she asked for it. The report master has to be altered for each report but contains all possible fields needed for all...

Posting Resolve I got the links corrected and set the subdatasheet like I need it. Sorry if the post was confussing.

I need it date sensitive. The database is at a fire department. All employee responses are cummulitive. The chief recognizes the top 3 responders at the end of the year. So I need to total the number of fire calls and the number of rescue calls at the end of the year and store them. He would...

I have a db almost done and would like to add an archive table. At the end of the year I need to archive a total field and an ID field. How can I set it up that on December 31 @ approx 11:59 the record values are sent to the "Archive" table? I have the logic of what I need to do, but I'm unsure...

Just Making Sure Don't worry, my blood pressure stayed the same. I really did go look it up though.:D LOL I assummed that you were joking, however you know what they say about assumptions. I've learned that a little CYA can go along way. I'm sure there is more razzing to come. I can handle it:)

I'm Sorry! I did not mean anything by the quotes. I thought that it was something that I had not learned yet. I tried to look it up and offered what I know about toolbars. Us newcomers take a little while to learn our way around. Please don't take it personal.:o

I have a master table that is populated through a form. I have created a subform that is contained in this particular form. When I view the master table I would like to have the box with a + sign available. I would like to be able to implement the drop down row to show the values in my subform...

It is worked out The query did not require the criteria that you specified. When I removed it the data filled the report. However, it was repeating on the same page because you had the tenant information in the detail section, which will repeat until there is no more records. I moved the tenant...

Thanks! I agree that your suggestion is the easiest way. I have done that as well. I built a table with ReportID and ReportTitle. Then in the header of the report master I wrote a DLookup statement to pull the title into the heading. It is not what I would have prefered, however it is what my...

In a project that already holds 14 letters and 4 reports my partner and I have decided to add a report template should any more be needed later. (Ever heard that before?:) ) The titles are all different. The detail section has 3 repeating fields, however two reports have unique fields as well...

FYI Just letting you know that I recreated the form with the new fields. I used a tab control form for ease on the eyes and it looks good. On to the next issue.

If you care to take a look, here they are These are the tables that I have. I thought that I was ready to begin "Archive" or "History" tables. But I have had to make quite a few changes. So I am going to need to change form sources somehow. That is where I'm at currently. That is what made me...