When creating a Pass-Through Query, is there a way to create two or more “ODBC Connect Str�s in the Property Sheet? ODBC;DSN=DMH_Hub;Description=DMH_Hub...

I have create a query which combines two tables; ASSETS and UNITINFO. The UNITINFO table is linked from another database and the ASSETS table has a field...

I am Brand new at Access but I can't seem to make a seemingly simple task work, A Simple sign out system, I have 3 Data bases, STUDLIST, EQUIPINV, and...

I have this query: SELECT item_types.name AS Type, SellableItemsList.item_id, item.short_desc, IsNull(!) AS Blank FROM item_types INNER JOIN (item INNER JOIN...

Hi How can I query a table with the following data: CreditorName, CreditorID, Value so the date is summed up by Value (there are multiple entries for one...

Hello, Newbie here. I am querying a one to one relationship, each record from table 1 has one or no related records from table 2. I want those records with...

I'm working on a survey database but I 've run into a problem. The series of questions I'm asking will all have 1 of 3 possible answers; yes, no, or NA. I'm...

Trying to use the IIF expression in conjunction with a combo box in a form. Combo Box: Blue Red Green Blue/Red In the query I want the results to filter the...

Ok peeps my head hurts and its seriously taxing my time and patience i think its time for the A Team lol (A=Access) ok heres my issue. im creating a...

Hi. I have a field that is set to Yes/No. I want to ask the user a question and based on their response (whether they type yes or no) I want the query to...

Hello, I'm creating reports using multiple append queries to add data to a table which I export in Excel and send over to customers. My table has 16 fields...

I have the following R23/24/25/26 - the then there is a text phrase R23 - then there is a text phrase R101/34/56 - then another text phrase I am trying to...

Hi, I would like to be able to have a running total for the month. date sales 10/11/2009 100 11/11/2009 ...

I need to create a query which when completed will popluate a report that has a 3-tiered column layout. I have multiple Stations (numbered text field like:...

I have a two part question as follows: 1st part: I am wanting to create a query that is driven by the user selecting a value from a combo box on a form. the...

I have a field called the calcel date. It is either blank or have a date in it. I need to produce a query (which leads to a report) that would exclude any...

I have an Employee Roster database; one of the tables tracks up to 9 promotions, transfers, reassignments, etc. (called "Movements"), and their related dates...

Employee Commission - I cannot get all 3 formulas to work. PAYROLL SUMMARY TOTAL SALES FOR THE MONTH 27,000.00 PRODUCTION BONUS LEVEL ...

I can tell I had a rough week-end because my brain isn’t working today. I have the below query with a one to many join. SELECT...

Ok peeps my head hurts and its seriously taxing my time and patience i think its time for the A Team lol (A=Access) ok heres my issue. im creating a...