Search results

Thanks Jdraw. I will give it a try. Best regards, //m0aje//

Hello Minty, I agree with you that everything should have been put into one table. However, this is an old database that goes back to the year 2000 and it was done trial and error. It has progressed on from there so I am working with the circumstances that exist now as I cannot change the...

Hello Simon, Thank you very much for your reply. Would this code allow for searching a serial number from all the tables in the database? I have more than just the 4 tables in the database. Again, thanks for your reply. I really appreciate it. //m0aje//

Thanks for your reply. I appreciate it.

Hello, I am using the following union query to search serial numbers from 5 different tables. SELECT[WORKSTATION].UnitModel,UnitPart,UnitSerial,PONum FROM[WORKSTATION] WHERE(((WORKSTATION].UnitSerial)=[Enter Serial No.])) UNION ALL SELECT[LAPTOP].UnitModel,UnitPart,UnitSerial,PONum...

Hello, Thank you for your reply. The "form query last name" form was created from a simple query. It is accesses from the Switchboard Manager. When I select "Search For Record" from the Switchboard Manager, a prompt will ask for the 'Last Name' then the First Name. It will search the...

Hello, I am using Access 2003 I have a database I have created for a church cemetery. It has approximately 425 records. I created a form that I can query a last name and bring up the form if the record exists. If no record is found, a MSG box will say it doesn't exist. I added some code to...

Hello Serge, Thank you for your reply. I apologize for the delay. For some reason there was no msg that you replied in my email. Anyway...... THANK YOU!!!!!!! THIS WORKS. I have been messing with this for a few weeks on my own and could not get the syntax right. This will work great for my...

Hello RanMan256, Thank you for your reply. I appreciate the code you provided, but I don't fully understand where or how I would insert it and make it work with my application. I am using Access 2003 and I have very limited knowledge of VBA and SQL code. I am like a blind squirrel.... once...

Thanks for your reply Minty: I tried the following in CONTROL in the AGE field. =IIf([DeathDate] Is Null,"Living",(DateDiff("m",[BirthDate],[DeathDate])\12 & " year(s) and " & DateDiff("m",[BirthDate],[DeathDate]) Mod 12 & " month(s)")) I got this to work, however I have some records that...

Hello, I have created a cemetery database in Access 2003. I have three fields; BirthDate, DeathDate, and Age. Under properties in the AGE field in CONTROL I am using the following syntax: =IIf([DeathDate],(DateDiff("m",[BirthDate],[DeathDate])\12 & " years and " &...

Hello, I am trying to enhance a cemetery database I created in Access 2003. All of the graves are in one table. The queries work fine. However, I have created 4 Buttons to expand on the record. The four buttons go to 4 different sub directories. When the record is found, the user can click one...

Hello plog, I think I got everything working properly. I have one more small issue with the dates I am going to try to resolve myself. But for now I am extremely grateful for your assistance. You folks up here are the greatest and I appreciate all the help I can get.THANK YOU AGAIN !:D:D:D:D:D

Hello plog, I created the MasterQuery as you suggested and used the DateDiff code you provided and SUCCESS! THANKYOU! However, as the records in this database are old, it pulled up stuff from 2002. Is there a way to keep the results within 2013 and this year?? Also for adding the AND Shippedto...

Hello again plog, Well, that is pretty much the full SQL. There is additional equipment such as SWITCHES, MONITORS, MEDIA CONVERTERS, etc... All of those tables have other fields besides the part numbers, serial numbers, etc..., but, with respect to those fields, the tables are structured...

Hello plog, Thank you for your reply. For a MasterQuery, are you suggesting something like this: SELECT UnitPart,UnitSerial,TestDate,Technician FROM [LAPTOP] UNION ALL SELECT UnitPart,UnitSerial,TestDate,Technician FROM [WORKSTATION] UNION ALL SELECT UnitPart,UnitSerial,TestDate,Technician...

Hello, I am trying to pull records for computer equipment that the test date has exceeded 90 days. I am trying to modify a union query to make this work. I have several tables that I have to search. I cannot change the structure so I have adapted to it. This is the code I am trying to modify.I...

Hello Ken, Thanks for your reply. Not sure if you were referring that I should use DCOUNT vice COUNT(*). Anyway, I tired the following: SELECT SUM(Records) FROM ( SELECT "Laptops Tested" AS PCEQUIP, Count(*) AS RECORDS FROM [LAPTOPS] WHERE (((Date)Between [Enter Start Date] AND [Enter End...

Hello, I am using the following UNION QUERY to total up equipment tested for a report. SELECT "Laptops Tested" AS PCEQUIP, Count(*) AS RECORDS FROM [LAPTOPS] WHERE (((Date)Between [Enter Start Date] AND [Enter End Date])); UNION SELECT "Workstations Tested" AS PCEQUIP, Count(*) AS RECORDS...

Greetings again plog, I appreciate your patience. As I said before, I am an amateur at this. I am not sure why it worked for you and not me. For whatever reason, I could not make it work in the manner you suggested. Over time I got really frustrated with it. Again, I thank you for trying to...