Search results for query: *

windows 2000/MySql 4.1 I have a table that has a couple varchar fields set to default values. When I run an insert statement the default value fields fill as expected. When I use an INFILE statement to add data to the table the fields set to default values don't fill properly. Any ideas how I...

MySql 4.1/ Windows Server 2000 How can I set a field to a defualt value of spaces? For example I need field "def_spc" to equal 8 spaces. This is just a filler field and it would never change for any record. Also, what's the best data type for this type of field? Thanks

I am receiving the error "Item not found in this collection" The parameters I am attempting to pass to this code are in 2 text boxes of the form(start date & end date). The form is open when I try to run the module & I am using Access 2000. The code fails on this line: qdf.Parameters(1) =...

I am using Access 2000 with an Access db,forms,querys,modules. I have a command button on a form that executes VB code/module. The form also has 2 text boxes to use as date parameters(begin & end date) in the query. How do I get those parameters into the VB code? I get the error "Run time...

I have crosstab query that uses a where clause to limit the data retrieved. Is there a way to add an additional column to the crosstab that isn't limited by the where clause? Ideally I would like the results of this query as a column in the main query: 'select accstore.store ,count(date) from...

CR 10 & MySQL 4 I have a DB with new data everyday except there is no data on saturdays. There are no nulls in my date field, just not a record for any date that falls on a saturday. how can I write a formula that pulls data from the 9th day of every month and if the 9th falls on a saturday...

Using MySQL 4 I am trying to query all duplicate occurences of an account # (acct)in my DB. This is the command I have so far: SELECT cd71.amt ,cd71.acct ,cd71.date, store from cd71 where cd71.acct=cd71.acct and cd71.date >'2004-09-20' and cd71.tran ='253' and cd71.amt >1000 group by...

Using CR 10 & MySQL. Currently I have a group that is sorted on a formula (@acct). @acct has numerous if statements to group on. e.g. else if {trial_bal.acct} in [4103 to 4155] then "Late Charge Income-Retail Lines of Credit" The problem is every so often I need a sub-total, for example...

I have read many previous posts but none seem to address the problem of getting yesterday's (or last years) running totals. I am using CR 10 & MySql. The data looks like this: ACCT AMT DATE 1000 53 08/01/2004 1200 11 08/01/2004 1000 43 08/02/2004 2000 56 08/01/2004 2000 33...

I have a database that has about 10 variables for each month of the year. i.e. each row is a month. I am trying to display the figures from each variable, but I also need to add some formulas that calculate a difference between this months variable1 and last months variable1. I want the...