Search results

Hi, I'm new to this whole reporting thing, but pretty familiar with queries and forms. I would like to report off of a table, but use a form to run the report based on a date range. So I choose a start date and end date and then hit a button to open my report and display my formatted data for...

Ok, I'm completely lost. I can't figure out the best way to go about this, and I am not very familiar with Access 2007 (VBA and Forms anyways) I do have a good working knowledge of SQL. I have a bunch of questions so maybe I'll just index them cause they might be pretty random. 1.) Whats the...

Hi, I'm having trouble creating a form that has a drop down list and two entry fields. Both entry fields have a default value of NULL. Now what I am trying to do is keep the user from entering data in one of the fields when one of the values is selected from the combo box, and have both fields...

I have a form which that is bound to 1 particular table, whereby people can enter data into the text boxes, and select data from the drop down menus, and then hit a submit record button that loads those values into the table as a new record. I have three problems that I am experiencing. 1.) If...

I am trying to make a form in design view to enter data into a transactions table. I have the following set of tables with these relationships: <EquipmentTypeTable> [EquipmentTypeID] PK [EquipmentTypeName] <EquipmentTable> [EquipmentID] PK [EquipmentName] [EquipmentTypeID] FK...

I was wondering if someone could offer some help. I have the following table structure RESULTS: [Contaminant] [Date] [EmployeeID] [Value] [Rank] I need to group these values so that they have the same: Contaminant, Date, and EmployeeID. I then need to select only the lowest ranked value. If...

I have a query that takes a date value from 1 table say [AreaDate] and a day value from another table say [DaysInExcess]. It then creates a field that adds the two values to get a new value of "NewDate": Example: NewDate : [AreaDate]+[DaysInExcess] I then create another field called...

I have access 2007 which I have created a DNS to SQL server hosted somewhere on the internet. I need to create a query in access to modify the data on the server side through linked tables, and send this access file to my client to make the changes. Therefore the linked tables have to remain...

Using Access 2007. I am using append to move query data from one database to another. Database1 has a lone table (TABLE_A) with one data field Key_ID set up with unique keys and a couple fields filled with records. I am sending the query results to the table (TABLE_B1) in the Database2...