I hope this makes sense. What I am trying to do is, on a report, if the department number is 99 for a certain division, then split the $ amount between the...

I hope this makes sense. What I am trying to do is, on a report, if the department number is 99 for a certain division, then split the $ amount between the...

I have a table that contains fields with date and time stamps but the format of these fields are text. Does anyone know how I can leave these as text but...

I am somewhat new to Access and trying to figure out how to edit data based on a parameter query. Basically what I have done thus far is create a button with...

a student know one ore more programming language in a mask i select from a list_box one or more language and i send ad parameter to a query that extract the...

I hope this makes sense. What I am trying to do is, on a report, if the department number is 99 for a certain division, then split the $ amount between the...

I have an access table which has duplicate records with the exception of one text field which has different data in each record. I would like to combine the...

Hello, I have 4 columns that contains inventory in 4 warehouses. I want to add a column that will calculate the total inventory per SKU (line) for all...

i'm trying to find the total revenue for each of my employees right now the query lists each employee hundreds of times for each transaction they make how do...

Hello, I have 2 columns that contains items category and product type. My table reads like this "SKU" "Item Category" "Product Type" etc In items...

Hello, I have 2 columns that contains items category and product type. My table reads like this "SKU" "Item Category" "Product Type" etc In items...

The following is a module I use to calculate time. I use the following string in my reports. But now I need to know how to Add all the calculated time to...

Looking for a quick formula that I cannot seem to figure out. I have a database of my time, on a week ending basis. Table includes: RecordID Week...

Hello, I've created a database with some one-to many relationships. One table has some "generic sample data" (name, manufacturer, type) It is organized in...

I am trying to convert seconds to hh:mm:ss Below is what I have and it doesn't work. Any help is appreciated. TTime: ((\3600) Mod 24)) & ":"& ((TSeconds] \...

When I only want to chosse one criteria in a parameter query it works well, but somtimes I would like to leave the Parameter Query blank so I can see all the...

I would like to remove rows based on duplicate recoreds in one column. see table below. KEY DETAIL1 DETAIL2 X1 A ...

Can a single specific record based on two different fields "school" and "date of action" be opened in a REPORT using a command button? The DB in question is...

My query currently displays 2 colums and 6 rows, as...

I have 3 modules that I would like to use within a query I am designing. I currently have an expression in one field of my query that references one of...