Search results

I have a few hairs left to pull out, but I like the new Homer Simpson look. Could someone please help me out with this? I am kind of new to Access, but anxious to learn. I have a Like criteria that ask for the user to input a building name (i.e. Memphis), and it works great. A few people...

Thanks I appreciate the help! I will try something very similiar to this. I have successfully tried and will probably end up using appending tables! This seems to work well for now.

Hey folks, While working the night shift my company expects me to stay awake and develop a simple database for filtering data, but I have now achieved a brain block. I have a list of data that I need to search through and select only the numbers needed. For example, I need to filter and...

I am trying to create a database for an inventory that is continuously changing. I have created 12 tables that contain the inventory for each specific location. I would like to create a seperate spare parts inventory that would keep only the spare parts that have not been installed. The...

I am using the code: SELECT a.[Unload Device], a.[Scanner Position], a.[Serial #], a.[Model], a.[Tested By], a.[Test Date] FROM [Unload Inventory] AS a WHERE (((a.[Test Date])=(Select Max([Test Date]) from [Unload Inventory] where [Unload Device]=a.[Unload Device]))) ORDER BY a.[Unload Device]...

Query Thanks everyone for your help. I have used the infrmation you gave me to branch out and use it for several other applications I am currently working on. As a beginner this is the information that allows you to focus your thoughts and build new ways to do other features using slightly...

Thanks Thank for your help. I will try this!

Query I think I understand what you are speaking of. Just to make sure , when you say group I should click the totals feature. Then in the criteria tab type Max(Date). Is this correct?

What I am doing is creating a database to keep track of our scanner inventory from 10 different conveyor lines with 10 different scanner positions. We change out a few scanners on each of these lines with new ones weekly. I have developed a table for each conveyor line, with a form pointing...