Search results

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

:( 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: (see attachment) instead of getting the logon box. This occurs even when they are the only one trying to logon. I...

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

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

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

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

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

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

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

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