Search results

How do you create a main report and subreports? It's basically a 3 page report that I'd like to populate from a table. Kind of like a mail merge but I will run this from a form.

Sorry that I'm confusing but this is working for me right now. I don't need all the other info in the fields since "one" is basically the same thing as the other "one". I can see this being a problem later but for now it works like I like. Thanks!

I have attached my database. Any suggestions would be greatly appreciated in helping with organizing and using other tables to have no duplicates in the combobox.

Is there a way to choose the first "one"? Just thinking

Column 1 is the ID, I don't want it to use that because 1,one and 4,one I want to just show up in the combo box as one

So is this the problem? SELECT DISTINCT Sheet1.ID, Sheet1.Vendor_Name I tried it as just: SELECT DISTINCT Sheet1.Vendor_Name but then the combobox is empty

SELECT DISTINCT Sheet1.ID, Sheet1.Vendor_Name FROM Sheet1 ORDER BY Sheet1.Vendor_Name;

I am still getting duplicates and I have attached a screen shot. "One" is repeated. Any other ideas?

pbaldy, Do you know how to ignore duplicates from a table and only show one record in a combo box? Thanks

I have attached a picture of the column I'd like to ignore duplicates. I don't want "one" repeating.

I have an issue with duplicate records showing in a combo box. I have checked "Yes" for unique values and they still show. I only have one field showing in the drop down and don't care about the other fields for that specific selection. Any ideas how to remove these duplicates from showing?

I'm working with getting a 3 page report to print/create PDF of the 3 pages. Right now I have the formatting set up for the 3 pages but each is an individual report. Is there a way to combine the reports into a single report? I've been messing around with subreports but can't get it to...

That's what I want, the first record in the query. All the drop down box does is populate the query with the selected info.

Nevermind I got it! =DLookUp("[Due_Diligence_Email]","Docs Request")

Here's the problem I have now... =DLookup("Due_Diligence_Email", "Docs Request", "Sheet1.ID = 1") This is tied to form with a drop down box that gets the data from a query. If I have 1, then it only works for that 1 selection. How do I get it to just use the active record in the query?

Awesome, got it working!!! Thanks!

I tested it but exactly what I thought happened. How did you test it?

Would you use DLookukp() in a form or the query? I'm afraid if I put it in the Macro, it will just show "DLookukp()" as the email address

I created a macro in a form to send a report based on a query. I'm looking for a way to auto populate the email address field in outlook based on the query. Thanks