Search results

What could cause me to not be able to view a form I create. If I just use one table, it's fine, but if I have a bunch of tables in the form, it won't work...

i figured it out. I just had to create a new query

thanks, but how do I get new columns using my primary key? I can do it fine with a normal query but how do with union query?

Ok, I used this code to get partially what i wanted: SELECT [Type], [Date] FROM [Driver's License] Where [Date]<DATE()+30 UNION SELECT[Type], [Date] FROM [Driving Record] Where [Date]<DATE()+30 UNION SELECT [Type], [Date] FROM [Medical Record] Where [Date]<DATE()+30 UNION SELECT[Type], [Date]...

union query i just read something about a union query using SQL? is this what i need? and if so how do i write that in the sql sheet?

I have 4 tables that have 2 columns, plus the primary ID column. The 2 columns are Type and Date. In my query I'd like to combine all 4 of these tables' column's in simply 2 columns of type and date. how do i do this?

Col, thanks so much for clearing up my mistakes, but I think I may need a little more help. I did what you said about the 2 tables. Then I created a link between them, I think. I used the Relationships option. I don't know if that has anything to do with it or what, but anyway. Then I created a...

I'm going to try to explain this as best as I can. I'm completely new to Access. I'm actually an Excell person, but I believe what I'm after is easier in Access. Ok. in the first column, I have a list of names, the second column is list of departments that the names of these employees correspond...