Search results for query: *

Bear with me, I am not a network guy. I did a website for a client and all went well until I changed the nameservers. Apparently they failed to tell me that the old dns nameservers directed them into their remote login to access their VPN and email server. How do I give them access back to...

Makes good sense but the update already worked for me. This is resolved. Thanks to all.

I have made changes using the find/replace fucntion. I removed the word "the" from all fields and replace it with nothing. This left a space at the beginning of many fields. I need to remove the space at the beginning of the field without affecting any other in the field. Thanks

Can you suggest the sql to perform this function remembering that 2 of the fields should match and 1 field should be a partial match? Thnanks

I would like to find duplicate records matching 2 fields exactly and "any part of field" on the 3rd field. An example: In a 30000 record databse I would like to output duplicate addresses [house number] and [street name] where the last names partially match. 123 Main St - Joe Smith 123 Main St...

Thanks; For my needs, I don't believe that would work since I am incorporating it in asp. I would need to do it at a table level or in asp. I was trying the easy way first. RZ

I have a field called [employesID] If the employee # is "316", is it possible to set up the [employeePhoto]field to have a defaults of: [employeeid].jpg Thanks in advance. RZ

I would like the qty to be added based on the desc field. 3 O2 Bottles [perhaps a drop down box with the individual serial #'s here] I simply want to combine the total o2 bottles, but keep it's individuality for maintainenece purposes based on serial #.

OK...can I somehow sum on the quantity field where the decriptions field matches even thouhgh the serial number field is different. I would like to display the individual serial numbers as well on the same form/report. Thanks

Let me clarify. This would be a report. I would like to sum on the QTY field. I also would like a drop down box to appear only when the serial number field is not null for that record. I can change to a form if necessary. RZ

I have the following records: 1 O2 Bottle Serial # 101 1 O2 Bottle Serial # 102 1 O2 Bottle Serial # 103 ------------------------- I would like the report to display the sum of the bottles (3) and have a drop down box show the serial #'s next to the description. I can't sum with the...

I use conditional formatting to change the color of a font. The condition is field value is <= date(). It works well at home on my XP system, but randomly works at the office on win98 using office 2K. Does anyone know of any issues or patches? Can't find them on MS support. Thanks

I have a form with a subform. The main form is simply name, address...called [dataentryF] The subform is the amount the person in the main for donated with date of donation. [f:donationsSeq] They are linked on a field called &quot;seq&quot;. I would like to have a report display (on exit)...

Well Goloms code starts off like: SELECT Streets.seq, Streets.street_Nam, Streets.street_num FROM Streets AS S LEFT JOIN Donations AS D ON S.SEQ = D.seq GROUP BY Streets.street_Nam, S.SEQ, Streets_num HAVING (((Year(Max(Donations.DateEntered)))<Year(Date()))) OR (((Max(Donations.DateEntered))...

NO difference in results. Still shows only 2002. Thanks. RZ

dhookum By changing your code to mine, gives me this: SELECT Streets.OCCUPANT, Streets.STREET_NAM, Streets.STREET_NUM, Streets.SEQ, Max(Donations.DateEntered) AS LastDonationDate, Donations.Amount FROM Streets INNER JOIN Donations ON Streets.SEQ = Donations.seq GROUP BY Streets.OCCUPANT...

I have 2 tables. [Streets] and [donations]. The 2 are linked by a common field. I simply need to build a query for those who have not donated this year. I can't build a query asking for &quot;is null&quot; on the amount field because it will pull out previous years record. I need to exclude...

I have a table with 2 fields: DateEntered and Amount. Simply enough I want to create a report based on the total amount per month and have it display: Jan $total of [amount] Feb $total of [amount] March $total of [amount] etc.... Current Year Total [total of column] I would also like to show...

Got it: Year([Fieldname])=Year(Now())

I have a simple query that returns 2 fields&quot; DateEntered Amount I am trying to build a query where it returns just the current years records. I have tried Where Year(Date()) as the criteria, but it doesn't list all the records for the year and instead returns 1 record with the current date...