Search results

Sorry for my bad English. It’s not my native language. I will try to explain again: I have updated the db to use code field. That allows to filter query to calculate total for entered date range and code. However that uses 2 queries. I need 1 query. Form frm_daterange - is used to filter...

I will have about 50 codes I enter into tbl_items, they group information. The codes will be General Ledger Account Codes. Example here: http://www.ofm.wa.gov/policy/75.40.htm Updated db example see tables: tbl_code and tbl_items Query group code total_code Report rpt_total_code - this is what...

Hi, I have a database where I need to 1. group items by group and date, 2. then calculate total. I do this using 2 queries. Since I need to create 50 groups or so that means 100 queries. :eek: I would be pleased if somebody showed me away to cut it in half or other method to do this. How...

BTW did you do those SQL statements in notepad or do you use some sort of editor? In my real database I will have different fields and I'm unsure I can make it work. Can I send you PM and ask for help to take a look at stripped version. I have also found this free tool here...

Well, I tried your database today and it works fine :confused: :confused: :confused: Then I tried it on another PC that I will try to implement it on, it gave this error: Runtime error '3075' Syntax error in date in query expression '[Item Name]='testentry 123' AND quantity=NULL AND...

The memory buttons work fine, however the multiple record insert button is not. If I type in number 5 to insert the record 5 times, I get 7 instead. If I enter 2 I get 3 etc. The concept is that by default there is 1 entered in "number record to copy" user uses the copy record button as a...

My problem is that one of fields that must be added to get total sum for a month is from another table. So in the first query I have 2 tables and relationship. I have this a field as expression and this the code for the expresion. Kaina su PVM...

Well, I created query that gets data form my table and limited criteria like this: <[forms]![daterange].[startdate] I selected to sum the field that contains the money amount. Then I used another query that sums up the money field from previous query. Do you mean I should not use cascading...

Thanks, I used the subreport feature.

Big thanks, just checked my post and I'm very pleased with the solution. Very detailed explanation. Would it be possible to change the "plus" button color to green to show that it has information stored in memory? Also I have to add multiple same records to the table, I think that a user...

Hi, please see my attached database. rename to rar I have table tbl_items where I enter items and another table tbl_poppular for popular entries I would like to be able to click a button see tbl_items form and copy the selected value from list box to text field. Also I would like to make...

anyone, I still need help?

I have a report that is made from data in 2 tables. My date format is Y-M-D One table has income data the other expenses. I made queries from these two tables with sums of each transaction. I have union query: Select Data From kio_group UNION Select Data From kpo_group; Then I made a...

Hi, I'm trying to make a running sum on a report that knows about previous rows. For example if I have a long list a few months of data, if I filter to show only the current month it needs to start from first record to the current month, not from zero. I tried Running Sum property of a...

I have table tbl_accountnumber it stores bank account numbers I have two reports that print invoices one for corporate customers another retail. The corporate customers report works fine as it pulls data from tbl_accountnumber trough relationship with bank transaction table where bank...

Re: lookup question ("lookup column" or "type in the values that I want") Thanks for your replies. I'll keep using the lookup tables :) BTW I have another question. Almost all my lookup tables contain date field and with main table are used to generate a report for certain document they are...

So I can use all A...Z characters and _ to form my database field and object names right?

Re: lookup question ("lookup column" or "type in the values that I want") In my case I have one lookup table that holds data and many (4) table that sore data you called object. Is this normal. Wont I have problems like data pulled twice in reports, or unable to make the reports etc. etc. My...

Re: lookup question ("lookup column" or "type in the values that I want") Yes you are correct English is not my native language. Sorry if don't understand my problem. I'll try to explain: I've been using lookups like in my attachment, one table with lookup data connected to another that uses...

The problem is that access names them differently than it did before, naming is done in unfriendly fashion - it's harder to read them then proper naming done before. I suspect Service pack 1 for office 2007 . BTW you did not answer is it safe to rename my ID fields?