Search results for query: *

Hello, Is there a way to create a query that lists the top 10 by each category without and sql or vb code? I'm not familiar with coding. Ex: Soda Coke 105 Pespi 100 Sunkist 80 Chips Ruffles 87 Lays 75 Doritos 60 etc...

I've been searching thru all the threads and I'm getting myself confused. I'm trying to create a "week-ending" date for any returned items. My week begins on a monday and ends on a sunday. For example, an item is returned on 6/24 (wed). My return date is 6/24 and I want to create a...

I'm trying to import an Excel spreadsheet into Access using the Macro function. I keep getting an error message that "F1" field is not in the destination table. I tried deleting the columns to the right of my last populated column but still get that message. Does any one know what I can do...

I'm trying to bill our client based on widgets. They are charged x amt based on the 1st 25,000 widgets, y amt based on 25,001- 50,000, z amt based on anything over 50,000 I have around 75,000 records and would like to group them into 25,000 increments. I'm a basic access user and have no...

I created a form for data input with a date field that would automatically populate the current date when the record was being created. I used the =now() in the default value. It works fine. Now, I need to create a query to find all the records for a particular day. When I type in the date...

I'm have an Append Query that I want to append to a table in a particular sort order. When I run it as a select query, its in the correct order. Can someone help me get it appended in the correct order? I have no VB knowledge. thanks,

I created an iif stmt : iif([GrossAmt]=[NoteAmt]"Match","Research") My problem is that there is some rounding going on that creates a "Research". What can I do to eliminate the rounding? The variance is so small that I want it to show a "Match". Example: Gross Amt: $100.00 Note Amt: $100.00...

I'm not familiar with coding and hope it can be done without any. I'd like to create a Macro that exports a query into an Excel spreadsheet. This Macro needs to be run daily so the file name needs to also add a date to the file name. I tried using "Output To" but didn't know how to modify the...

I would like to input into a date field on a form, the date without the slashes (083005)mmddyy and it will automatically format with the slashes?

I'm trying to create 1 report that the end user can pick and choose which criteria they would like. There will be around 5 different fields (combo boxes, text fields, data ranges). I don't have any VB knowledge. Can it be down in a macro??