Glalsop,
By following your lead, I was able to come up with individual month of year queries showing both inspections using:
Month(AnnualInsp) = 1 AND Year(AnnualInsp) = 2004 OR Month(PLInsp) = 1 AND Year(PLInsp) = 2004
Any ideas how to make this one yearly report?
Thanks again!
I'm not quite sure that's what I need--I'm trying to run a report for the entire year so I can see each inspection necessary in each month of the year (for planning purposes). So far, by grouping in Reports, I have to run two reports, one that groups all Annual Inspections by Month and one that...
The report wizard will only let me group by one of the two date fields. By grouping on only one field, I can not get both AnnualInsp and PLInsp included in the same month and Year. Any idea how to make both columns be grouped together?
I have a table that has three columns: ProjName, AnnualInsp, PLInsp. AnnualInsp and PLInsp are dates--they are never the same date. Annual Insp is always 10 months prior to PLInsp. I would like to create a report that will tell me what Inspections are due each month. For example, If January...
The files are created from a custom tag to create mailing labels (Copyright 2000-2002 Brian Ghidinelli <brian @ vfive.com>)that I got off the Macromedia site.
I have a form that allows users to request a product (it happens to be a map). They enter their name, mailing address etc. Each day...
Great suggestion, I can do that. But, the file I am opening is named by the date and time it was created. I would like to open only the most recent file (named by date and time) Would I use CFFILE to open the file in the new template? How do I write that if the file name can not be hard...
Any help is appreciated:
This seems really simple, but I can't seem to get it (still a beginner...)
I have a link that opens an rtf file (MS Word Mailing Labels/Custom tag). I would like to run a query that updates the background database with info that the file has been opened--I only want...
I have one form containing a combo box (frmMain). The values in the combo box can be changed/added to from another form (frmContract). Currently, I have to close and reopen frmMain after I save changes in frmContract in order to make my new changes visible in the combo box on frmMain. I know...
Beginner Question - I know I'm missing a key step, but not sure what it is...
I've got two tables. The main table contains a foreign key field called PAYMENT. The second table contains a the primary key (autonumber) for each payment type, cash or check:
pkPmtType Type
1 Cash
2...
Unable to search by keyword to see if this has been answered in the past, sorry.
I have created a form where I would like to add a command button to preview a report based on some criteria entered in my form. For example, in the form, I chose a project "A" which has a primary key...
(Forgive, I am still a beginner..)
I am wanting to determine if a user's IP has accessed my site in any random time between now and the past 5 minutes. (I know cookies are the way to go for tracking, but please bear with me). I am currenly collecting the IP along with time that site was...
I am trying to ensure that a radio option is selected before the form is processed. It looks like, from the error message that I am getting, that my validation is not working. Included is the portion of my page containing the validation for the radio option. The error message I am receiving...
I have a field in an Access database called BidDate in which dates are entered in the database as a short date (example) 05/30/02. When I recall the field based on a very simple query, the format of the output looks like this 2002-05-30 00:00:00. Is there a way to modify the apperance of that...
I have inherited an Access database developed by someone else. The primary key in the main table is a number field. This field should be an autonumber field. How do I change the primary key to an autonumber field starting at number 99401? I realize that I can not simply change the field...
This is a fine mess I've gotten myself in--any advice is most appreciated. I am creating a type of library to be accessed over the web (Cold Fusion). I have a book number, a book type (of which there are 2) and the options of either "checked in" or "checked out" for each...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.