Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. melost

    Formula to add report field with text and Julian Date

    Okay I figured it out, not sure if its the best solution, but I created a Module called JulianDay with the following: Function CDate2Julian() As String CDate2Julian = Format(Date - DateSerial(Year(Date) - 1, 12, _ 31), "000") End Function I then used this with Expression Builder on...
  2. melost

    Formula to add report field with text and Julian Date

    Hello, Thanks for responding. For example, 160 is the Julian day for today June 9, 2005. So for this particular field on the report I wish for it to display as such: D051609949 D05 is the static text 160 is the Julian day 9949 is a [Vendor ID] melost
  3. melost

    Formula to add report field with text and Julian Date

    Hello, I've got a field I wish to combine static text, julian day, and vendor number. Can't figure out the Julian day piece. Here's what I have on the control source for an unbound text field with text and Vendor ID. I need to add the Julian day before the Vendor ID. Any ideas? ="D05" & [...
  4. melost

    How Do I Retrieve Information from another table if Checkbox is True

    Hello, Thanks for responding. Unfortunately, it's a DB created and managed by someone else where I'm unable to make any changes. I could correspond with him. Any ideas on changes to make? melost
  5. melost

    How Do I Retrieve Information from another table if Checkbox is True

    I'm trying to create a report that requires a list of names that are checked. I guess I can do a list on the report, but not sure how to handle the query portion. tbl1 has all the checkboxes, but tbl2 and tbl3 have the names. Chkbox1 = person1, etc. Chkbox4 = person4, etc. tbl1 Chkbox1...
  6. melost

    Expression Function Error when Applying =Date() to field on report

    Well wouldn't you know it, I added Common Language Runtime Execution Enging 1.0 Library and it worked. Go figure. melost
  7. melost

    Expression Function Error when Applying =Date() to field on report

    I checked a workstation with this issue, and found under references a long list. The ones THAT ARE selected are: - Visual Basic for Applications - Microsoft Access 9.0 Object Library - Microsoft ActiveX Data Objects 2.1 Library - Microsoft DAO 3.51 Object Library These are the same on my...
  8. melost

    Expression Function Error when Applying =Date() to field on report

    Hello M8KWR, If it is missing, what should I do? Also, if all else fails, is there perhaps another date format I could use than =Date() Thanks, melost
  9. melost

    Expression Function Error when Applying =Date() to field on report

    On some workstations when running this particular report the date displays as #NAME? and when I attempted to edit the field on the report by just re-entering =Date() in ControlSource I received the following error: "The function you entered can't be used in this expression. *You may have used a...
  10. melost

    Finding Duplicates Using HAVING clause

    ByteMyzer, Whew, finally got it to work. Thanks for the hand. I've never used WHERE EXISTS before. melost
  11. melost

    Finding Duplicates Using HAVING clause

    Hi, Basically, I'm trying to pull duplicates that have the same id, sub_date, and code. If you notice below id 000022331 is returning different codes (not dupes.) Therefore, its not a 'true' duplicate. id 000012311 would be (dup id, sub_date, AND code). Here's my Access's SQL statement below. I...
  12. melost

    Using WHERE clause for multiple criteria from more than 1 table

    Thanks. This portion... (((tbl_dental_claim.claim_date) In (SELECT [claim_date] FROM [tbl_dental_claim] As Tmp GROUP BY [claim_date],[patient_id] HAVING Count(*)>1 And [patient_id] = [tbl_dental_claim].[patient_id])) AND ((tbl_dental_claim.claim_status)<>"Duplicated")) ... is returning rows...
  13. melost

    Using WHERE clause for multiple criteria from more than 1 table

    Hello, I'm wanting to add another field (tbl_claim_line.proc_code) into my search criterial below, but keep receiving syntax errors when I try to modify the WHERE clause. Currently, it works fine retrieving duplicates based on (tbl_dental_claim.claim_date). Just wondering what's the correct...
  14. melost

    Confused as to Why Totals in Report are Off from Qry

    Hi dhookom, I kept investigating this further and it turns out that the query "was" really duplicating values. For some reason when I would filter by ID on the results, not all were visible. I exported the query into an Excel spreadsheet and sorted by ID, and there they were. Anyway, what I did...
  15. melost

    Confused to Why Query is Tripling for One ID

    Thanks for your help. Got the query to return the right amounts, now I gotta figure out why the 0 fields dup with values from the other rows with vlaues. Geez. Nothing's that easy. Very strange. I posted something in reports. thx again, melost
  16. melost

    Confused as to Why Totals in Report are Off from Qry

    Thanks for some help, scatching my head too long on this one. My totals in the query are fine. However, in the report it calculates the with 0's with amounts from the fields that have amounts (sum=forms.field). I started off by grouping the totals field (I only need the grand total). I also...
  17. melost

    Confused to Why Query is Tripling for One ID

    Thanks for the prompt responses. Yes when tbl_claim_line returns matched rows found for ID it's duplicating the amount_paid figure (which I want to avoid.) The amount_paid field only exist in the tbl_dental_claim. Would using an expression what I'm looking for or some sort of nested query? melost
  18. melost

    Confused to Why Query is Tripling for One ID

    Stumped. I have a query using two tables using the following query for a report. I need the tbl_dental_claim.amount_paid. However, when there's more than one duplicate ID in the tbl_claim_line, it's returning the rows which is fine, but it's also multiplying the amount for figure in...

Part and Inventory Search

Back
Top