Search results for query: *

JamesLean, You are right. Unfortunately, I'm working off a db that was created and is maintained by someone else.

Thanks. I thought that might be the case

I just discovered to records in my sql db that are duplicates. I need to delete them, but apparently have the wrong syntax. Can someone help? The records look like the following site overp 003 1

Thanks for the help. I'm working on it and will let you know.

Free, Paid and reduced are just numbers--types of meals. I'd be pulling them all at the same time. The meal types are breakfast and lunch. The equiv and s equiv are related types of meals, but are not broken down into breakfast and lunch. I'm thinking because they are not broken down, I...

Hey. Thanks for the help. Not sure what to tell you except that it would be helpful to be able to access it all from the same table. The report I need to generate will look something like follows grouped by date. Hopefully this helps. b free|B Paid|B red.|l free|l paid|l red.|equiv|sequiv

MeanGreen, Thanks for the input. I think it would help if I could put them in the same table. Is the following how you would do it though? The last two columns are the ones not broken out by meal type date meal_type free reduced paid equiv sequiv 1/1/03 breakfast 378...

MeanGreen, Thanks for the input. I think it would help if I could put them in the same table. Is the following how you would do it though? The last two columns are the ones not broken out by meal type date meal_type free reduced paid equiv sequiv 1/1/03 breakfast 378...

I need to create a table in a db for historical data. Most of this data is broken up by meal type so I would have the following fields; date,meal type, free, reduced, paid. However, I have two other numbers that are not broken down by meal type. Is it better to create a separate table for...

Thanks for all your help. I knew there had to be any easier way.

Is There a way to easily determine the last day of the month?

mbarron, thanks for the info. This is assuming that I have a specific date range. What if I want the date where you have 2002,8,1 to be dynamic and change with each year. I need to determine if the current month is in the fall. If it is, then the year for the fall sem is the current year...

I'm trying to create a formuala that would determine the current school year which runs from August to May. Right now, I have it set up as a formula to determine the fall, and another to determine the spring, however, it isn't working. Any ideas? This is what I have right now If...

I have a fairly complicated Excel spreadsheet that I need to move to Crystal Reports so info is recieved dynamically from a db. The following is a basic idea of what it needs to look like. The easy part is grouping by month and year to get the actuals. Is there a way to add the forecast info...

I need to group my recordset by year(date). I created a formula to isolate the year, but when I group based on that formula, it changes my date to a number with a decimal. Is there a better way to do this or to fix my problem?

rac2, Thanks. It didn't quite work right, but I think I have it now.

Okay, I did manage to get the following to work. Is there a way to write it so that when the recordset comes up, it doesn't list two site colums though? Select * from (Select schools.site, schools.area, schcat, schoolName, sum(d_tot_meals) as 'total meals' From schools, tbl_scanned_sales...

I have two separate queries that I need to somehow combine into one recordset. I actually need to sum the total meals and the total working hours. however, the first query yields 37 records while the other only yields 2. How can I combine the two so that I get one recordset with the total...

The following code is used to pass from and to dates to Crystal Reports through an ASP page. Can anyone tell me if there is a way to modify this or my Crystal report so that I can pass a text string instead of a date? set session("f")=session("orpt").formulafields set...

Tarwn, Thanks for your post. They will give me an account and password for connection. They even have an asp app that they had running on a previous server until they moved to a new server, but now they are saying we just need to create our own since they don't want us having that kind of...