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 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 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...

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...

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 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...

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 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...

Hi, I am trying to figure out why I keep receiving a "Enter Parameter Value" message when I run a simple select query. I am trying to divide 2 fields w/in...

Sort of new to Access and trying to figure out how I can edit data based on a parameter query. Basically what I have is a menu choice from Switchboard...

I have a table with ~15k records of sales. I'm grouping by Customer and by ProductID and using subqueries to show the top 5 products by a Sales$ field. ...

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...

I have a form being used as a menu with a list box containing reports and forms I’m using ‘Case’ to make text fields or additional list boxes visible...

I am trying to put together a query that will return only the records that contain ALL of the criteria selected from a listbox rather than all of the records...

I have used the below in a query just fine. To format data that comes in text from a legacy system. The text is formated YYMMDD. cdate(mid(yymmdd,3,2) & "/" &...

Need to find gaps in a series of time periods (ie 8-8:30, 8:30-9:). I have a table with the time periods and a query that groups the dates and times for...

I think I need an If statement but I am not sure on what to do and would appreciate any help I can get. I have a query that pulls data from a Oracle Database...

Hi, I have a stock data database. I am trying to write a query to return a recordset containing the stock symbol and 14 day moving average (based on last 14...

Hello, I am wanting to know how I can reference a previous record if a field in a current record is blank. If there is no price for a particular date in my...