Search results for query: *

Ok got that part, combo box is in the form header, displaying names from USER table. The recordsource of the form should be somthing noted above, referencing what is selected in the drop down...Now how would I incorporate displaying the unmatched queries in the form detail...

yes I have main user name table, which is linked to each users individual table by a one to many relationship. User Name to Name...

ok so hint to get me started... Form!Formname!Combobox!Controlname.text.....close? After record source on form, what should be contained in the combo box's after update?

I have been trying to stay away from SQL as I am a bit rusty. But now have been looking at tackling this another way, perhaps playing with a union or inner join query? Should i go down this route? I am not sure i am following your suggestion. Can I set the RecordSource property of the form...

Hello, Ok i know the structure of my DB is a bit "loose" but here is the deal: I have several different user tables, all same structure, some have more/less info than others...I have created an unmatched query for each table, which compares the user table to a standard information table...

yep totals query worked good, thanks!

Hello I have a report which displays records by instance group. I have a box =count[response] in the header of each instance group. How can I sort the report to display by that =count[response] box? I have tried the grouping and sorting: [Response] descending =count[response] descending...

gotcha. thanks!

I have a query which displays user records from different offices. I would like a total number to be displayed in a column, so it counts number of active users per office, Based on office number. It should look like this: Office Name Count a steve 2 a bob 2 b Gary 1...

got it. thanks!

It is numeric, and I tried =DLookUp("total","Lookup","BSONum = """ & [BSO] & """"), however nothing is appearing on the report. No error message either. The box is visable... this in not a parameter query/report just to mention.

Can you have different Dlookup values on a report by header? I have a report which dispalys certian people from multiple offices, grouped by office. I have a office header and am trying to use Dlookup to dispaly total number of people from that office, stored in a lookup table. Is this...

hmm, ok not to great with code, where can i find instructions on how to do this?

is there another way to import besides the Wizard?

Is there a size limit to an excel spreadsheet import into access? I have a spreadsheet that is constantly growing, it had 667, rows(1326 kb)yesterday and imported into a new table fine. Now it has 753 rows (1,441 kb)and won't import..."an error occurred while importing..." I deleted some rows...

sorry I have figured it out thanks to you both

thanks, however, off couse, i am failing to get this to work, do to me being newish and not knowing where to put parens...here is my code: SELECT [Active Directory].LastFirst, [Active Directory].Email, [Active Directory].AgentNumber, [Active Directory].AGT, [Active Directory].BSO FROM [Active...

I have a parameter query which asks to enter in an Office number The problem is that there are office numbers which include letters, like 4044b. So when the query asks me to enter in office number I want to enter in 4044 and have all records displayed that have office of 4044 as well as...

Spot on Duane, thanks again for the help. So it was just missing the extra parens and a &...was this strictly because it was a text field, not number?

I have this DLookUp in the control source of an unbound text box on a report. =DLookUp("AgentNum","AgentLookup","BSONum = " & [BSO]) lookup table: name: AgentLookup 1st column - BSONum 2nd column - AgentNum my report is opened by a parameter asking what BSO, which is a number (could be...