Search results

Thanks guys, but I found out that if I create a query for each location using the "Select Top Ten" statement then create a union query I get my results. Again thanks for all your help.:D

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

Here is the query: SELECT [CERT June].Category, [CERT June].Weight, [CERT June].Status, [CERT June].Domain, [CERT June].DateofSRR FROM [CERT June] RIGHT JOIN Status ON [CERT June].Status = Status.Status GROUP BY [CERT June].Category, [CERT June].Weight, [CERT June].Status, [CERT June].Domain...

I can elimate the spaces for everything except Cert June which is the table name. If I change the name I would have to go in and change all the queries, forms and other reports in the database

This is exactly what I need but I keep getting a "syntax error in query expression" . This is how I wrote it: (Select Count(*) from [CERT June] where OS =[Catagory IIs].os and [Sum of Catergory] >=[Catagory IIs].[sum of categroy]) :confused:

Data type mismatch I have narrow the problem down. 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...

Sorry about that, but what I meant was that there is no font or back end.

Database is located on the network where everyone can access it. This database was orginally created by someone else. I'm just now taking it over The database was never split nor did the creator but a front end on the desk tops. So all the security setting are located where the database...

The problem is that this is only happening to the users who could not gain access because they kept getting the error message that stated the "Admin; file already in use" , now since I corrected that problem they are getting this second error message. No one else is having a problem. I would...

Security Problems I did as you instructed now I am getting this error ( See attachment)

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

Thanks :p

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:

Thanks, for your help but all of sudden it started working. I don't know what the bug was cause yesterday I first step thru it and it seem that the flow of data for strDom wasn't flowing correctly and them when I came back to it today, it worked with out a problem. There must had been some...

The value of strDom is assigned when the user open the form to enter data for certain Dormain. The user needs to print out a new report after they had entered their data which includes all the previous data entered and to keep them from having to enter the strDorm data again all they would have...

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:

Help I was trying to go to that link but I keep getting an Internet Server Error 500. If possible could you give me that link again. This is something I would like to incoporated in to my program.... Thanks...: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: