Search results for query: *

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

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

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

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

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

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

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

I have this query: qryBSMRDb SELECT * FROM qryBSMRDGSa WHERE (((qryBSMRDGSa.Response)=3) AND ((qryBSMRDGSa.RD)=[Enter RD])); Which calls another query: qryBSMRDa SELECT RD, BSMNum, BSMName,'BSMMedSup' AS Instance, BSMMedSupCom AS InsatnceB, BSMMedSup AS Response FROM [BSMRDGS] UNION ALL...

I have this query: qryBSMRDb SELECT * FROM qryBSMRDGSa WHERE (((qryBSMRDGSa.Response)=3) AND ((qryBSMRDGSa.RD)=[Enter RD])); Which calls another query: qryBSMRDa SELECT RD, BSMNum, BSMName,'BSMMedSup' AS Instance, BSMMedSupCom AS InsatnceB, BSMMedSup AS Response FROM [BSMRDGS] UNION ALL...