Search results

There should be a group you use for each letter rightto determine who gets one correct?? Just put it in the group header for that group.

That means you have nulls in your date text column. In that case do this CDATE(NZ(yourdate,0)) for the expression field in the query.

It doesn't have to be converted first, you can have the expression field on it's own and then filter it by typing into the criteria between now() -25 and now() for the field.

Just type what I mentioned into a field in a query that has your date field.

Create a column called Count and give it a value of 1. Then turn grouping on, group by your calculated age column and summarize by the count column. This will give you the total count of members for each age group.

Or you could have a hidden calculated field with this function in it that calculates at the record level as a running sum and pull that out onto your main form, making the calculation real time per record instead of calculating everything in the entire recordset over everytime you make a change.

Just do a CDATE(yourdatefield) and then filter this by your range.

Yeah something like SELECT [IKON WE061109].<fieldName> as Field1 FROM [IKON WE061109] UNION SELECT [Manual WE061109].<fieldName> as Field1 FROM [Manual WE061109]; would work.

Use: SERVER=<IPADDRESS>\<ServerName>,1433

One of the versions probably has a toolbar that shouldn't be open. It's trying to print the form instead of the report.

Or set the default value of the field in the table to zero. This is the preferred method.

or you could do it manually.

Another way to do this that is very easy is just create yourself another table called expand with one field called "expandnumber". In this table give this field three values, 1,2,3. Create a query with both this table and your other data table in it. Don't link the tables. This will create a...

Use a query with a calculated field in it and your string. In the calculated field, type something like this IIF(instr(yourstringfield,"string") <> 0 or instr(yourstringfield,"string") <>0, 1,0) Then in the criteria for this field, use 0. The "string" is the search string in your field...

I've handled this by having a separate table for "starting" numbers. Then just write code everytime you add a new invoice (through clicking the add button on your form) to go to this table, grab the string, add 1 to it, use this for your key, then replace the string in the starting numbers...

DoCmd.OutputTo acOutputQuery, "qryname", acFormatXLS, "filename", True

Any nulls in your data? wrap an NZ(data,0) around all of your components.

If you're trying to run an update on a text field to convert your data to date/time you can't do that. You are not allowed to change a field's datatype with an update query. What are you trying to use this information for? What you can do is create an expression field in an existing query that...

Format(CDate(Datestring),"dd/mm/yyyy") where Datestring is the string coming in from your data. If it is already in date time format, then just use: Format(Date,"dd/mm/yyyy")

Cdate does precisely that. Try it.