Getting Started

Update Query
How do I fill in the boxes for the table I want to update in an update query? I can easily fill in the fields for the table to get the data from.. Thanks ... 24 Jul 2008 16:00

Spy Video Eyewear Recorder EVR130 available at http://www.gusdeluxe.info/Catalog
Eyewear Spy Video Recorder EVR130 http://www.gusdeluxe.info/Catalog/video-eyewear-recorder-evr130-p-342.html 1. Quality Polaroid Lens from brand makers. 2. 1.3 mega pixels pinhole CMOS camera for clear digital recording. 3. User friendly operation button for easy control. 4... 24 Jul 2008 14:58

Multiple reports on one
Hi all you Access gurus! I have two unrelated tables and I'd like to generate a report that shows info about both of them. For example, let's say Table 1 is about meetings with partners and has fields like PartnerID & MeetingDate. Table 2 is about customers and has fields like CustName DateFirstOrder. I'... 26 Jul 2008 20:11

IIf statement
My IIf statement is as follows: StatusOfAppointment: IIf([ArrivalTime]<[AppointmentTime],"Early", IIf([ArrivalTime]=[AppointmentTime],"On Time","Late)) I need to add a 15 minute window for the "On Time" (example appt 3:00, would be on time from 3:00-3:15). Not quite sure what I need to do. Appreciate any ... 24 Jul 2008 17:02

what 's the difference between an accdb file and an mdb file?
... 24 Jul 2008 13:56

Question about upgrading
I asked this in another group with no response after 2 days. I'm thinking about upgrading my current Office XP Developer Package to the current crop of Office Packages. I will need Access, Excel, Word, Outlook with the ability to compile an application in Access into a stand alone application. With Office XP Deve... 24 Jul 2008 20:07

Simple Search Form in Access 2007
Hi all, Have a very simple db, holds basic demo data (LName, FName,DOB,SSN, Add1,Add2, City, St,Zip, etc etc..) so the input form includes all of those fields. Now the end-users want another form that has all those fields but they want to, for example, just enter a city name and hit a SEARCH button on the form... 30 Jul 2008 16:53

count in report
I can create a count on a field in a report but is there a way to force it to only count specific names from that field. Example: the field is tool_code which has up to 50 different tool codes such as HF, HB, STFB, NCT...... and I only want the count of NCT's to show up in my report. Hope this makes sense! ... 24 Jul 2008 11:52

automatic creation of new fields from records in a separate table
Hello, I am creating a database to record details of all the computers in the school where I work, unfortunately I am relatively inexperienced with access. I have created one table for PCs with fields like processor speed, hard disk size, operating system etc. and one for software, showing program name, supp... 24 Jul 2008 10:50

Should be a simple question
Hey, I am as green to Access as you can be. I'm going through some tutorials on creating recodrs in a table and noticed something. Not sure why it occurs, but the tutorial does not mention anything about it. When I 'tab' through the fields of the first record, the record ID increments by 1. So when I hit th... 31 Jul 2008 03:09