Recent content by DuMoore

I have an online member directory that is fed by an access 2002 database which resides on a web server. All the data is displayed correctly. However when a user clicks on an email address and the email client is launched single quotes are appended to the beginning and end of the email address...

Does anyone have any information on using Horizontal Looping for database results in Frontpage 2003? I'm having a lot of trouble finding anything outside of DreamWeaver MX information.

I agree with all of that. However can I use mod on a number that is returned from a query? As we talked about yesterday, I return the field CountOrderID from the order table sorted by Customer ID. Is this correct? Expr1: [CountOrderID] mod 10 When i run this query the CountOrderID returns...

How exactly do I use mod()? Office help has no answers, and google doesn't return anything useful.

PHV, I actually queried a different table and got the correct results. Thanks for trying to help me though.

For some reason, the query is returning the number of Products rather than the number of orders even though I am counting orderID. Any thoughts?

Yes...it worked. Thank you very much Trendsetter. I really appreciate it.

2 records for one customer, 1 for another customer. Sorry for the lack of data, this is obviously just enough to test things out.

OK. I've got the query running. I'm not sure exactly how to group by count. I've hit the Sigma Icon on the tool bar and set "total" to "count". When I run the query it returns a 1 in "CountCustomerID" field in each record.

Hey Everyone, thanks so much for your help. I'm going to try to hack through this stuff tonight. Thanks again!

I am sure about the 10th order is free. All of the products are the same price. As this is a spin-off of our normal business, we are trying to market this department very strongly. Hence, 10th product free. I do see your point however. A better way to say it is probably, $16 off your 10th...

Please help a non-technical guy out please. I have been given the task of setting up an invoicing database for a new department within my company. I am not a database person at all. I haven't used access in 3 years or so. I have gotten the database to a usable point. Here is my problem...

Thank you all for the help. The problem is getting the tables in normal form. I've slept a few times since my database theory class in college. I think I need a couple of tables...please let me know if i'm incorrect. Table 1 Customer Table(id, name, address, etc. etc.) Table 2 Product...

I would like to create an invoice entirely in excel.(Data and invoice layout) Is there a way to make each record in the table merge into the invoice and print on separate sheets? Thanks so much in advance for your input.

Is there any way that I can limit the number of people who sign up for a specific item. I have 8 products to sell at a given time, and can not sell any more than those 8. Is there a way that I can implement a script that will tell everyone that signs up after the 8th person that there are no...