I have been trying to manipulate data from a fairly complex database. I am creating a report that is counting a specified field once it has gone through a...

hi, I have a query which shows the info i require. It shows Examiners & the programme types they are associated to. Each examiner must have 1 programme type...

Hi all I need to develop a matrix table, and at my limited knowledge, i think the pivot table is the suitable for this database. The problem is...

This code returns the Month. I need another column to return the year but there is not a YEARNAME function... IIf( Is Null,Null,MonthName(Month(),True)) Any...

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 again, I have a situation that may call for either a multiple nested IIF, or a Switch(), or a DateDiff, something else I haven't even heard of. Basically,...

I'm relatively new at access so I'm hoping someone might be able to give me an efficient way to perform the following; I'm trying to retrieve historical...

I wonder if anybody may be able to help me out with a problem I am having. I am using Access 2003. I was given a massively huge table (over 1,000,000...

id like to ask if there are any tips on how to speed up query calculations...? ?? what are some of the practices shud i follow?? i actually have this...

Hi everyone, I have two tables i.e Bills, Payments. I issue bills to clients based on table bills. When I receive payments from clients, I enter data...

I have a table that I need to divide into several smaller tables based on the region that each record belongs to (the region information for each record is in...

I have a field that contains either 5 or 6 digits. I need an expression for a query that looks at the number of digits in the field. If it has 5 or 6 digits...

My apologies if this is a duplicate - I don't think the previous one I wrote was mailed. Here's the issue: I'm trying to create a query that displays all of...

In the database I am working on, I would like to be able to create a report with a list of all the properties in the database, accompianed by the date of when...

I want to take this module and edit it so the info is added to a table when a user opens the database, and removes the user from the table when they close the...

I am trying to build a query in Access 2007 that will display all records that fall within a certain week, based on a week ending date. The week ending date...

Is there a way to automatically add sequential numbers to a query where there are multiple records for each primary key? For example: ...

Hi all, I am trying to run a query to create shipping labels. What I am currently doing is grouping on the order_ID and creating one shipping label per...

We have customers that we need to remind on a six month basis that it's time to change their air filter. I was told that if we either imported an Excel...

New to Access, I want to post the result of a querey onto a control on a form A is it possible? 2 How is it done? thanks