Is it possible to be able to drag a shape (rectangle, circle, etc.) from one side of a form to another. (to simulate a simple 'mini blue print'). If so, any...

I have a query that calculates a quarterly value from year to date values. Each quarter the user inputs YTD values and the query calculates the quarterly value...

There are two tables and a form: tblAssets tblEmployees frmAssets tbleEmployees, among other things, has columns for User FirstName, User LastName, and...

Need to add zeros to data like MCRD-472 to show MCRD-00472 and like NBC-2 to show NBC-00002 and like NBC-M14 to show NBC-00M14. To Query text box.

Using Access 2007 I created a user defined function used in a query that works fine on single criteria but not two or more. These work...

I have quite a complicated query: SELECT .DateOfPayment, ., .AmountofLoan, ., .DateofLoanAgreementSigned, ., ., ., ., .PaymentDue FROM ( INNER JOIN ON .ID =...

The following example is a simplification to make my question less complicated. I have a database of 3 people: Brown, Jones, and Smith. Each person in the DB...

Can you tell me how to format this expression in a Query as a percent. LastNmPerc: (/)

Hi, I want to average data but I need to exclude the highest value. in other words I have 18,20, 25,32, 10. I want to average 10, 18, 20 and 25 eliminating 32....

Hi, I am self-taught on Access, so please forgive my ignorance here. I have a subform that allows for multiple selections from a table, one line/field per...

Access 2007. I've created a Query and at the bottom of the data, I'd like to run: Sum (which works) Average (which works) Count (which works) Maximum (which...

I have 2 tables...Job and Material. I am trying to configure dlookup to return value of 'Note_Text' in table 'Material' based on 'Part_Number' in table...

I received a .sql query from a collegue...my question is how do I get this query into Access? I see the pass through query option...I do that and paste in...

Hi - I have this query below, but the data do not have First quarter, so how can I list them on the report? Thank you for any reply. Query come out with the...

Hello All This query returns 497 records: SELECT staffs.practice, staffs.name FROM INNER JOIN staffs ON .practice = staffs.practice; But this query only...

My query is like below. When I open it, quickly will be opened but I want to go through records in datasheet view, for example go to last record, it takes...

Dear all, I'm currently working with a fairly complex query covering six tables. I've basically got it sorted, but it's got me thinking about multiple,...

Hello, I am trying to do a query where I need a result based on 3 criteria, but not sure how to do it. in written term would be like this for a new fields...

I am trying to set up a staff training database that will help figure out what trainings they still need to take for their positions. Here are the mock...

How do I convert (226942) seconds to hours? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/201004/1