I've tried to search out this answer in previous posts, but couldn't seem to find anything that fit. My apologies if I missed something out there... I have a...

I want to take the following module, and have the info added to a table when the user opens the database, and removes the user from the table when it's closed....

Hi all, I have a really weird problem. I have a query in Access 2007 that runs fine against linked tables but not against local ones. Here is the...

In my query I keep receiving a compiling error. The error message says "Compile Error in Query Expression..." and then the query expression is given, as...

I have two tables with 1 to many relationship 1one-many holds all the charges and holds all the payments. Here is the sql statement: SELECT...

I'm very curious. I have a book I'm working through on Access using VBA. One of the chapters speaks of using ProperCase() but this doesn't work as a direct...

The following query gives me a count of open records using "closedate = Is Null" Example: Bob = 3 Sue = 1 I need to add one more value to the query and when...

Hello Could someone please help me with a query to filter out records in a table that overlap. I have a table with 8 fields and approx 40,000...

Can anyone help please? Report Gross Grand Total and Sales tax Total are off by a penny or 2 The amounts are being generated by the sum expression below...

I'm trying to set a date using the following formula: ratebase_date: iif( = "False", , iif(month()6, date(year(),6,1),date(year(+1),6,1)) If the logic...

hi, can anyone please tell me how to add a comment to a Access report? on certain pages i wish to add comments, but when i add a comment to one page it...

Ok, this has been a challenge I've been trying off and on for about a month now to solve. The speed issues related to domain aggregate functions sent me...

Hello All, I am working with a set of data for which I need to produce a sorted hierarchy (1.1.1.1.1.1. ...) list. There seems to be no limit to the number of...

Apologies if this is a bit basic - I'm rather new to Access. Am using Access 2003 on XPSP2 I have one table with data that looks a bit like this: UserID1,...

I have created a query: DELETE FROM Employee WHERE Number = Dim currDB As Database Dim qryDeleteItems As QueryDef Set currDB = CurrentDb

I have an Access database I created. They key fields of a particular sort are the "employee number" and the "Hours Worked YTD Total." I have created a...

Hello: I have been helping someone with a database. I am stumped and would like some suggestions on what to try next to solve a stubborn problem. The...

Hello all. I have two tables with the following fields: Table1: Rate_Table Field1: Resource ID Field2: Rate Field3: Date_Start Field4: ...

I created a crosstab that does exactly what I want, but if you create a report based on the crosstab and the data changes, the report crashes... How can I...

I want to delete all but one of the records that have duplicate values in one field. In query design I have tried setting unique value to yes but that leaves...