Search results

Greetings JHB, Thank you for resolving my issue with my database. I had looked at the JOIN statement, but didn't understand its function. I am an amateur and have tried to research examples and parallel those examples to fit the results of what I am trying to do. Anyway, I was able to add the...

No. I cannot make PCEQUIP Union Query run without the WHERE clause. I have been sitting here for hours trying to make this work. I must be too thick headed. I have posted the file. It contains SerialNo_Scan Table with 5 serial numbers. One from each of 5 tables: Server, Monitor, Workstation...

Hello plog, In your previous post, you said "You need to build a new query using the serial table and that UNION query as sources, link them via the appropriate fields, bring down what fields you want to display and run it." Access 2000 will NOT allow me to link the union query (PCEQUIP) to...

I don't understand how to use the UNION Query as the source and link them. The serial number table has only one field - SerialNo. I created a new query for just the Serial number table. My UNION QUERY has the fields I want to display in the report. I don't understand how to link all of this...

Hello again, I did as plog suggested and created a separate table for Serial Numbers called [SERIALNO__SCAN]. My union query is called PCEQUIP. I also deleted the WHERE statements from this query. :banghead: SELECT[Workstation].UnitPart,PropertyTag,UnitSerial,Date,Technician FROM[Workstation]...

Greetings plog, This would have to be a temporary table, as these scans would be a one time thing to create the report. Can a temporary table be created and incorporated into the union query? If so, how? Thanks for your reply. r/ m0aje

Hello, I have a database that has over 20 tables in it and am using Access 2000. Unfortunately I cannot change the structure as it performs specific functions, so I am stuck with it. I have created a Union Query from these tables yaking data from 5 fields using the Serial Number entered by the...

Hello plog After doing some more research on SQL and some examples, I believe I am on the right track and also the right train. I am not sure if it could be done better or more efficiently, but it appears to be working. This is what I came up with. I did it this way with all the tables...

Thanks plog. SQL and VBA are way over my head, but will give it a try. I appreciate your help. Sorry for the long delay in my reply.

Hello Plog, Unfortunately, the 21 different tables is what I am stuck with. The way it is written makes it do certain required functions. What I am doing is linking the tables so that I can make my own reports and queries. Thereby not screwing up anything or the original setup. Such is the...

Hello, I have been trying to create a report to count equipment tested between two dates: I am using Access 2000 (old I know) and I have 21 different tables with the fields laid out the same. For the moment, I will list five of the tables: Servers, Laptops, Printers, Workstations, and...

Greetings JDraw, Thanks. I'll give this a try. I am dealing with an existing database program that was written a long time ago. It is in Access 2000. I am also a novice with Access, but do like to play around with it. Anyway, I will keep playing around with the solutions you and Mihail gave...

Hi Mihail, I tried both ways with yours and JDraws: Using a test date of 3/7/2014 the 90 day retest date results is 6/5/2014 =IIf(DateDiff("d",[Retest Date],[Test Date])<=90,[Test Date]-[Retest Date]-90,0) returns -180 days passed =IIf(DateDiff("d",[Retest Date],[Test Date])>=90,[Test...

Hello Mihail & JDraw, Well I tried both strings in my query in design view so I could change the test date to see if it worked correctly. In my design view I created Days Passed as follows. Days Passed: IIf(DateDiff("d",[Retest Date],Now())>=90,0,DateDiff("d",[Retest Date],Now()))...

Thanks Mahail. I will try it out on Monday. I appreciate your help. Best regards, m0aje

Greetings Mihail & JDraw, Many thanks for your responses. I am most grateful. I will try both of your suggestions out on Monday. You guys are the greatest. THANK YOU!

Hello, I have a report where I have equipment tested every 90 days. I have a field called TEST DATE formatted using the medium date format (07-Mar-14). I have another field called RETEST DATE where my query adds 90 days and displays the Retest date as (07-Jun-14). I have a unbound box...

Hello, I have been playing with Access 2000 & 2003. I enjoy it, but get frustrated a lot of times. I don't understand VB code. I have tried to parallel "strings" and examples with my projects. Sometimes I get lucky. I hope to learn a bit more on this site. I am most grateful for any help I...