Search results
-
A
Problem counting and storing records
I use a query based on the Projects table. Using the "Proj_End" field and" Proj_Length" The "Proj_Length" field is based on the difference of "Proj_Start" and "Proj_End" In the query I have two fields I add; Proj_Days_Expired: DateDiff("d",[Proj_Start],Now()) Proj_Completed... -
A
Automatically emailing a Access report once a week
Thanks for that information, the next question is though, how do I create the macro to email the report? -
A
Problem counting and storing records
I have this working in a query now, and it is calculated when the query is run, and a field added at runtime, but the problem lies when I come to use that field in another form, Access doesn't recognise it as a valid feild. -
A
Automatically emailing a Access report once a week
Hi Guys. I have come up with an Access database with help from a few guys on here, which contains a couple of tables, and lots of reports etc. I can easily email the reports out using the command buttons placed on a form in my database, but I was wondering if it is possible to automatically... -
A
Problem counting and storing records
Ok, added a primary ID field to both tables and all is working well and as expected. All I need now is to calculate the following: In Projects Table I have two date fields. "Start Date" and "End Date" I need to count the days between them, and then work out how far through the project I am... -
A
Problem counting and storing records
The Project Name field is unique so is acting as the Project ID. I have now managed to get the count values for the various fields using a Cross Tab query which is where I think I was going wrong. I now just need to calculate the % for each total which shouldn't be too hard -
A
Problem counting and storing records
OK here goes: Table: Projects contains; Project Name Project description Project Manager Table: Components contains: Comp ID Comp Name Comp Description Project Name Phase 1 Status (Finished, reviewed, Executing) Phase 2 Status (Finished, reviewed, Executing) Phase 3 Status (Finished... -
A
Problem counting and storing records
I have two tables in Access. One table is of Projects, and the other table, is of components that belong to each project. The COMPONENTS table has a field Proj_ID which takes uses a drop down to the PROJECTS table as a lookup for the field. I would like to write a query that will return the...