Search results

I need to right a query that list items with matching fields. So I have a database that list a bunch of colors. The database looks likes this: ID Color 1 Black 2 Red And then another table list a bunch of product like this: ID Product Color 1 Tee- Shirt Red 2...

I'm at my wits end tryting to figure out how to get this to work. I am trying to build an access database that looks at an outside csv file. The CSV file gets updated by an out side piece of software and the data in this tab;e looks like this: SKU | 7-25-2010 | 7-26-2010 | 7-27-2010|...

Ok this is what i got i ahve a database with 5 fields. ID, Product, description, SRP, SELLING price. Really super simple. Then i Have one unbound form that has 10 combo boxes all labeld product 1-10 and looking up the Product and ID from the table above. I want to put a button at the bottum...

A list box that displays all the records for a particular student. There is a subform on the page as well that has detailed information. The List box source is: SELECT [Record Review].[Record Review ID], [Record Review].[Record Review Item] FROM [Record Review] WHERE [Record Review].[Student...

I have created 2 tables (Meeting & Tasks) in the meeting table i have a record called Meeting tasks that references the id of the Tasks table. I want to create a button that will create a new Task record in a new form and that it will be assigned to the current meeting. Anyone got any ideas...

Hey guys i need some help i am almost finished with a datbase but can't seem to get the filter to work. Here is the deal I have 2 tables: First table is Called "IEPMeetings" and the second is called "Tasks" Each table has an ID field that coresponds to the table, such as "MeetingID" and...

I am having problems with a Form. Let me xplain what i have going on. I have 2 Tables One is called tasks and one is called meetings. I have a fiels in my meetings table called tasks which is a lookup to the task ID in the task table. I have it set for multiple values as i will have many...

I have a contact for For paents everything works except for the Go to drop down. Here is the row source for the drop down: SELECT [Parent ID], [Parents Name], [E-mail Address] FROM Parents WHERE [Parent ID]<>Nz(Form![ID],0) ORDER BY [Parents Name]; I have included 2 pictures of the macro...

I need to creat a global Name Query. I have 4 Tables. Each table has a Unique Name and a name Field, Such as: Table: Parents Field: Parents name Table: Students Field: Student Names I need to Create a Query That just has one Field Call Name. And i need it to pull all the names from the...

I am fairly new but i've been poking around quite a bit. I have a very simple database with 3 tables. I have one Primary table that has one to one relationships with feild in the other tables. I want to run a query that will show just the recodrs from a particular month. i formated the date...