Search results

Thank you everyone for all the help!

Doc Man, It does clarify it much better, thank you. One more question, what would be the best way to put this into a query?

How would I find if 2 dates fall between 2 other dates? For example: This would evaluate to True StartDate 02/08/2007 EndDate 02/11/2007 StartTestDate 02/09/2007 EndTestDate 02/10/2007 This would also evaluate to true StartDate 02/08/2007 EndDate 02/11/2007 StartTestDate 02/07/2007...

Thanks for the info, I didn't know that .Value was the default. Your right I would want to use Value. Thanks Pat!

Just in case someone wanted to know this is what I did to add the variable into the string Me("ph_cat" & phCatNum).Text

Never mind I figured it out after hours and hours of staring at the screen!

How would I insert a variable into this string? Me.ph_cat & phCatNum.Text = Test Thanks

Thanks Pat that was exactly what I needed! It took 5 query's todo the job and the main query takes less then a few sec's to run to my surprise, awesome! I was beginning to think I was going to have a serious head banging problem on my hands since I spent most of the weekend trying to get this...

Thanks for trying, I guess i will figure it out a different way..

Ok, I have a table now that just contains the "hotfixes" and I created a query that displays the users and their software. I used that query as the one side of an unmatched query and on the other I used the "hotfixes" table. Its not working! I am only seeing everything that is equal in both...

For some reason the post is only showing 2 replies

Hi Pat, Thank you for the reply. The first table is the hardware table, the user does not really matter. The user is only listed because that is who sits at the computer. The one query that I run gives me a list of all the software that is installed on all the computers and is filtered to...

I have 2 tables tblMasterUsers and tblMasterSoftware the tables are joined, one 2 many on the mac field tblMasterUsers pcname user OS (Operating System) mac (MAC Address) tblMasterSoftware mac (MAC Address) installed (Software installed on each PC) I have a one query from tblMasterSoftware...

Well that did it alright! Thanks again for the help, love this forum. I really have learned alot from just searching and reading all the posts. I still kind of get confused on the single quotes and double quotes but I'll get it at one point!

opps! Didn't mean to post the last reply again. Thanks again for all the help Paul. I will give it a try and post back..

Hello Paul, Thanks for the help!! I am getting the error message "Data Type Mismatch in criteria expression" when I try to run the query. Any ideas? Thanks

Hello Paul, Thanks for the help!! I am getting the error message "Data Type Mismatch in criteria expression" when I try to run the query. Any ideas? Thanks

Hello Paul, Here is the SQL SELECT tblOne.name, tblOne.address, tblOne.ss, tblTwo.account FROM tblOne LEFT JOIN tblTwo ON tblOne.ss = tblTwo.ss GROUP BY tblOne.name, tblOne.address, tblOne.ss, tblTwo.account HAVING (((tblTwo.account)="bank account")) OR (((tblTwo.account)<>"bank account"))...

Hello Paul and thank you for replying. I tried it but now what I am getting is a list of all users. For example name address ss account Bill Miller 111335555 bank account Bill Miller 111335555 credit account...

I have 2 tables with a total of 80 records. Table one has a one-2-many relationship with table two based on the social security number tblOne - Name, Address, Phone, and Social Security Number. tblTwo - Social Security Number, Account Name How do I get a list of all the name, address, phone...