I want to use the Dsum function on a continuous subform. I want to get a sum of a field in the subform based on a unique ID in the main form. I know that I...

i have an update query that updates the database with new data. i want to run this update query every thursday at 12 noon EST. is there a macro that i can use...

I am having trouble with a query/report that I run that should show the last payment date that a tuition payment was made. It works for most records but for...

In the query given below which is done in Access SELECT ., .Region, Avg(.) AS , Count(.) AS FROM GROUP BY ., .Region; The field Count(.) lists the count of...

I have to convert the source table field to the exact same destination table with conversion of 1 field double percision into long integer Can someone help me...

In older versions of Access, there was a View - SQL View menu button. How do I get the SQL View with Access 2010? I need to create a query which contains...

I have disabled menus and hot keys for users in my app. I need them to be able to use the right click menu in forms though mainly to use the Filter For:...

I have two tables that I need to pull revenue data from and link to a customer, but am running into a problem. Here's what the tables look...

Hi, I need to find the total sales for a customer, I have tried the Group by function but it just groups the company name in ascending order. My fields...

I have a field that has both city and state. The state is abbrievated with 2 characters. Of course, I am trying to seperate the two, so I need one field of...

I would like to sum values across multiples fields but the values in the fields I need are letters. So, is it possible to assign a value to each letter and...

Two questions if you please. When my database opens it runs an action query that deletes the records in a temp table that is used as the record source for a...

In most of my Access Forms I create a custom form property like the following: Form called "fMgr" Public Property Let prpAssignEventGroup(ByVal v As Long) ...

i have a module that loops thru number of lines, parses them and updates or inserts into tables. for k = 0 to Ubound(Lines) if .. currentdb.excute "Update...

I have a table named Table1 that has 200,000 records. Is there a way to randomly select 40,000 records from this table ? Thank you in advance.

I want to create a query that calculates the percentage of a total and multiplies each percentage times a single number that is stored in a table. Here is...

I have a form called TDC and want to filter data in the following fields on opening the form: DiaryAction (text field); DiaryCategory (text field);...

My imported string looks like this ACH SOC SEC 310*First Last I want to access to find the * in the string then extract First Last

I'm working on a database for commission payments and want to know what's the best way for me to set up a payment schedule. I have several different types...

Hi. I am trying to create a formula which will up date an opening and closing balances in a query named Bank query. The fields in the query a ID, BDate,...