Search results for query: *

I need to create a quert that gives me the top 10 most sold item in each store. In other words I have approximately 8 stores that and I want only to find out what items are most popular in each location and with this query I will create a report showing by location what was the 10 most sold...

I wrote code where a list box pops up and the user gets to select one of many dates which appears as 10-Oct-03 for example. The problem is that once the user selects the date it is pass through the code as 10-10-03 and by the time it is pass to the query where I have set the criteria...

My users are now unable to access the database. This problem did not begin until a week ago. When ever some of users attemted to open up the database they receive this error "Could not use 'Admin'; file already in use." instead of getting the logon box. This also occurs even when they...

This is the error message I keep getting when I run my query: 3464: Data type mismatch in criteria expression. If anyone knows what this means please let me know. Thank You.

I having attempting to get my query to get criteria input from a Public Function in order to create the output for a report. In the Public Function I have it set up like this: Option Compare Database Option Explicit Dim strDom As String Public Function FindDomain() FindDomain = strDom End...

I was wondering has anyone come up with a way to automate archiving old records after they have reach a certain time period, like anything over 6 months old? If there is a way your assistant would be greatly appreciated.

I was wondering if there is a way to find out who is logged into the database. I have a problem with identifying the person or persons who are logged into the database when I need to make changes, because they are accessing the database on the network. Any help with this problem is greatly...

I am attempting to create a delete button and program the button to send the items being deleted to a table, which keeps tracks of the date, time, and possibly the person deleting the info. Any assistant you could provide would be greatly appreciated. Thanks.

I have a report that is send to me by email in snapshot format. I was trying to import this data into my access database for analysis, but have been unsuccessful. I have already contacted the indiviual who sent me this attachment and he saids that the way they have their use interface set up...

I have a number of mutiusers that access my database. I was attempting to split the database by using the tool wizard, but every attempt I have made returns an error. I truely don't know what this error message is referring to. The message reads as follows: "You tried to assign the Null...

For the last 2 days when my user's have been putting Data into the database they have been getting an error message that reads "No Records Found". This occurs after they have inputed at least a couple of records. When I go into the database to view the tables all the tables have...

I have a form that has a drop down box where the customer can select an item. I have three items which if select I want it to turn data enter into the text field into a negative value when the customer inputs their data, but only when they make that selection. I am stumped on how to get this...

I have a problem where I need to total up the sum of each group average at the end of my report. In my report for each customer I had to find out what was their average cost per month but at the end of the report I have to total up all the averages together. I have tried using Sum but that gave...

I'm attempting to do a comparison of two tables with the same data but one table is a month older than the other. I trying to create a query that would give be the different changes made in the table since the previous month before. Any help would be greatly appreciated.

I have two fields in my query , lets call one Access_amt and the other Total_amt, where I only want the query to print out the record of those who's Total_amt is greater than the Access_amt. I have tried a lot of combinations such as creating a subquery with in the query, but nothing seems to...

I have two fields in my query , lets call one Access_amt and the other Total_amt, where I only want the query to print out the record of those who's Total_amt is greater than the Access_amt. I have tried a lot of combinations such as creating a subquery with in the query, but nothing seems to...

My customer has requested that he would like to be able to access his reports in a word document instead of having to convert it from an access report to MS Word. He wants it done the same way it’s set up now, where there is a form that he just has to click a button and the conversion will...

I have three subforms on my main form and because there is no data in one of the subforms I get a #Error message in my text box. Here is the formula that I am using"=IIf([subActiveCallingCards].[Form].[HasData]=True,[subActiveCallingCards].[Form]![text6],0)+...