Search results for query: *

hello lameid.. thanks for the time in reading my long post and replying to it... :) I kinda get what you're trying to suggest... although I know it's sometimes bad to actually spoon feed us with the right answers to our questions.. but is it possibly to actually help me out on how to do this...

Hello guys, I am currently in the process or re-structuring one of our current databases. We currently have an aweful unnormalized table structure that I changed the table structure to hopefully a properly normalized table structures I think I did an okay job in normalizing the tables, I am...

Hello dhookom and MajP, Thank you both for your responses, I did what both of you suggested. to create seperate queries for Min and Max then create a final query to calculate DateDiff... and now the query runs faster :) @MajP, you said on your post that "I am not that smart..." just want to...

Hello guys, I have a simple Job Tracking database wherein we track a number of SitusIDs and determine which phase/status is it going through. Our Client is a bank wherein they send us deals (PK in db is SitusIDs) and we track the status of each deals in the database. To have a quick view of...

Thanks PHV for your reply, I created these queries: testqryMaxStatusDate-InProcessForWeeklyReport SELECT JT.SitusID, JT.WeekNumber, JT.DealName, Max(DS.StatusDate) AS MaxOfStatusDate, JT.UBSOriginator FROM tblJobTracking AS JT INNER JOIN tblDealStatus AS DS ON JT.SitusID = DS.SitusID WHERE...

Hello guys, I have a Job Tracking database wherein our team does sizing reports (in case you're familiar with Real Estate terms) from our client and we track the status of each loan in this database. I want to share the table structure of the Job Tracking database (tables that I think relates...

Thank you both MajP and dhookom, well it is 53 fields coming from different tables and just being used in one query. Thanks for both of your help :)

Hello guys, I need help with a messed up update query I did today... I had the wrong approach on how to correctly use an update query, and I know now how to write it correctly, however there are about 53 total fields I need to re-write per query, and I have to do it for 3 different queries...

Hello PHV, Thank you for helping me with this one. However, this query is working correctyl before, but then there will be times that when we run the query, it gives an error message: Run-Time error 3622: You must use the dbSeeChanges option with OpenRecordset when accessing a SQL Server...

Hello PHV, Thank you for your reply... Although currently I am being pulled out into a different rush project, so I couldn't check this as of this moment. Just want to give you a heads up in case you were waiting for a response from me if these queries work. I'll let you know right away when...

hey, thanks for your reply... I kinda figured that is a very wrong query... I keep on playing with how I should write it, but still no luck... can you help me out with how the query should be? Thank you for your help

Hello guys, I am creating a new db project in our office, and it is kind of a job tracking database wherein we have a bunch of loan numbers, and we create ASRs and/or Data Tapes (using excel) and we just use the database to track the status/phase of each loan number, wherein if it has been...

THank you PHV!! The query works :)

oh, I didn't know it should only be that simple... as always I try to over complicate things.. Thank you very much PHV, it looks like it's working now. Thanks

...FROM tblQueryNames AS QN INNER JOIN MSysObjects ON QN.qryName = MSysObjects.Name WHERE ( (MSysObjects.Name) Like "qryDailyReport*") Or (MSysObjects.Name="qryInProcess") Or (MSysObjects.Name="qryNeedToReview") AND (MSysObjects.Type=5); and it is now giving the...

...INNER JOIN tblQueryNames ON MSysObjects.Name = tblQueryNames.qryName WHERE (((MSysObjects.Type)=5) AND ((MSysObjects.Name) Like "qryDailyReport*" Or (MSysObjects.Name)="qryInProcess" Or (MSysObjects.Name)="qryNeedToReview")); and it gives a Microsoft Visual Basic Run time error saying: The...

...(cmboQueries) Row Source is: SELECT DISTINCT MSysObjects.Name, MSysObjects.Type FROM MSysObjects WHERE (((MSysObjects.Name) Like "qryDailyReport*" Or (MSysObjects.Name)="qryInProcess" Or (MSysObjects.Name)="qryNeedToReview") AND ((MSysObjects.Type)=5)); and the After Update Property is...

Hello dhookom, yes the query is working, even with the iif(IsNull(...)) I was trying to write another Nz() inside the first Nz() and seem to not make it right, so I tried to iif statement again and when it worked, I was relieved and thought of leaving it that way for now... Thank you very...

I think I forgot to mention one important info... The database we are working on have tables stored into SQL Server 2008... I've initially created the tables and relationships in Access, then just used SQL Server Move Data Upsizing Wizard... Is there a possibility that the database crashes...

Hello again, okay I was able to re-write the column expression and it looks like it is pulling out the correct results, I wrote: WkDays: IIf((SELECT StatusDate FROM tblDealStatus WHERE StatusChangeID = 8 AND tblDealStatus.SitusID = tblJobTracking.SitusID) Is Null,"In...