I have a table that contains job assignments. I want to, for a given date range, calculate the percentage of job completion. So I want to take the number...

Hi all, I have what's certainly a newbie question. I have a query that supplies data to a form. Is there a way to filter the data shown on the form...

I am wondering if there anyone has found a method for 'turning off' how Access auto-renames a field that has a calculation against it. For example, fi you...

I've got an access dbase that has a link to an sql dbase table. I didn't create the sql table and I'm just linked to it so I can run a couple custom reports...

I want to create a pie chart from an Access table. I have a number of queries which are allocated to certain people under a field called "Allocated to" and...

Hi all, I have Access 2003 on WinXP. I have a table with: PartID TransactionID (runs in incremental order by 1) DateOfSales TotalCost NumOfUnit UnitPrice...

Hoping someone can help me. I have Access 2007 and a query with a field using this expression: IIf(DCount("*","Deductions")30,5,10) Access crashes every...

My DB has 8 fields (wo #/Date Inspected/Inspection Type/Group/ Group Items/Fault/Fault Description/Comments) fields 3,4,5,6 are comboboxes,field 4 and 5 are...

I have a date field called "transactiondate". How do I query all the data for the previous two full weeks? How do I query the data for the previous 52 full...

I have a table that tracks employee attendance records. In the table, I am calculating an accumulative total column for points. This took me quite some...

Hi, I am creating a function that I want to use in a query. I need to test in the function whether the recordset is BOF. How do I refer to the recordset from...

I have a stored procedure that does not return records but needs two parameters to run @ SAP_code & @Source @SAP_code = interger @source = varchar I can...

I created an IIf statement in my query and it somewhat works. When I ran it, the "False" showed up as "False". However, the "True" showed up as "#Error". Why...

Good Morning All, Is there a more efficient method of finding closest date between unrelated tables? Any assistance provided is greatly appreciated. Thank you...

Hello all - I have a table with 6 fields and 1100 records. I use a crosstab query to view the data in the format I need. That works great. When I try to...

I have a database that lists clients, the case # related to that client, etc. multiple clients may have the same case #. I want to count the number of...

I have a query that returns sales history for a range of inventory items. I have a form that allows me to enter a range of items, and a date range as well. ...

I have 3 fields (see below) and each of them contains True or False. I was trying to write a query that combined all of them and output only 1 of the 3...

Hi, I need help please Trying to do a select query where I only want one row returned if a field has two values Example: Joe Bloggs can have two records...

When naming a folder it keep saying that the path name is to long. I can only use 8 characters or less. How can I extend this. I am using office 2007.