Summary: I created a database from data I inherited from another person. The data has three tables ' Mother, Child, Follow up Child data. The data on follow up...
Summary: Im trying to implement a function in Access 2003 to allow the application to find a given field from a give another field in the same record. e.g. I h...
Summary: Hi, I'm designin sort of asset manager software and i'm already stuck with some SQL-querys... :) Tables don't have all the fields yet, because it's ju...
Summary: I need help making tables with either mySQL or winSQL. Create the -Pilot- table with the following fields, PilotID (integer sequence) and Primary Key...
Summary: have to summarise something in ms-access. am using access 2003. i have a query with the following fields. (this query has some other fields also. this...
Summary: ery expression? Using Access 2003... I have a query setup to only output the following expression when certain conditions are met (so that only the wa...
Summary: I am trying to create a search function in a form. it wil search the specified table and return the results in a subform on the same form. This is the...
Summary: Our agency maintains a Paradox 9 security database. Within this database is table (with 1311 records) which contains demographic data for all employe...
Summary: I am reporting daily performance data. I wish to compare weekday (M-F) data with Weekend (S,S) data. The actual date is called "TestDate". I create...
Summary: Message: I'm trying to do a program in Access to my husband clinic, I need first to check if the patient is male or female then if it is male I need ...
Summary: I have in a Table1 the Business Name Address and phone number and i Table2 i have only a phone number I want to delete into the table1 which is in the...
Summary: I have created an MS Access db, 2 of the fields relate to time...StartTime & EndTime. From this I have created a query to display the attendance time...
Summary: Is there a shortcut key in MS Access 2000 for adding a new record? I haven't found one, and when I want to add new record in form view, I have to clic...
Summary: There are several ways to do this, depending of course, of what version of Access you're running. To see several options, enter "secure database" in ...
Summary: Ok here is my problem. It’s kinda silly but here goes. . . . I created a database in access to track my ever-growing DVD collection. I have a form t...
Summary: Sorry, I was'nt very clear. I have set up a macro with an import specification for a text file which has records for 4 fields, into a table. For ex...
Summary: I want to use macro in access to create a new column in several different tables. These columns shall consist of a prefix that I choose, typically "PM...
Summary: I have a problem with margins of reports in Access 2003.I have make an application in Access 2003 with a lot of reports.For all reports in OnOpen even...
Summary: I need to perfrom calculation at the lowest level in a product hierarchy and then roll up the result without recalculating at higher levels. How this ...
Summary: Need help with formula: Example: If you have a product that is priced by the hundreds, I would put the letter "M" in cell next to the price and a f...
Summary: I am building a database in Access 2007. 2 of my forms are "Salesman" and "Client". 1 salesman has many clients but 1 client can only have one sale...
Summary: I have a small database in Access 2002. In a new record I'd like to be able to type the name of the company and then have all the contact info appear...