Search results for query: *

I recently upgraded from Access 03 to Access 07. Most of my queries linking to ODBC tables I previously created in 03 are working fine. There are a couple that do not now. The ones that do not have left joins between some of the tables in them. The tables are pulled in from an ODBC source...

I did that. I'm thinking it must be something with the field in the table. I created another query with just this field and get the same problem.

I am running into a problem where the query gives no results when I have [enter budget reference] in the Criteria but if I hard code the same information into the Criteria line the results are produced. I'm trying to create a pop-up box so the user doesn't have to go into the query itself to...

Worked great except for in the field that's also a combo box (so entry can be added if the person isn't in the other table. I'll have to work on figuring that out now. Thanks so much for the help pwise!

Is it possible to have multiple conditions in the criteria field of a dLookup command? I want to autopopulate a value into a form if both pieces of critera are met. The table I'm pulling the information from has the same person (UID) several times, but only one time per project number...

Thanks. The recommendations helped me see my error(s). It's all a learning process, and the posts helped me understand more than I previously did.

This is probably simple, yet I'm not getting it. I am using a form to update records in a table. To prevent duplicate records from being entered, I am requiring a new revision number to be entered when changes are made to the existing records before the new record can be saved. That part...

Thanks PH, that works great (and gives me something to study and learn from). Tom (BTW, the DaysInReport is in the query so I can use it in other calculations)

SELECT IIf(and([ProjStartDate]<[RptEndDate], [ProjEndDate]>[RptEndDate]),MIN([RptEndDate],[ProjEndDate])-MAX([RptStartDate],[ProjStartDate]),0) AS DaysInReport FROM qry_ProposedEffort1b; This gives me an error of "Syntax error (missing operator) in query expression". I'm guessing the solution...

I am trying to query a range within a range. I have a table which has a ProjStartDate and a ProjEndDate field. There is also a DailySalary field. My report has a RptStartDate and a RptEndDate. I am trying to have the report show the salary calculation for any projects with dates within the...

Gavin, Thanks for that solution. It works great in Excel, but not so great in Access. I'm trying to change it to work, but not having success yet. Thanks for helping me look at it differently. Using a daily rate makes much more sense than trying to use a monthly rate. Also, I hadn't...

Of course if you wanted to force the case value to only be upper case you could use... Private Sub If KeyAscii > 96 And KeyAscii < 123 Then KeyAscii = (KeyAscii And 223) End If End Sub ...it basically converts any lowercase value you enter to show the uppercase value of the same...

Any help on this would be appreciated. I'm losing what little hair I have left! I am trying to query a range within a range. I have a table which has a ProjStartDate and a ProjEndDate field. There is also an AnnualSalary field. My report has a RptStartDate and a RptEndDate. I am trying to...

mrkshpntf, My fields are all text. No worries on destroying data, I already made a trial copy first. I've been playing with it all week to no success. Perhaps I'll start a new thread with my specifics (now that I've found where). bendixen

Sorry to hijack this thread a little but I cannot find where to start a new thread and my question is exactly the same as SeanWcisel's. I'm using the code provided by mrkshpntf (almost exactly!) but am getting a Run-time error '3464':Datatype mismatch in criteria expression.