Search results for query: *

here is the table: CREATE TABLE `pymnts` ( `Front_Filename` varchar(58) default NULL, `Account` varchar(17) default NULL, `SizeFront` varchar(100) default NULL, `TranCode` varchar(8) default NULL, `rec_leng` varchar(45) default '00512', `rec_type` varchar(45) NOT NULL default 'M000'...

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...

I am creating an extract for a mainframe application that requires fillers between certain fields. I wanted to just specify the field "def_spc" when I needed a 8 space filler.

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

Awesome! Too much back and forth testing and i forgot to put the parameter in the query back to : Between [Forms]![fdr_batch]![startdate] And [Forms]![fdr_batch]![enddate] Instead of a "hard" parameter. Thanks so much for taking the time troubleshoot w/ me & for the debugging tip.

message box pops & says 0.

The name of the form is "fdr_batch". The name of the first text box is "startdate" & the second is "enddate".

Tried that and I get the same error message-"item not found in this collection" Any other things I should check? Thanks!

I don't see how that can be incorperated into my code. Should I just add this code? Where at? Sorry I am pretty new to this. I am not sure if the textboxes are already referenced. Thanks 4 your patience

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) =...

Thanks. I believe that cleared up that problem. Now I get the error "Run-Time error 3421: Data Type conversion error". Any clues to what causes this error? Thanks again for working with me.

I get the same error as mentioned above. Does this code need to be inserted in a specific spot? Thanks

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...

Didn't seem to work. That command returned 288 rows where is my original command returned 2 (should have been 4 rows). Not too sure what happenend but thanks for the effort.

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...

I guess I don't follow you. If I create another group it prints a totals line for each line in the first group. I just want one line after group one to show a subtotal.

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...

The rate for acct is 1000-9999. The report is a income statement. Which shows totals from groups of accts(1000-1999) and also can just be the total from one specific account(5500). Here is the format: today(date) yesterday(date) variance Operating Expense Salaries (acct...