Search results for query: *

It works! I'll have to keep that for future reference. I thought it was going to be much more complicated. Thanks for you help.

I went into the SQL view of the query and entered the info but when I tried to run it, I received an message box "Select Data Source". I'm not sure what to enter.

I dont know SQL so I would need step by step instructions... Table: Food Field1: Snacks Field2: Brand Field3: Volume thanks!

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

That worked great but now I'm running into another problem. When I get to the end of the month, I would like the week end date to be the month end date. ex: 6/30/09 week end date should be 6/30/09 and not 7/05/09.

WooHoo!! It worked!!! Thank you!!! I was missing the 1.

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 did select all the blank columns to the right. The macro worked for the very first import. I will be importing the file weekly. When I tried to import again, it asked for F1 field. I added F1 then it would keep asking for the next..F2 etc. I'm at F17 and its saying to add F18. Any...

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

ohh, okay, i got it thanks everybody for your help!!!

Sorry, I'm a bit confused its probably my fault for not explaining correctly. I want to group my 100,000 records into 4 groups of 25,000. Would it be easier to add a counter and then i can choose based on the counter? I dont know how to create a counter. I tried using the method in FAQ but...

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

Thank you!! It works! Wow..what a simple little change and it makes all the difference in the world!

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

it is and isnt a one time thing. i have a list of records that i need to rank based on a priority calculation of various different fields. Currently when i run the query which includes my different sorting fields, it sorts in the correct order. I then need to add a ranking to each record based...

thanks, if i create a make table query and insert a column for the order, how do i create the "order" field as a number field opposed to a text?

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,

Thank you! Thank you! Thank you! works perfect!!

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

Thanks, Is there a way to have it automated in a macro or a button?