Search results

I figured it out! :rolleyes: I use this statement as the "Raw Source" property. SELECT [DropDown Box Field].Primary Key ID, [DropDown Box Field].Name FROM [DropDown Box Field];

Yes, I do use a Lookup Table and it is the position in the lookup table that is being returned to my report and not the actual data. Any way of displaying the actual data?

I run a Query based on some data in a "drop-down" box. It works in just datasheet view, but when I print it on a report, it displays the position that the data is in the drop-down box. How do I display the data, not the position on the report? Here's an example: My drop down box contains...

I have company names in 2 tables to compare, but the data is slightly different but same companies. I want to know what companies are in one table but not in another. Here's an example: Company Name in Table 1 = Virtual Micro Company Name in Table 2 = Virtual Micro Technologies Same company...

It worked Pat. Just some syntax errors on my part, but I worked them out. Thanks again. Jen

Hi, That worked great! Thanks for pointing me in the right direction. Much appreciated. Jen

in the part number "criteria" field in query design view have something like: (you need the square brackets) [Which part number?] This will give you a input box. Make sure you have all the other fields you need to see. The query will only select the results that match your entered part...

I run a Query to determine how many employees attended a meeting, showing the number of years they have worked at the company. (Example output of query) Employee Name Years with Company John Doe 3 Jane Smith 1 Bill Doe...

Create a "relationship" between the tables and use the "input" in the criteria.