Recent content by reginab

I have a SQL Server table that contains datatypes of decimal. When I link the table in an Access database the datatype shows text instead of decimal. This is causing an issue when someone tries to enter a value with a comma. Has anyone had a similar problem. Do you know if there is a way to...

PBaldy, I solved my issue by creating 2 SQL views in SQL Server 2005. The first one creates a crosstab of all dates between the beginning date and the ending date. The second is a union query that puts all the data into one column and selects out the dates that are Saturday and Sunday. this...

Thanks PBaldy,but I really don't know how to start. I must admit I'm not a great coder. I was able to get what I needed by using IIF statements in a query but now i'm stuck because I also have to eliminate the weekends.

I need code to get an array of dates between 2 dates. For instance 2/1/2009 through 2/10/2009. I want 2/1/2009, 2/2/2009, 2/3/2009 etc. They are stored in my database as the Beginningdate and EndingDate. Can anyone help with this. Does anyone have any suggestions on how to do this?

Find and Replace Tool There is a great tool you can get that will help you with this project. I use it all the time and is recommended by Microsoft. The name of the tool is find and replace and it is shareware and I guess you can use it without paying but I would never do that because it's a...

Thank you, this looks like it might be the best option although the other one works too.

I have 2 option groups on a form. The first option group allows a user to pick from a list of reports and the second option group lets them choose between a detail or a summary report. However, there are 3 reports that have no corresponding summary reports so I'd like to turn off the summary...

Why don't you just use the query grid and design it there? Once you create the query if you need the SQL text, you can copy it and use it elsewhere.

Thank you so much. This worked great. I will certainly use this site again.

I wrote the following code and it does not work. I would like to be able to copy the contents of one table to another table with the same name but with the current date appended to it. I'm getting extremely frustrated with this and I have asked other people here and no one seems to be able to...