I created a report Group By Project ID.
For each Project we have multiple Milestone Date.
Then we deifined Key Milestone Date as follows:
//Define Key Milestone Date: 14days before currentd...
Running Access 2003 on XP Home.
I have a data base. One of the fields is a date, in the format mm.dd.yyyy. The years are sprinkled around from 1970 to the present.
I have a query which...
I am about to create 2 separate databases one would handle all issue tracking and would act as a log of events for a particular client on a particular order. The second databse would only capt...
I have the following senerio.
I have 2 tables that contain the following info.
Table1
Type Parts
A 1
B 2
X 4
Table2
Type Labor
A 4
B 5
C 6
What I need is to output this.
...
hello,
I have a DB i just created and it says in brackets that it is an Access 2000 file format.
my DB works fine and will probly be used to eventually convert into an SQL DB so should i c...
Greetings Experts,
I have a small online auction business that deals in only one of inventory items. At the moment I do not have any duplicate products that I have to keep track of the qua...
In the following table: tbl_ComputerSoftware I need to be able to show all of the software we have on hand and the software currently assigned to a computer. If we uninstall some software it h...
I am joining multiple queries in a union query in sql and the data is formatting in random fashion. I then add this Format([Step 6: Final Summary].Shipmentsize,"0.00") which fixes it, but now ...
I have two tables in my Access Database. One labeled Requirements and the other labeled Analysis.
The Analyses table has multiple entries about the requirements used for that analyses (All...
Hi,
I need some help with designing my database.
Tables: UserDetail, Searchable, Message
UserDetail has a detail description of each user. Searchable table is used for the user to bloc...
When designing a query in Access, in the default view of the query design view screen, the tables are placed in the top 20% of the screen, followed the design grid (or the QBE grid), which tak...
I have 2 databases in Access 2003 with almost the same data. I've combined the tables into one and now I want to remove all the duplicates. I don't see any wizards or simple way to do this. ...
I have a Access db created in Professional 2000. Can it be run in the non pro Access?
I am doing a db and one of the tables we are following patients during in-patient stays and need to document average $/day (both PRE specific treatment and POSTspecific treatment) and same inf...
I want to set the pagesettings of a report in MS Access 2000. I found out how to change the printer with code in MS Access 2000, but now I need to change the pagesettings as well.
I build the sugguested tables. Does the relates fields automatically fill themselves?
Hi
I have a table with a subdatasheet. It looks as though I'm going to have to import records into it on an ongoing basis from Excel. I can import into the main part of the table no probl...
Dear Experts:
I have an Access file that automatically run the routine to populate the tables in another database file once I open it. There is one form, two macros and some VBA functio...
I'm starting our company's database over again from scratch and want to institute best practices this time around.
I have a two part question:
1) Is it feasible or recommended to have o...
I need the locations file of the "MSACCESS.exe" and Desktop Shortcuts in Access 2000, 2002, 2003 and 2007.
I have a table showing the realtionship between rainfall and absolute bearings. I want to modify this into a table showing the relationship between average rainfall between a range of bearings...
I have an access 2003 table that lists unique Sites. There is one row for each Year a site was visited, and columns showing number of Visits made that year, and number of Points surveyed that...
I have created an access database with many forms and multiple tables. I need an enduser to be able to enter information on the form which will populate into different tables.
I would like to build an array consisting of unique items from a specific field in a table. For example, the table below consists of 12 records, with 3 instances each of the number 6, 7 and 8...
experts, I have Access 2007 and need to have easy access to a form from the menu or some icon somewhere. How do I do this?
Thank you
