Search results for query: *

THANK YOU SO MUCH!

ok, so if i have Access 2002, .mde won't work unless i purchase the Runtime version of Access 2002? what other option(s) do i have to have users run .mde without having Access?

Ok, i found this article http://www.tek-tips.com/faqs.cfm?fid=91 i thought the idea for .mde was also for users without Access to use it. sooo, what option do i have for the users? is there some other tool to utilize a .mde file?

Hello, I have not come acrossed this problem ... I created a .mde from an Access 2002 file so that users without MS Access can use it. Isn't that what Runtime .mde is for?? I'm new to using .mde files ... please advise.

you can set a look-up for specific users from LM

syntax ... makes a difference for sure :D

thank you! this worked: Formula = minimum({?Invoice Date Range})" thru " maximum({?Invoice Date Range}) Check Errors said No Errors. Applied to report and it's all working! Thanks again!

i did this formula = minimum{?Invoice Date Range} and when i do an error check it gets an error

i did this in the Formula and it's not working. so I really don't know how to apply and where to make this work. formula = minimum{?Invoice Date Range} "& " maximum{?Invoice Date Range} or formula = minimum{?Invoice Date Range}

{AR_InvoiceHistoryHeader.InvoiceDate} = {?Invoice Date Range} i don't get where and how to use / apply minimum{?Invoice Date Range}?

yes, but how do you mean? where and how? on the Select Expert? or just put minimum(?Invoice Date Range) and maximum (?Invoice Date Range)? In Select Expert I have InvoiceDate equal to {?Invoice Date Range} which prompts the user to enter the Start and End dates.

Hello, I am using CRW v10. I cannot figure out how to show the first and last date of the date range the user inputs to show on the report. The report needs to show the range the data is for based on what the user enters in the date range parameter prompt. thank you!

no, it's the new Mac OS X intel duo, etc ... (i know they can "boot" into a Windows OS) but that does not help them in staying on Mac OS and use the Mac database.

i should note that the MS Access query is used in MS Excel by the team. they Refresh (MS Query External Link) to pull the updated monthly data into Excel. In this sheet there are other formula columns and where the Production Manager then decides to overwrite what to order, etc ... in these...

MichaelRed, thanks ... basically for someone like myself that really do not know how to use what you have wrote is where / what I don't understand :-( Ok, the make-table query that creates the table "12MonthBookingsDetails" which is one of the names in the query listed originally: SELECT...

MichaelRed, thanks ... basically for someone like myself that really do not know how to use what you have wrote is where / what I don't understand :-( Ok, the make-table query that creates the table "12MonthBookingsDetails" which is one of the names in the query listed originally: [code]...

Hi Duane, here's the query datasheet view of the SQL query noted at the beginning. this is the result (i only pasted the date columns as the other fields are fields for the items). Mar-07 Apr-07 May-07 Jun-07 Jul-07 Aug-07 Sep-07 Oct-07 Nov-07 Dec-07 Jan-08 Feb-08 13 8 10 6 5 6 5 5 2 11 2 4...

MichaelRed, i do not understand ... each month changes but always showing 12 months. This month it shows Apr07 May07 ... Feb08 Mar08 next month i would like it to automatically delete Apr07 and add Apr08 after Mar08.

thanks. not sure how the Linux would work on MAC? FoxPro is the db on MAC.

ok, i am a bit confused on the month naming. it needs to show the management team Mar08, etc ... and not Mtn1, etc ... as it doesn't really tell them anything WITHOUT having them THINK what Mtn1 could be. the query actually has the date range using the Between and therefore has no form to enter...