Search results for query: *

Hi, I'm working on an application with VB interface and an Access backend. I need a way to let userschange and/or delete certain dates of they so desire. While it will change the dates just fine, if I try to delete a date by setting its value to null, it throws an error. Is there another way...

Hi, I have a date picker, dtpickerBdate with its checked value set to true. When the date has been entered into the database, it shows the correct birthdate. However, when there is not value in the database, it shows a default date of 2000-01-01. I tried changing the value to null in the...

Hi, I've been working on a reoport where the records will be grouped by the field intAverageExp. For the purpose of this report only, I'd like to get crystal to ignore the values after the decimal point and treat this as a whole number. Thus records with a value of 3.1, 3.2, etc would all be...

Hi! I've been working on a program that will help us keep track of our subscribers. Among other things, a user should be able to find a subscribers Zone number by entering their community name. This works for most part, except if the community name has an apostrophe in it(and you wouldnt belive...

hi, Heres a brief overview on what im trying to do: We have a databse with cusotmer information, including their address. we'd like to group the addresses by region, so that all addresses in cities A,B and C go in the South east region, cities D,E,F, go in the southwest, etc. There are about 22...

I've just been given a table containing customer information by region and age. Basically, each row contains the name of the region, and then the number of customers in that region aged 18 years, the number aged 19 years, and so on till 65. However, the client has decided that they don't need...

Hi, I was wonderning if anyone could help me out with a problem I'm having. I've got a database which contains, among other information, the date of registration for clients. These dates are organised in a dd/mm/yyyy format. Is there anyway to extract just the year using a query? I'd like to...

Hi, I was wondering if there is any way to not display a column of a table if the total for that column is zero? For example, if I had the following table: Col1 Col2 Col3 Col4 Row1 1 0 2 3 Row2 2 0 4 2 Row3 1 0 2 1 Total 4 0...

Hi, Let me start with what I'm trying to do. I'm pulling most of my information from a user information table containing, among other things, the users age group, location and sex. I've got my report grouped first by location and then by age group. What I'd like to be able to do is...

Hi, I was wondering if there is any way to 'skip over' a column of a table and now display it if the total for that column is zero? For example, if I had the following table: Col1 Col2 Col3 Col4 Row1 1 0 2 3 Row2 2 0 4 2 Row3 1 0 2 1...