Recent content by mateogp

Hey All, I have a question regarding referencing a form using dates between. Currently I have it setup as: Between [Start Date] And [End Date] on the query. I want to reference a form, which i figured would be like this Between [Forms]![frmSBReports]![txtStartDate] And...

You can tell im a bit unexperienced! How do I post an SQL String? Mateo

Hey Pat, I posted the file for you. (to big to post this file as an attachment) http://www.blacktietuxes.com/gr/GlobalRegistry.zip Thanks! Mateo

Hey Pat, Still having some trouble... I have my query setup like this: GRID Weekending Type Style Quantity (N/A) Group By Group By Group By SUM Its still not totaling correctly. Right now its going Type Style...

Pat, Thanks for your help! I honestly didnt mean to call you Phil. I think I was thinking of the Saturday Night Live comedian. Once again, thanks! Mateo

Hey Phil, Thanks for your nudge in the right direction. I've actully never created a totals query, kinda was forced into access as a neccessity so i've been learning as i go. How do you create a totals query? Is Select Type, Style, Weekending, Sum(Quantity) As SumQuantity a code of some...

Hello, I have a table setup as follows: Type, Style, Quantity, Weekending Type would consist of: Coat/Vest/Tie/Pants/Shirt/Shoes Style consists of probably about 100 different codes for each type Quantity: Quantity of each style ordered. Weekending: The weekend each order is due for I need to...

Heya All, I need some help. I need to beable to calculate percentage based on the number of records that store a certain value. Say a marketing lead is "Yellow Pages". I need to beablet to find all the instances of the yellow pages, and divide it by the total number of records to get a...

I tried using a query to view records using <Now or however it goes. It worked, but due to being a live database it seemed to take more time than what would be considered acceptable. Since im not an expert at Access, I dont know if its with in my knowledge to normalize a database. My company...

This is what im looking for also, is it possible? Mateo

figured it out! Figured it out myself. Thanks! In case some one else is trying to do this, just insert: (fieldname).SetFocus into the OnChange. Thanks. Mateo

Maybe im looking up the wrong term... I want to autoforward to the next blank... Say I click a drop down box, after i select, i want to be able to automatically jump to the next field. how do you do this? Thanks in advance for any assistance you may render! Mateo

Hey all, Maybe im just having a brain fart, but I cant get this method to work. There are two forms, the first records Two Names, The Bride and The groom along with their wedding date and where they registered. After all the data is entered on the first form, the first form is closed, and the...

Hey All, This may have been covered already, and if it was I appologize. Searched for it but couldnt find it. Any how, I have a large table of records (problem is its growing). It lists customers and dates. My table has way to many records, so i need to condense it a little bit. What i...

Heya, In your opinion, what is the best Microsoft Access 03 Reference book for learning? Mateo