Search results for query: *

I have a table with tblPrice having fields: StartDate ProductID Price 1/1/06 1 $10 1/2/06 1 $10 1/3/06 1 $5 1/4/06 1 $10 Is it possible to query this table so the result would look like: ProductID Price MinDate MaxDate 1...

I have two tables: Table1: Product, SaleDate Table2: Product, SaleDate, Price I'd like to join the two tables on Product and the closest SaleDate. For example, Table1 has a SaleDate of 8/18/05, while Table2 has SaleDate's of 7/1/05, 8/1/05, and 9/1/05 for the same product. I'd like to match...

Just curious if there are more efficient ways of going about this. I would like to populate a combobox with a list of all the tables in the database. Function AllTables() Dim db As Database Dim tbl As TableDef Dim strTable As String Set db = CurrentDb() strTable = ""...

I have a table of data that I would like to remain untouched. From this data, I need to calculate averages disaggregated by various fields. Instead of playing with the WHERE to filter the data, I would like to use SQL to delete those records from a copy of the table. Using a temporary table...

I have a form bound to a query. When the user enters the last name, it runs an after update event that checks for duplicates in the table. It returns the records information to ensure that it really is a duplicate. If the user clicks Yes that it is a duplicate, then the event triggers the...

I have two listboxes with four buttons: <<, <, >, and >>. I'm using SQL statements INSERT and DELETE to move data from one listbox to another. The two listboxes are unbound. I've been reading some threads that use .AddNew then .Update. What's the difference between the two? Is there a...

I have two tables: tblStudentScore: StudentID, TestID, a1_01, ... , a6_20 tblBenchmark: TestID, ScorePosition, Benchmark tblStudentScore has a lot of fields that are blank because different TestID tests different things. So Test 1 can have a1_01 but Test 2 does not. I took two approaches...

I have several three tables: tblStaff: StaffID, LastName, FirstName, School, Track, Position, Active tblProgram: StaffID, Program tblGrade: StaffID, Grade I had to separate Program and Grade because each Staff can participate in multiple Program and Grade. I have 6 filters: School, Grade...

I'm trying to create an attendance database. However, instead of asking a user to find a person's name and enter the date he/she attended, I would like to create a form that asks for a date, then populates people's name, and include a checkbox. Any ideas on how to go about creating a form kind...