Search results for query: *

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...

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

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" & [...

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

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...

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

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...

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

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...

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

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...

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...

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...

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...

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

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...

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

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...