I need to delete an item from a table, using a query and it looks like "Action Query" is the way to go, but I cant find anything in Access training that...

Hey Guys, I'd like to build a type of "search engine" in one form on Access. I have a table that holds general questions and answers about products. I'd...

Hello, I need to run a report that brings up only the records for managers at work. They are flagged as managers in the table Name. What I want to do is...

I have a module that was given to me to calculate time. It works beautifully. However it shows Days. I need to see if someone could help modify it to...

Hi I have just learnt how to retrieve the Top 6 events (by date). There are now 40 sets of different events. Each event has a decimal score. I would like to...

I copied a number field from table to a text field in another table. The text field is a length of 7. It contains charecters that I want to front load with...

Hi all I record a number of events with their dates Different events may occur on the same date On some days no events occur. I need to retrieve records for...

I have a button that launches a query that counts the records in a table. I need to get that count over to the form. Is there a way, or a better road to...

I've got two seperate make-table queries that are both supposed to populate into the same table. One works, the other doesn't. I have a feeling it is...

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

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

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

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 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) & "/" &...

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

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

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

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