Search results

table = cash disbursment id = auto number CAN NOT GROUP ON FIELDS SELECTED WITH '*'. I want to get a running total out of subtotal, but I keep getting an error when I try to run it, the error: SELECT [cash disbursment].id AS idalias, Sum([cash disbursment].SubTotal) AS SumOfSubTotal...

Thank you for your response. It is the most recently entered. with Now() and dMax I can find the last record, but can I get one of the fields of that last record and copy it to another field? if yes, can you provide me with an example. thank you

Is there a way of making a query to go to the last record of a table and get data from a field and copy it to a different field in a form??? All help will be appreciated.

can you give me an example on how to use the runsum function and where to put it. thanks

I have a form that has a previousBalance, subtotal and a total text boxes linked to a table. the previousbalance has to be yesterday's subtotal when I Input a new record, and todays subtotal will be tomorrows previousbalance. Is there a way to do that?? all help will be appreciated. thanks

the SQL that you gave me does not give me anything. what I had gave me the right result for the date field, but what I dont know is what to put in the criteria of the other fields, because if I use between it gives me an error, something like "expression is typed incorrectly or is to complex to...

yes, the problem was the date(), but I have the error 'Runtime error 3022' which happens when I try to save a record with a field that does not accept duplicates. How can I show a message box instead of that error? I need that field to be unique. thanks for the help!!!

SELECT [Cash Disbursment].Date, [Cash Disbursment].PreviousBalance, [Cash Disbursment].MoneyOrder, [Cash Disbursment].CashIn, [Cash Disbursment].TellerDrawer, [Cash Disbursment].CashOut, [Cash Disbursment].ATMIn, [Cash Disbursment].ATMOut, [Cash Disbursment].LooseCoin, [Cash Disbursment].Totals...

Thank you David, the snapshot viewer works perfect. thanks again.

Yes, I think is the date field. I am using Date(), I'll try that!

Yes, the Dte field defined in the table as a Date/Time data type, the query result for the dte field comes out correct, but the rest of the data comes out incorrect. For the date criteria Im using the BETWEEN and AND, but for the other criteria which is acquired from the same form comes out...

when navigating through records, it automatically creates a new record and saves it in the table. Help!!!!

.Date is a field if its an Access reserved word I changed it but Im having the same problems. here is the sql.. SELECT [Cash Disbursment].Dte, [Cash Disbursment].PreviousBalance, [Cash Disbursment].MoneyOrder, [Cash Disbursment].CashIn, [Cash Disbursment].TellerDrawer, [Cash...

SELECT [Cash Disbursment].Date, [Cash Disbursment].PreviousBalance, [Cash Disbursment].MoneyOrder, [Cash Disbursment].CashIn, [Cash Disbursment].TellerDrawer, [Cash Disbursment].CashOut, [Cash Disbursment].ATMIn, [Cash Disbursment].ATMOut, [Cash Disbursment].LooseCoin, [Cash Disbursment].Totals...

the form should be design to navigate through records, add, edit, and delete records, so the AllowAdditions and the navigation should be set to Yes. Is there a way to have the form do that without saving the last record too many different times if there is no index on the table that the form is...

i have a form with textboxes that are linked to a table. my problem is that when I click on the previous record and when I get out of the form it automatically saves the record to the table. if I put the date as the index key it will give me an error that it cannot save changes that I made...

I created a report from a query, I need that report to be exported somewhere where users would not need Access to view report. If possible to keep all formats of report. all help will be appreciated

I was also using this in the criteria between [forms]![queryform]![fromdte] and forms]![queryform]![todte] it only worked on the date field because it was sorted by date, for the other fields it did not work.

here is what I have in criteria for date >=[forms]![queryform]![fromdte]<=[forms]![queryform]![todte]

I have a form from where I get the criteria to a query. two textboxes will be dates (ex. 12/12/01). one for the beggining date of the query and the other one for the end date of the query. I also have more textboxes that also affect the query result, but that is currency. my problem is that when...