Search results

DateSerial is wonderfully variable. ? #2024-07-30#, DateSerial(2024, 7 + 35, 30 - 1), DateSerial(2024 + 3, 7 - 1, 30 - 1) 30.07.2024 29.06.2027 29.06.2027

I can't open your database, I use Acc2010. So just the pictures: A table representation as you requested is not the usual, there are no standard means for this, if you really want to solve it exactly like that, it will be incredibly complex. Maybe you can then create your report output using...

SELECT R.TotalRevenue, E.TotalExpenditure, R.TotalRevenue - E.TotalExpenditure AS Balance FROM ( SELECT SUM(Revenue_Value) AS TotalRevenue FROM RevenueTable ) AS R, ( SELECT SUM(Expenditure_Value) AS TotalExpenditure FROM...

amount *1 versus "Amount Not Found" In one case, the result is a number with decimal places (double), the other is visible text. The result is text as the data type for the calculated field. It may be sufficient to look at, but if you want to do further mathematical calculations with it or...

In keeping with the database, it would be best to resolve these if-then orgies by creating an additional table for dyty_types with a factor included and linking it to the data table in a query. This design is then simpler, clearer, easier to maintain and expandable.

Whenever you filter, you can expect that the filtering will be thorough and will not produce any results, meaning you will get an empty recordset. Therefore, you have to check as a precaution. If Not rs.EOF if rs("fname") = "cccc" then....else.... End If...

sSQL = "INSERT INTO co_comprobantes (lo_asiento_id, en_numero_registro, tx_cuenta, fe_fecha," & _ " tx_concepto, tx_operacion, mo_debe, mo_haber)" & _ " SELECT F1, F2, F3, Format(F4, '00/00/0000'), F5, F6," & _ " IIF(F6='D', F7/100, 0) AS monDebe, IIF(F6='D', 0, F7/100)...

Isolating the values is a task for regular expressions.

A query returns a recordset (an object with rows and columns, even with one row and one column this is something other than a single value), but a control only accepts a single value. The simplest solution here would be to use a domain aggregate function, where the query is packed into a...

Correct. But my suggestion was also to use this query as a record source for a subreport. For the report with exactly one record, you can place the assigned controls anywhere you want and garnish them with some text. You actually love bound forms and reports, and I don't like constant DLookup fire.

Thanks for the addition.

I can't help you there. Named ranges are Excel objects and are probably not taken into account in import routines of other programs (I think). TransferSpreadsheet uses the same accesses internally as Jet (Access SQL) and shows the same behavior. I like to use something like this myself: SELECT...

3 results in one calculation, could be inserted via subreport. SELECT COUNT(*) AS TotalRecords, SUM(File_Return_Date > 0) * -1 AS FilesReturned, SUM(File_Return_Date Is NULL) * -1 AS FilesNotReturned FROM YourTable WHERE File_Return_Date BETWEEN...

If this is possible for you and others, the contents of records can also be removed without using forms. If it wasn't you, it was a third party. The best, because comprehensive, protection would be to add it at table level, @The_Doc_Man has already described this. In addition, you would then...

If several users rush to work on the same record and then work on it practically at the same time, then you should first check your work organization. If there is a pile of tasks, not every user has to reach for the same task, but as a first step the developer can ensure that the closest record...

The error is not in the suggestion, but in your implementation.

WHERE Grade = Forms.A.Combo1 OR Forms.A.Combo1 Is Null The records displayed are those where the filter criterion evaluates to True. I answer in SQL because a query is passed to the DB machine as SQL and executed there as such.

What would change in the view if you were dealing with 4 or 5 units instead of 2? One approach would be to differentiate the application into input, storage + processing and output. The preferred unit would then be derived from the predominant processing, so that few conversions are necessary...

No. A table must be declared (in the FROM part) before fields from it can be used in the query.

Do you know which database management system the tables with data are in, or are you already rowing in the fog?