Ok, If I want to calculate the difference of a date with the following date in Access: so 3/29/08 in cell A1 and 5/3/08 in cell A2 and return the value in B1...

I have two queries, both updateable. I would like to join them as a form source, but they aren't updateable when joined. Main table is same for both...

Ok, If I want to calculate the difference of a date with the following date in Access: so 3/29/08 in cell A1 and 5/3/08 in cell A2 and return the value in B1...

how i would i get the number of employees for each month and year that we have data for? my fields are...

Hi, I have a main form with a sub form and the two are linked by Child and Master fields. The main form has a list of workstations, and the sub form has a...

I am using MS Access 2007 and I am having a problem building an expression in Expression Builder for a Control Source for a report. I have a totals page...

Any tips on best way to do this. I have two tables, related one to many Case--Payments I need a query that finds the last payment for each case and outputs an...

I runa query and forcing a specific value with a leading zero. i.e. 011210 When I run the export the first zero is eliminated. 11210 Any ideas why this...

Hi, I am not sure if this is an Access question or a SQL question. I have written an Access-front end database (2003) with a SQL back-end. I need to...

How do I create a querie where I can pull a date range 10 business days past the entered date. ---------------- This post is a suggestion for Microsoft, and...

Hi I wonder whether someone may be able to help me please. I am trying to create a query that shows updated fields within a given time period. I have set up...

Hello, I have been looking at some running sum examples (http:// support.microsoft.com/kb/290136), but can not work out how to apply it to my query. I have...

I have a monthly sales file that contains several invoices that allows duplicate records of parts. My second table is a different sales file that also...

Hello, I am hoping someone can help me out here as I am pulling my hair out. I have a form that has unbound fields as follows Text Box - Start Date Text Box -...

Hello everyone. I'm getting mad with this. I want to retrieve the data from a many-to-many relationship into a single output field. For sample, such a query...

No it can't be done in a query and there is no vb function. But Graham Seach wrote one that does the job: See "A More Complete DateDiff Function"...

I am learning (slowly) how and where to use VBA and SQL. I've noticed that some jobs can be done using either. For example, I can have a button with 'ON...

I have a query in which one date need to be filtered based on another field. If the field =1 , the data needs to be filtered showing only data where =. ...

Hi everyone, I hope someone may be able to help. I have a database with three tables. The main table is a portfolio of projects with budget, date and other...

I have a column with city and state in one field (separated by a space and/or a comma). I want to separate the information into two fields (similar to what...