Queries

Crosstab queries, <> and null values
Edwinah63 wrote: Hi everyone, I have a crosstab query attached to a graph on a report. It shows quantity of widgets produced by each employee for a specified period. The client wants all months shown regardless of zero widgets. If I just use the Access graph wizard, it only shows the months wh... 21 May 2010 09:30

Crosstab queries, <> and null values
Hi everyone, I have a crosstab query attached to a graph on a report. It shows quantity of widgets produced by each employee for a specified period. The client wants all months shown regardless of zero widgets. If I just use the Access graph wizard, it only shows the months when there are some values not all mo... 21 May 2010 03:00

#Error
Hello, I am using Access 2003 I have a query where I add three fields together into a new field in the same query, the problem is if one of the three fields don't have an amount I get this #Error. Does anyone knows how to deal with this. Thank you in advance. ... 21 May 2010 22:44

Querying 2 field unless duplicated
New at this, so please bear with me: I am looking to merge 2 fields unless duplicated. The fields are in the same row in the same table Female Surname & Male Surname and I have no problem when the Surnames are different, I think.. (seems a tad convoluted). e.g., FemaleSurname and MaleSurname as per below Co... 21 May 2010 09:30

Multiple Totals Columns in a Pivot Table
Hi. I've built a pivot table, and get totals values displayed as expected. In this case, it's a count of records. But I also want to see values for several expressions involving select categories. For example: Status ______ Location ... 20 May 2010 20:31

Descision based on a query
Hello, I'm hoping this should be easy - I just can't seem to find the answer. I'm guessing my syntax is wrong but I can not figure it out. I am making a Db for work to keep track of Tasks and Performance. The 2 main functions I am trying to keep track of is total hours signed in and how long it takes to complete ... 26 May 2010 09:09

Left join in query
I have a query set up with a one-to-many left join on two tables in order to pull all records from one table (the "one" side) and the corresponding records from another table (the "many" side), if they exist. It works well, but only in THAT query. In other words, if I run that query, the records show up as I ... 24 May 2010 12:21

Reminder - Microsoft Responds to the Evolution of Community
Microsoft Office Evolves Community as Part of Office 2010 Launch: As you know, this is a big year for Microsoft as we are launching the latest version of Office. Office 2010 is all about making it easy for you to get and use Office on your terms. Office 2010 lets you work from the office, from home, or at s... 20 May 2010 11:40

delete query
I would like to delete first 3 records of the table. I know that I can set criteria to delete certain records in the table, but are there any way to set criteria only the first 3 or 4 records? Your information is great appreciated, ... 20 May 2010 12:47

Updating text field to new numeric field & moving minus signto fr
Just for your future information as long as the field is not null you can use CDbl. CDbl("23.32-") returns -23.32 If you want to be careful you can use UPDATE [MyTable] SET [MyTable].[MyNumericField] = IIF(IsNumeric([MyTextField]),CDbl([MyTextField]),Null) Obviously, if you want zero or some other n... 20 May 2010 09:28