Search results for query: *

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

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

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

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

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

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

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