Search results

OK, so that removed all the zero's but still has the field Any idea how to remove that?

iif ([OT15] < 0, null, [OT15]) This didn't work. Still shows the column Also tried this iif ([OT15] = 0, null, [OT15]) This return nothing at all ie no records This does go into the Criteria right?

Thanks, not sure i'll be able to get my head round this but will have a look Still unsure what 'Value' would be to omit the whole field iif ([OT15] < 0, ???, [OT15]) The field is called OT15 Any idea what the above should look like? Here is what the table looks like

Hi, yes fields (columns), Thanks

Hi all Trying to create a query from a table. This table has some fields with zero all the way down for all the records and i wish for the query to omit the whole field if that is the case Can someone please advise how this can be done? Thanks

Hi Took your advise and made it into a linked table and using the APPEND qry instead Working brilliant, thanks for your help

Thanks CJ_London, i'll start reading up

HI all I am creating a ImportExportData macro that will link to my tables in the BE However the BE has a password. I was told this would require coding Would some kind soul please help me? I have even tried to 'convert macro to VB' and i get this: DoCmd.TransferDatabase acLink, "Microsoft...

Great, so it can be done. Would you know how to code? If not, i'll open a thread in the VBA section. Long winded i know but it's not my DB to strip apart, and this timesheet is just a small part. So i can do this FE 1 will run QRY to MAKETABLE Macro will link to the BE FE 1, 2 ,3 and 4 enter...

OK thanks bud I have been looking at creating a macro (ImportExportData) that can link to a table in the backend So temp table created in BE, and then i can create a macro to link it Works good BUT the BE has a password and i cannot see anywhere in the macro fields where i can set the...

Sorry don't know why. It was given to me like this. But has been working really well for years. Now due to the number of admin users, the requirement is to have 4 FE I'm confused now :) Just to highlight the challenge, all tables are linked apart from this temp one which is created from the FE...

Sorry forgot to mention, they are already split Old set-up was 1 X FE and 1 X BE. The TEMP table was not an issue as only 1 user New set-up is 4 X FE and 1 X BE. The TEMP table is therefore only created on the one of users, which means the other 3 cannot see this temp form Any suggestions how...

Hi there, let me explain. This DB was given to me to maintain but written many moons ago :) OK, so a temp table is created based on certain criteria's. These are timesheets. A form is then created based on this temp table Admin 1 will populate the timesheets for that week. Then the temp table...

Hi I have a make table query which creates the new table on the local front end. I have now split the DB, so need to know how I can get this query to make the table on the BE i.e. how do i link it Any ideas? Thanks

Thanks Plog, works very well.

Those in DEC and NOT in Jan are leavers who left in Jan. And those in Jan but NOT in Dec are new starters in Jan Hope this makes sense.

Thanks, i'll try this later

Thanks Plog I need to highlight those in Dec and not in Jan and vice versa. Any idea's how that can be done?

Thanks for all your help everyone. Here is a sample.

Thanks for this, but i have over 3000 ee's. The EE1 was an example. How would this query work for all ee's? Thanks for your help