Search results

Thanks for your reply, but i figure out how to do it thanks anyway

Hello All, How do i make a query that returns the top 50 records from a table? Thanks For Your Help JG

I tried something similar to what you are doing and found it impossible. i wanted to bring up a daily schedule by clicking on a specific day field in the calendar. exmpl, if you click on March 3rd in brings up all the appointments for march 3rd. i even had some programmers on our IT department...

Yeah, that's what i ended up doing, thanks for all of your help anyway JG

Jack, that's exactly what i was trying to do, however, when I'm getting a "#Name?" Error. Let me try to be a bit more specific. Querie 1__C12 Totals=sumoftotal Querie 2__C10 Totals=sumoftotal Querie 3__C01 Totals=sumoftotal Now, my form, using a list box, looks up the values of this 3...

Hello All, I have a Form that shows the totals of 5 different queries using a list box to look up the value in the queiries. I want to now add up the values inside that form. I have done this in the past but i can't remember how. If anyone has any Ideas, Please HELP! Thanks JG

Thanks to both of you for responding, the query worked perfectly. I'll give the code a try tomorrow, i been trying to teach myself VBA and this might be a good one to start with. thanks again JG

I tried your SQL but it didn't work, got an error meassage of "invalid procedure code" Let me give you a better idea of what I am working with, My table call NESKUS has over 20000 records, each record has a slot assign to it. (exmp of slot: R 52911, R 53011...) I need my query to look at my...

Hello All I need to run a query that looks at the values on a table and randomly selects 87 records. Thanks for your help Jaime

Robyn, you should be able to drop in your "Yes" and "no" fields and count them in the same query. however, if i remember correctly (i haven't played with yes and no sums in a while) when you run your second query to sum of what you counted in your "yes" and "No" fields they are going to come up...

try dropping two columns on the query, Exmpl: Field: _____ ratings______ratings Table: Total:_____Groupby______Count this will group by rating and tell you how many times that rating came up. let me know if you need any more help JG

this always works for me >=[start date] and <=[End date]

PDX_Man Thanks, It worked Out Great!

I'm not sure of what you are really trying to do but it sounds like you are "grouping" the items in your query, if this is the case the solution is just to click your "Totals" icon on your tool bar. However, a simple way to leave your calculations in the query (in case you are trying to sum...

I'm trying run a query that would assign a value to a record in a new column. I have a column call Row, which shows the row where my item is located. example Item Row 1111 CA 2222 GA 3333 SA I want my new column to look at my "ROW" column and assign a value depending on...

Thanks a lot guys! Rich, you pointed me in the direction i wanted to go, I ended up running two different queries to get the result: the first query assigns the date i want to see in the expression Date:[todays date], and then i ran a seperate query with the actual calculation, MinShipDate...

Yeah, i tried all those and it didnt work, i keep getting an error meassage i might be putting the brackets in the wrong places MinShipDate:([min #]+[date()]+2) what's the proper way to write that expression??? where i will always get to type in the date???? Thanks Again

Hello, I want to run a query that looks at the colum to the left (slot #) and if the slot number ends in a 1,2,3,4,5,6,7,8 or 9 it will assign a number to that record. and if the slot number ends in "0" it will assign another number. example Slot Number 122522 would = 14 and...

Hello, I'm building a query that will tell me the last day i can ship an item before its to old. the simple formula were using in excell is (#of days + Todays Date + 2). how can i build a query that will ask me for todays date every time i run it. in other words i want to enter "todays date"...

Put a question mark on the criteria of the column where the question mark is found. it will return all records that have question marks. you can also try the ?***** funtion in the criteria